Sr Analytics Engineer: Data Modeling & Quality Lead Remote

Visa Hunt; United States; On-site; USD 140,000 - 200,000; Full time

Benefits offered by this job

Fully remote

Flexible schedule

Exposure to senior leaders

AI-first environment

Job summary

Arcadia seeks a Lead Analytics Engineer — Data Modeling & Quality to own DBT models and SQL quality across the data pipeline, from ingests to gold datasets. You will ensure trusted data for population health analytics and partner with Data Engineering on architecture decisions.

You will design validation, triage data quality alerts, and drive continuous improvements across the end-to-end data stack, including health plan, provider data, and downstream consumers.

Qualifications

• Advanced SQL: window functions, complex CTEs, performance tuning on columnar databases.
• DBT: authoring models, tests, macros, and YAML documentation; familiarity with incremental strategies.
• Healthcare data literacy: familiarity with claims data (professional, institutional, pharmacy), clinical data and quality dimensions.
• Data quality mindset: differentiate source data issues from transform issues and communicate data quality findings clearly.

Responsibilities

• Author, review, and maintain DBT models from ingest through bronze and silver.
• Help clients understand their data model, assumptions, and limitations.
• Troubleshoot and fix issues, then write DBT tests to catch issues proactively.
• Optimize SQL performance for slow-running jobs.
• Partner with Data Engineering on Hudi table design, partition strategy, and incremental patterns.

Skills

Advanced SQL

DBT

Spark/Hudi

Data modeling

Data quality

Healthcare data literacy

Python scripting

Argo Workflows

Airflow

Git/GitHub

SQL optimization

Education

Bachelor's or Master's in CS/Statistics/Economics

Tools

DBT-Spark

Amazon Redshift

AWS Athena

Hudi

Grafana

Jira

Job description

Arcadia seeks a Lead Analytics Engineer — Data Modeling & Quality to own DBT models and SQL quality across the data pipeline, from ingests to gold datasets. You will ensure trusted data for population health analytics and partner with Data Engineering on architecture decisions.

You will design validation, triage data quality alerts, and drive continuous improvements across the end-to-end data stack, including health plan, provider data, and downstream consumers.