Senior Data Engineer - Analytics

Responsibilities

• Design, develop, and sustain robust ELT/ETL data pipelines using dbt Core and SQL for BigQuery targets.
• Create modular, well tested SQL models and Python-based transformations to support analytics, reporting, and ML feature generation.
• Implement data quality checks, lineage, and observability to ensure reliable analytics outputs and meet SLAs.
• Collaborate with product, analytics, and ML teams to define metric definitions and translate business requirements into efficient data models.
• Build and maintain RESTful APIs and integrations to surface curated datasets and features for internal and external consumers; utilize LLM APIs where applicable.
• Deploy and monitor data services and lightweight API endpoints on GCP, using Cloud Run and other serverless options when suitable.
• Optimize BigQuery performance and cost through partitioning, clustering, and query tuning.
• Document data models, transformation logic, and operational runbooks; mentor teammates on dbt, SQL, and analytics engineering best practices.

Requirements

• 3+ years of experience in analytics engineering, data engineering, or related roles building analytics pipelines and data models.
• Experience working with Healthcare Claims Data.
• Advanced SQL proficiency and strong Python experience for data transformation, orchestration, or testing.
• Proven dbt Core experience to build modular, tested analytics transformations and manage deployments.
• Solid experience with Google Cloud Platform, especially BigQuery, including query optimization and cost management.
• Experience building and integrating APIs; familiarity with LLM APIs and integrating large language model outputs into analytics or product workflows.
• Strong understanding of data modeling concepts, ETL/ELT patterns, data quality practices, and observability.
• Excellent communication skills and ability to collaborate across cross-functional teams to operationalize analytics.
• Nice to have: hands-on experience with Cloud Run, Vertex AI, and FastAPI for serving data or ML features; domain knowledge of healthcare claims and related data models.
• Authorization to work in the United States without sponsorship for a non-immigrant visa.

Technologies

• dbt Core
• SQL
• Python
• BigQuery
• Google Cloud Platform (GCP)
• Cloud Run
• Vertex AI
• FastAPI
• LLM APIs
• RESTful APIs

Position Overview

Salary: USD 165,000 - 190,000 per year. The Analytics Engineer role focuses on designing and implementing data models, transformation pipelines, and APIs that power dashboards, ML features, and downstream systems. You will work with data scientists, analysts, and engineers to standardize metrics, improve data quality, and enable self-service analytics across the organization.

Location

Location: Bristol, PA (remote) • 100% Remote