Senior Data Engineer - Analytics

Everforth invites you to join as an Analytics Engineer, shaping data models, transformation pipelines, and APIs that power dashboards, ML features, and downstream systems. This Bristol, PA based role supports remote work and collaborates across data science, analytics, and engineering teams to standardize metrics, elevate data quality, and enable self service analytics across the organization.

Responsibilities

• Design, develop, and maintain reliable ELT/ETL pipelines using dbt Core and SQL to target 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 dependable analytics outputs and service levels.
• Partner 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; integrate 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 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.
• Expert-level SQL proficiency and strong Python experience for data transformation, orchestration, or testing.
• Proven experience using dbt Core 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 incorporating 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.
• Authorized to work in the United States without sponsorship.

Technologies

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