Serigor
posted 3 months ago
The client is seeking a Senior BI Developer with extensive experience in Power BI and SQL to join their DevOps team. This role is crucial for the implementation of a new comprehensive child welfare information system (CCWIS). The successful candidate will be responsible for designing and developing reports using Power BI, as well as creating complex SQL queries. The position requires the candidate to work onsite three days a week in Washington, DC, while also allowing for remote work options. The ideal candidate will possess excellent communication skills, both written and verbal, as they will collaborate closely with social workers and system developers to identify and address data quality issues. Additionally, the candidate will oversee the data conversion process from the legacy system to the new system, ensuring adherence to the project schedule. In this role, the BI Developer will conduct thorough analyses of data from multiple sources, identifying processes to validate the information. They will coordinate the client data management governance structure, perform necessary analysis tasks, and support client staff in implementing recommendations. The candidate will gather and translate business requirements into detailed, production-level technical specifications, creating robust data models and enhancing data analysis features. They will also collect reporting requirements from program staff, prototype reports, and collaborate with other vendors to deploy reports using the client’s Dynamics 365 platform. The role involves writing complex data joins to establish data measures across multiple tables, modifying existing reports, and developing new reports based on database analysis. Quality assurance analysis on reports will be performed to ensure accuracy and alignment with business needs. Furthermore, the candidate will manage Azure Data Services, including Synapse/Synapse Links, Azure SQL Pool, and Data Lake, and oversee the deployment of reports.