Business Intelligence Engineer at Prometheus Federal Services
Fairfax, Virginia, United States — full-time
Position Summary
Prometheus Federal Services (PFS) is a trusted partner of federal health agencies. We are seeking a Business Intelligence (BI) Engineer to support the design, development, and delivery of data-driven solutions that enable informed decision-making across healthcare programs. This role will focus on building and maintaining Power BI dashboards, semantic models, and data pipelines that transform complex healthcare data into actionable insights. The BI Engineer will work closely with data engineers, analysts, and stakeholders to ensure data is accurate, performant, and aligned to business needs. The ideal candidate brings hands-on experience with Power BI, strong foundational data engineering skills, and an interest in working with healthcare data in a federal environment.
Essential Duties and Responsibilities
Power BI Reporting & Semantic Models
Develop, publish, and maintain Power BI reports, dashboards, and semantic models to support operational and executive decision-making.
Write and optimize DAX measures and calculations to support business logic and advanced analytical use cases.
Embed analytical outputs into dashboards and workflows to support real-time or near-real-time decision-making.
Assist in performance tuning of reports and datasets, including query optimization and refresh strategies.
Support governance and best practices related to Power BI deployment, versioning, and workspace management.
Data Modeling, ETL/ELT & Integration
Design and optimize data models (star schema, relationships, measures) to ensure performance, scalability, and usability.
Build and maintain data pipelines and transformations using SQL, Power Query (M), and other ETL/ELT tools.
Collaborate with data engineers and architects to integrate data from multiple sources, including databases, APIs, and enterprise data platforms.
Analytics, Data Science & AI/ML
Perform exploratory data analysis (EDA) to identify trends, patterns, anomalies, and key drivers within complex datasets.
Apply feature engineering and data preparation techniques to support analytical modeling and improve model performance.
Develop and implement statistical