BI & Analytics Analyst​/Data Engineer

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

• Partner with IT business stakeholders and operational leaders to design analyses that identify opportunities for improvement in care, assess adherence to clinical best practices, and measure outcomes.
• Help ensure agency data repositories provide consistent, reusable data by collaborating with key staff to develop, implement, and advise on data standards and best practices.
• Promote best-practice knowledge and enable business stakeholders to conduct self-service analysis rather than relying on IT-owned development.
• Own self-service reporting datasets, including DAX measures
  , data models
  , and row-level security
  .
• Translate business needs 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 in designing, developing, maintaining, and updating databases to meet 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.
• Develop 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 (
  Wheres cape RED
  ),
  SQL Server
  , and associated components.
• Define operational monitoring and alerting tools to ensure trusted, high-quality data flows 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 data quality processes with stakeholders.

• 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 Wheres cape OLAP
  ; experience with alternative OLAP solutions including Azure Analysis Service
  , Azure Data Lake
  , and Azure Synapse Analytics
  .
• Experience integrating or working with EHR data (reports, APIs, or data exports).
• Familiarity with star schema and 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 explaining data concepts clearly to non-technical stakeholders.
• Advanced skill set with the Microsoft Office suite (Power BI), SQL, and experience with EMR systems (hospice, homecare, and/or mental health) desired.

• SQL Server, T-SQL, ETL
• Power BI, DAX, Power Query
• Wheres cape OLAP, Wheres cape 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)
• EHR data, EMR systems
• Master data management

• Location: Rockville, MD (Hybrid)
• Experience: 5+ years
• Salary: USD 110, per year