Senior Analytics Engineer – BI & Data Visualization

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.