BI & Analytics Analyst/Data Engineer

The BI & Analytics Analyst/Data Engineer will lead engineering, development, support, and management of data and analytics solutions across the agency. This hybrid role splits effort between business intelligence delivery and hands-on data engineering, with ownership of the end-to-end analytics lifecycle and self-service Power BI reporting.

Location and Work Mode

Rockville, MD (hybrid)

Compensation

USD 110,000 - 132,000 per year

Key Responsibilities

• Partner with IT business stakeholders and operational leaders to design analyses that identify opportunities for improvement in care, evaluate adherence to clinical best practice, and measure outcomes.
• Collaborate with key staff to develop and implement standards and best practices that help ensure agency data repositories support consistent and reusable data.
• Promote best-practice knowledge and adoption among business stakeholders to enable self-service analysis rather than IT-owned development.
• Own self-service reporting datasets, including DAX measures, data models, and row-level security.
• Translate business needs into analytical deliverables, manage stakeholder expectations, and iterate based on feedback.
• Monitor report usage and data quality, proactively identifying and resolving issues.
• Document data definitions, metric logic, and report lineage to support a data-literate culture.
• Use technical tools to query, manipulate, and summarize data from multiple data sources.
• Assist with designing, building, maintaining, and updating databases aligned with department and organizational needs.
• Design and build star schema data warehouse objects in SQL Server, including fact tables, dimension tables, and aggregate layers.
• Write and maintain T-SQL stored procedures, ETL pipelines, and staging-to-DWH data loads.
• Create and maintain source-to-target mapping documentation for new data domains.
• Integrate data from source systems.
• Contribute to data quality, pipeline reliability, and warehouse performance optimization.
• Support self-service analytics adoption by building clean, well-documented datasets.
• Document current data architecture, define logical and physical data, and establish an agency data blueprint.
• Manage and support the data warehouse solution (Wherescape RED) and SQL Server along with related components.
• Define operational monitoring and alerting tools to ensure trusted, high-quality data moves from source systems to consumption.
• Establish best-practice standards and processes for data automation, orchestration, and transformation.
• Identify, design, implement, and manage a master data management solution for client and employee subjects, including defining data quality standards and operational DQ processes.

Required Qualifications

• Bachelor’s degree required
• 5-7+ years of experience in a BI, analytics, or data engineering role
• Strong proficiency in SQL Server and T-SQL, including stored procedures, window functions, and query optimization
• Hands-on experience building and maintaining Power BI reports and semantic models (DAX, Power Query)
• Hands-on experience with Wherescape OLAP; experience with alternative OLAP solutions (Azure Analysis Service, Azure Data Lake, Azure Synapse Analytics)
• Experience integrating or working with EHR data (reports, APIs, or data exports)
• Familiarity with star schema / dimensional modeling concepts (Kimball methodology a plus)
• Python experience for data wrangling, automation, or pipeline scripting
• Experience with Microsoft Master Data Services (MDS), including defining entities and creating business rules
• Experience with Microsoft Data Quality Services (DQS) and SQL Server Integration Services (SSIS)
• Comfortable working across the full analytics stack, from raw source data to end-user reporting
• Strong communication skills, including the ability to explain data concepts clearly to non-technical stakeholders

Preferred Skills

• Master’s degree highly preferred
• Advanced skill set with Microsoft Office suite (Power BI), SQL, and experience with EMR systems (hospice, homecare, and/or mental health) desired

Technology Focus

• SQL Server, T-SQL, Power BI, DAX, Power Query
• Wherescape OLAP, Wherescape RED
• Azure Analysis Service, Azure Data Lake, Azure Synapse Analytics
• Python
• Microsoft Master Data Services (MDS), Microsoft Data Quality Services (DQS), SQL Server Integration Services (SSIS)
• ETL, EHR data, EMR systems
• Master data management