Altarum is a nonprofit organization focused on improving the health of individuals with fewer financial resources. They are seeking a Senior Analytics Engineer – BI & Data Visualization to translate complex data into actionable insights for decision-makers, while leading the design and delivery of data visualizations across various health domains.
Responsibilities:
- 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
Requirements:
- 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)