Remote Analytics Engineer: Metrics & Data Quality

Elevated Hires; United States; On-site; USD 100,000 - 150,000; Full time

Job summary

Elevated Hires is seeking an Analytics Engineer (Mid-Level) to own the metric build pipeline in a remote US-based role. You will define metric meanings, write SQL that produces them, validate against claims data, and document results so they are trustworthy for both machines and humans.

You will maintain data marts, build metric templates, and develop Python/SQL pipelines while ensuring data quality and clear stakeholder communication.

Qualifications

• 3–5 years in analytics engineering, data engineering, or a quantitative analyst role owning metric definitions.
• Strong SQL skills including window functions, CTEs, and multi-table joins in large datasets.
• Python for data work (pandas, scripting, automation, testing; not just notebooks).
• Experience building metrics from raw transactional data and validating them against business expectations.
• Clear written communication; you’ll document metrics for engineers and business stakeholders.

Responsibilities

• Maintain and extend existing data mart builds: claims aggregation, financial metrics, clinical metrics, and curated analytical tables that power our SaaS platform.
• Author, test, and maintain metric SQL templates against our canonical data model (medical claims, pharmacy claims, eligibility, provider, plan design).
• Build and maintain data pipelines in Python and SQL (Redshift, PostgreSQL, S3-based integrations).
• Profile and validate third-party data feeds during vendor onboarding (new data sources land regularly).
• Investigate data quality issues from warehouse transformation logic through final output.
• Produce analytical deliverables for clients and internal stakeholders (PMPM trending, cohort analysis, cost drivers).
• Write clear documentation for metric definitions, data lineage, assumptions, and known limitations.
• Participate in monthly rotation for support triage (incoming tickets), release management, and mart build monitoring.
• Participate in code reviews and contribute to team standards.

Skills

SQL

Python

Metric definitions

Data profiling

Git

Tools

Redshift

PostgreSQL

S3

Job description

Elevated Hires is seeking an Analytics Engineer (Mid-Level) to own the metric build pipeline in a remote US-based role. You will define metric meanings, write SQL that produces them, validate against claims data, and document results so they are trustworthy for both machines and humans.

You will maintain data marts, build metric templates, and develop Python/SQL pipelines while ensuring data quality and clear stakeholder communication.