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.

What This Role Blends

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.

What You'll Do:
• 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.

Data Visualization & Storytelling
• 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.

Quality, Governance, & Standards
• 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.

Enablement & Scale
• 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.

Success Metrics (KPIs)
• 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

What You'll Bring:
• 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

Preferred:
• 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)

Logistical Requirements:
• At this time, we will only accept candidates who are presently eligible to work in the United States and will not require sponsorship.
• Our organization requires that all work, for the duration of your employment, must be completed in the continental U.S. unless required by contract.
• If you’re near one of our offices (Arlington, VA; Silver Spring, MD; or Novi, MI), you’ll join us in person one day every other month (6 times per year) for a fun, purpose-driven Collaboration Day. These days are filled with creative energy, meaningful connection, and team brainstorming!
• Must be able to work during Eastern Time unless approved by your manager.
• Employees working remotely must have a dedicated, ergonomically appropriate workspace free from distractions with a mobile device that allows for productive and efficient conduct of business.

Altarum is a nonprofit organization focused on improving the health of individuals with fewer financial resources and populations disenfranchised by the health care system. We work primarily on behalf of federal and state governments to design and implement solutions that achieve measurable results. We combine our expertise in public health and health care delivery with technology development and implementation, practice transformation, training and technical assistance, quality improvement, data analytics, and applied research and evaluation. Our innovative solutions and proven processes lead to better value and health for all.

Altarum is an equal opportunity employer that provides employment and opportunities to all qualified employees and applicants without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, or any other characteristic protected by applicable law.