Lead Analytics Engineer: Healthcare Claims, SQL & dbt
Location: Remote
Duration: 12+ Months
Client: 10 Pearls / Cohere Health
Job Summary
We are seeking a Senior Analytics Engineer with deep expertise in Healthcare Claims and Membership data to architect and optimize the transformation layers for a modern data platform. This role sits at the intersection of Data Engineering and Business Intelligence, where you will be responsible for taking raw healthcare data and modeling it into production-grade, modular datasets using dbt and SQL. You will act as a consultant to non-technical stakeholders including Actuaries and C-Suite teams to translate complex business requirements into scalable dimensional models within a Cloud Data Warehouse (Snowflake, BigQuery, or Redshift).
Key Responsibilities & Required Skills
Healthcare Data Transformation & Modeling
Claims & Membership Expert: Transform raw payer data, claims, and membership records into usable formats for end-user analytics.
Dimensional Modeling: Architect modular dbt models, dimensional structures, and semantic layers to standardize metrics across the organization.
Stakeholder Collaboration: Partner with Actuaries and Business Analysts to gather requirements and design data solutions that drive business value.
Production-Grade Analytics Engineering
dbt Mastery: Build, test, and optimize dbt models (Core or Cloud) using engineering best practices like CI/CD and Git.
Advanced SQL: Develop high-quality SQL transformations and reusable datasets focused on performance optimization.
Data Quality: Implement rigorous testing frameworks, validation logic, and lineage visibility to ensure "trusted data" for the ecosystem.
Cloud Infrastructure & Orchestration
Cloud Data Warehouse: Hands-on experience with Snowflake, BigQuery, or Redshift for large-scale healthcare data processing.
Orchestration: Familiarity with tools like Airflow, Dagster, or Prefect to schedule and operationalize transformation pipelines.
Modern Stack: Utilize AWS environments and modern software development workflows to manage data discoverability and reliability.
Mandatory Technical Skills
1. Healthcare Data Experience: Deep knowledge of Payer/Claims/Membership data.
2. Expert SQL & dbt: Proven experience building modular, production-grade pipelines.
3. Data Modeling: Expertise in dimensional modeling and semantic layer design.
4. Cloud Warehouse: Proficiency in Snowflake, BigQuery, or Redshift.
Thanks,
Aditya Jain | New York Technology Partners
Email: Direct: EXT: 482
Apply Now
Apply Now