BI & Analytics Analyst/Data Engineer

Drive end-to-end BI and data engineering for agency analytics solutions in a hybrid role split between Power BI delivery and hands-on engineering.

Responsibilities

• Partner with IT business teams and operational leaders to design analyses that support improvement in care, assess adherence to clinical best practice, and measure outcomes
• Collaborate with key staff to develop, implement, and guide standards and best practices so agency data repositories produce consistent, reusable data
• Enable business stakeholders to self-serve analytics by promoting best-practice knowledge and supporting adoption patterns that reduce IT-owned development
• Own self-service reporting datasets, including DAX measures, data models, and row-level security
• Translate business requirements into clear 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 across the agency
• Use technical tools to query, manipulate, and summarize data from multiple data sources
• Assist with designing, developing, maintaining, and updating databases aligned to 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 the agency data blueprint
• Manage and support the data warehouse solution including Wherescape RED and SQL Server (plus associated components listed in the technologies stack)
• Define operational monitoring and alerting tools to ensure trusted, high-quality data delivery from source systems through 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; define data quality standards and operational DQ processes with stakeholders

Requirements

• Bachelor’s degree required; Master’s degree highly preferred
• 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 creation of 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 explaining data concepts clearly to non-technical stakeholders
• Advanced Microsoft Office skills (including Power BI), plus SQL; experience with EMR systems (hospice, homecare, and/or mental health) desired

Technologies

• 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

Job Details

• Location: Rockville, MD (hybrid)
• Salary: USD 110,000 - 132,000 per year
• Pay Type: Salary