Senior Data Engineer - Analytics

Senior Data Engineer in Analytics to design data models, ELT/ETL pipelines, and APIs powering dashboards, ML features, and downstream systems.

Responsibilities

• Architect, implement, and maintain scalable ELT/ETL pipelines using dbt Core and SQL for BigQuery.
• Create modular, tested SQL models and Python transformations for analytics, reporting, and ML feature generation.
• Establish data quality checks, lineage, and observability to meet analytics SLAs.
• Partner with product, analytics, and ML teams to define metrics and translate business requirements into efficient data models.
• Develop and maintain RESTful APIs and integrations to surface curated datasets and features for internal and external consumers; integrate LLM APIs where applicable.
• Deploy and monitor data services and lightweight API endpoints on GCP, using Cloud Run and other serverless options as suitable.
• Tune BigQuery performance and cost through partitioning, clustering, and query optimization.
• Document data models, transformation logic, and 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.
• Advanced SQL skills and solid Python experience for transformations, orchestration, or testing.
• Experience working with Healthcare Claims Data.
• Hands-on dbt Core experience to build modular, tested analytics transformations and manage deployments.
• Strong Google Cloud Platform expertise, especially BigQuery, including query optimization and cost management.
• Experience building and integrating APIs; familiarity with LLM APIs and integrating their outputs into analytics or product workflows.
• Solid understanding of data modeling concepts, ETL/ELT patterns, data quality practices, and observability.
• Excellent communication and collaboration skills to operationalize analytics across cross-functional teams.
• Nice to have: hands-on experience with Cloud Run, Vertex AI, and FastAPI for serving data or ML features; healthcare claims domain knowledge.
• Must be authorized to work in the United States without visa sponsorship.

Technologies

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

Location

Bristol, PA (remote) • 100% Remote

Position Overview

Role overview: an experienced Analytics Engineer to build reliable, scalable analytics infrastructure that converts data into actionable insights. The focus is on designing data models, transformation pipelines, and APIs that power dashboards, ML features, and downstream systems. You will partner with data scientists, analysts, and engineers to standardize metrics, improve data quality, and enable self service analytics across the organization.