Senior Analytics Engineer – BI & Data Visualization

Altarum | Data & AI Center of Excellence (CoE)

Altarum is seeking a Senior Analytics Engineer – BI & Data Visualization to serve as the “last-mile translator” between advanced data systems and the decision-makers who rely on them. In this pivotal role, you’ll turn raw data pipelines, evaluation outputs, causal inference models, and ML predictions into trusted, actionable insights for federal and state partners.

If you love semantic modeling, BI design, dbt craftsmanship, and telling complex stories with data, this role puts you at the center of Altarum’s insight delivery ecosystem.

Analytics Engineering (dbt, SQL, semantic modeling)

Data Visualization Leadership (Power BI, UX, narrative design)

ML & Evaluation Interpretability

Shared-services enablement across all Altarum divisions

You will set the standards, build the templates, and create the reusable metrics that power insights organization-wide.

• Own dbt projects across public health, behavioral health, Medicaid, maternal/child health, and SDOH domains.
• Create and manage semantic models, data contracts, macros, and versioned transformations.
• Define and govern reusable metrics: dimensions, denominators, time logic, risk adjustment, and composite measures.
• Build star schemas and conformed dimensions optimized for Power BI, including RLS and deployment pipelines.
• Work closely with Data Platform Engineers to ensure pipelines are analytics-ready and performant.

• Lead design and delivery of executive-ready dashboards using Power BI, with strong UX and accessibility (Section 508).
• Build dashboards in Power BI (primary) with optional support for Tableau/Looker.
• Translate complex methods—equity stratifications, quasi-experimental results, small-area estimation, NLP outputs—into policy-ready visuals.
• Create ML explainability dashboards (SHAP, LIME, bias metrics, drift/calibration).
• Partner with creative and UX teams to produce visually compelling and context-appropriate designs.

• Implement rigorous validation and BI QA (dbt tests, performance testing, dashboard monitoring).
• Maintain a centralized metrics catalog, semantic dictionary, and visualization standards.
• Manage BI versioning, documentation, and data lineage in alignment with federal requirements.
• Develop Power BI themes, navigation patterns, KPI templates, and reusable dbt + BI starter projects.

• Develop and deliver training for Analytics Engineering and BI best practices.
• Provide pairing sessions, workshops, and visualization coaching across divisions.
• Publish accelerator packages (dbt bundles, semantic models, Power BI templates) to improve delivery speed.
• Instrument BI usage analytics and run structured feedback cycles with stakeholders.

• Time-to-dashboard ≤ 4 weeks from modeled data to stakeholder review
• Dashboard adoption, usage, and stakeholder satisfaction
• Increased metric standardization and catalog coverage
• Reuse of templates and semantic models across ≥3 divisions

• 5–8 years as an Analytics Engineer, BI Lead, or similar role
• Strong proficiency in SQL and dbt (models, tests, macros, documentation, CI/CD)
• Mastery of Power BI
  , including DAX, Power Query (M), semantic models, dataflows, RLS, and deployment pipelines
• Strong experience with data modeling, dimensional design, and performance tuning
• Ability to present analytics solutions and incorporate customer feedback
• Strong Git workflows, code review, and documentation discipline

• Familiarity with public health or Medicaid/Medicare domains and equity or evaluation methods
• Experience integrating ML outputs into dashboards (SHAP, drift, feature importance)
• Python/R for analysis or geospatial mapping (ArcGIS/QGIS)
• Knowledge of FHIR-to-analytics models, USCDI+, or TEFCA concepts
• Experience with AWS-based data sources (Redshift, Athena, S3/Parquet) or Databricks/Snowflake
• Experience developing BI/analytics training or design systems
• Power BI for Government experience (
  strongly preferred
  , not required)

• At this time, we will only accept candidates who are presently eligible to work in the United…