Senior Analytics Engineer: Data Modeling Governance Remote

machinifyinc; United States; Remote; USD 170,000 - 200,000; Full time

Benefits offered by this job

US-based remote work

Job summary

machinifyinc is seeking a senior analytics engineer to turn messy operational healthcare data into trusted metrics for business leaders. The role focuses on data modeling, measurement governance, and stakeholder‑facing reporting across a unified analytics warehouse spanning multiple platforms and client workflows, with hands-on work in dbt, SQL, and Power BI.

You will collaborate with finance, operations, and client teams, own metric definitions end-to-end, and build governance around the

Qualifications

• 6+ years in analytics engineering, BI engineering, data engineering, or business analysis with production ownership of the models and metrics shipped.
• Expert SQL with strong dimensional modeling instincts and a reflex for spotting grain mismatches.
• Production dbt experience covering models, tests, macros, exposures, documentation, and CI.
• Hands-on experience with a cloud lakehouse or warehouse; Databricks and Spark SQL preferred.
• Demonstrated BI ownership beyond underlying tables, with Power BI and DAX strongly preferred and Tableau, Looker/LookML, MetricFlow, or Cube as credible substitutes.
• Stakeholder fluency: run requirements conversations, frame data issues as business risk, and challenge incorrect metrics diplomatically.

Responsibilities

• Run discovery sessions with business stakeholders to translate ambiguous requests into acceptance criteria and testable definitions.
• Model noisy operational data into certified dimensional models using a Databricks bronze → silver → gold architecture in dbt and SQL.
• Own metric definitions end-to-end, consolidating redundant re-derivations into a single governed semantic layer.
• Build and maintain the Power BI semantic models, dashboards, and paginated reports, including refresh health and currency.
• Implement observability for models: freshness checks, statistical anomaly detection, value-drift monitoring, and CI-enforced regression guards.
• Design and own orchestration through dbt Cloud jobs and Airflow DAGs, ensuring dependable incremental runs and correct dependency ordering.
• Document work in design docs, model documentation, and handoff packets so successors can understand choices without re-deriving them.
• Codify recurring work into AI-assisted, testable workflows and supervise outputs from coding agents.

Skills

Analytics engineering

SQL

Dimensional modeling

dbt

Power BI

Stakeholder management

Git & PR discipline

Airflow

Databricks

Spark SQL

Tools

Databricks

dbt Cloud

Power BI

Airflow

Git

Job description

machinifyinc is seeking a senior analytics engineer to turn messy operational healthcare data into trusted metrics for business leaders. The role focuses on data modeling, measurement governance, and stakeholder‑facing reporting across a unified analytics warehouse spanning multiple platforms and client workflows, with hands-on work in dbt, SQL, and Power BI.

You will collaborate with finance, operations, and client teams, own metric definitions end-to-end, and build governance around the