Senior Analytics Engineer – BI, Data Visualization
Job Description:
• 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.
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**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)
Benefits:
• Competitive Medical, Dental and Optical plans
• Generous Paid Time Off, 8 Company observed holidays plus 3 floating holidays
• Tuition Assistance
• 401K Plan (3% employer contribution plus opportunity for gainsharing)
• Life, AD&D & Disability coverage
• A flexible work environment
Apply tot his job
Apply To this Job
• 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.
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**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)
Benefits:
• Competitive Medical, Dental and Optical plans
• Generous Paid Time Off, 8 Company observed holidays plus 3 floating holidays
• Tuition Assistance
• 401K Plan (3% employer contribution plus opportunity for gainsharing)
• Life, AD&D & Disability coverage
• A flexible work environment
Apply tot his job
Apply To this Job