Senior Data Engineer - Analytics

The Senior Analytics Engineer will build reliable and scalable analytics infrastructure, data models, transformation pipelines, and APIs that power dashboards, ML features, and downstream systems. The role collaborates with data scientists, analysts, and engineers to standardize metrics and enable self-service analytics.

Responsibilities

• Design, develop, and maintain robust ELT/ETL data transformation pipelines using dbt Core and SQL targeting BigQuery.
• Create modular, 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; implement and integrate LLM APIs where applicable.
• Deploy and monitor data services and lightweight API endpoints on Google Cloud Platform, leveraging Cloud Run and other serverless options when appropriate.
• Optimize BigQuery performance and cost through partitioning, clustering, and query tuning.
• Document data models, transformation logic, and runbooks; mentor teammates on dbt, SQL, and analytics engineering best practices.

Requirements

• Three or more 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 solid Python experience for data transformation, orchestration, or testing.
• Proven experience with dbt Core to build modular, tested analytics transformations and manage deployments.
• Strong Google Cloud Platform experience, 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.
• Solid understanding of data modeling concepts, ETL/ELT patterns, data quality practices, and observability.
• Excellent communication 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.
• Authorized to work in the United States without sponsorship for a non-immigrant visa.

Technologies

• dbt Core
• SQL
• Python
• BigQuery
• Google Cloud Platform
• Cloud Run
• Vertex AI
• FastAPI
• LLM APIs

Location

Bristol, PA (remote)