Description

You will design and develop reports and complex queries as part of a DevOps team implementing a new child welfare information system.

Responsibilities

• Analyze data from multiple sources to identify validation processes and resolve data quality issues.
• Translate business requirements into technical specifications, data models, and analysis features.
• Prototype and deploy reports using the 365Dynamics platform.
• Write complex SQL joins to establish data measures across multiple tables.
• Oversee data conversion from legacy systems to the new system according to project schedules.
• Perform QA analysis to ensure report accuracy and alignment with business needs.

Required Skills

• 14+ years of experience in data development and analysis.
• Extensive experience designing and developing reports using Power BI.
• Expertise in creating complex SQL queries and data joins.
• Experience managing Azure Data Services, including Synapse, Synapse Links, Azure SQL Pool, and Data Lake.
• Proficiency with the 365Dynamics platform.
• Ability to work onsite in Washington, DC, 4 days a week.
• Strong written and verbal communication skills for collaborating with social workers and developers.
• Bachelor's degree in IT, a related field, or equivalent experience.

Key Skills

Education

Bachelor's degree