Lead Analytics Engineer - Data Modeling & Quality

2 months, 1 week ago
Full-time
Lead
Data Science and Analytics
Arcadia

Arcadia

Arcadia provides a healthcare data platform that enables organizations to unify diverse data sources, derive actionable insights through analytics, and enhance patient outcomes by delivering high-quality care experiences.

IT Services
251-1K
Founded 2002
$154M raised

Description

  • Author, review, and maintain dbt models using Spark/Hudi across ingest, bronze, and silver layers.
  • Help clients understand data model assumptions and limitations through intentional validation.
  • Troubleshoot and fix data issues, then create dbt tests to catch problems proactively.
  • Optimize SQL performance for slow-running jobs.
  • Partner with Data Engineering on Hudi table design, partition strategy, and incremental patterns.
  • Triage and classify data quality alerts, distinguishing source-level issues from transform-layer failures.
  • Design and maintain volume monitors and data quality monitors such as null rate, distribution, and future-date checks.
  • Author and apply clinical and claims data quality rules across silver and gold layers.
  • Conduct quality reviews for connector promotions, including silver entity coverage and transformation correctness.
  • Own the ticket queue for data quality, attribution, hierarchy, and customer-specific issues, and write clear customer-facing findings.
  • Lead data quality reviews during connector installation and promotion from UAT to production.
  • Partner with Data Engineering on root-cause triage for ingress anomalies and silver table issues.
  • Coordinate with the Measure Implementation Team when data quality issues affect quality measure scores.
  • Contribute to and enforce data modeling standards across teams.

Requirements

  • Bachelor's or Master's degree in Computer Science, Statistics, Business, Economics, or a related field.
  • Advanced SQL experience, including window functions, complex CTEs, aggregation patterns, and performance tuning on columnar databases.
  • Hands-on dbt experience authoring models, tests, macros, and YAML documentation.
  • Familiarity with incremental strategies in dbt.
  • Working knowledge of healthcare claims data, clinical EHR entities, and common data quality dimensions such as member months, coverage rates, and null patterns.
  • Ability to differentiate source data issues from transform issues and design systematic validation checks.
  • Strong communication skills for translating technical findings to clients and non-technical stakeholders.
  • Strong analytical judgment for identifying anomalies in data distributions.
  • Ability to manage several projects simultaneously while using AI tooling to stay organized and efficient.
  • Willingness to learn and apply AI tools for operational efficiency.
  • Experience with Spark SQL and the Hudi table format is preferred.
  • Familiarity with data quality monitoring tools is preferred.
  • Comfort operating in an AI-first environment using Claude is preferred.
  • Exposure to population health analytics concepts such as HEDIS measures, risk adjustment, and value-based care metrics is preferred.
  • Python scripting experience for data investigation and automation is preferred.
  • Experience with Argo Workflows or similar orchestration platforms is preferred.
  • Healthcare data standards knowledge such as ICD-10, CPT, NDC, LOINC, and NPI is preferred.

Benefits

  • $160,000 - $185,000 annual salary.
  • Flexible, fully remote work environment.
  • Opportunity to work alongside a talented, diverse, mission-driven team.
  • Exposure to senior leaders.
  • Access to cutting-edge AI tools in an AI-first environment.
  • Opportunity to make a meaningful impact on healthcare data quality and patient care decisions.
  • Work at a fast-growing company recognized by industry analysts.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Analytics Engineer (Remote - Brazil)

Loadsmart 251-1K Air Freight & Logistics

Loadsmart is hiring a remote Analytics Engineer in Brazil to expand AI features across its data and analytics platform for internal teams and data products.

Generative AI Machine Learning Pandas Python SQL
11 hours, 34 minutes ago

Senior Data & Analytics Engineer, Domain Enablement (R5536)

Bitly 51-250 Internet Software & Services

Shield AI is seeking a Senior Data & Analytics Engineer to build governed Databricks-based data models and semantic assets that enable self-service analytics across business domains.

Apache Spark Databricks Python SQL
11 hours, 49 minutes ago

Senior Analytics Engineer - US (Remote)

Luxury Presence 251-1K Real Estate

Luxury Presence is hiring a Senior Analytics Engineer to build the data foundation for decision-making across GTM, Product, Finance, People, and Operations in a fast-growing real estate AI platform.

Apache Airflow CI/CD dbt GCP Git LLM Mixpanel Python Salesforce Snowflake SQL Statistics
2 days, 11 hours ago

Senior Analytics Engineer - CANADA (Remote)

Luxury Presence 251-1K Real Estate

Luxury Presence is hiring a Senior Analytics Engineer to build the analytics foundation that supports decision-making across go-to-market, product, finance, people, and operations teams.

Apache Airflow CI/CD dbt GCP Git LLM Mixpanel Python Salesforce Snowflake SQL Statistics
2 days, 11 hours ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers