Senior Data Engineer - Analytics
Job Description
Everforth offers a 100% remote Senior Data Engineer - Analytics role that centers on turning data into reliable, actionable insights. You will design, build, and maintain analytics infrastructure, data models, ELT/ETL pipelines with dbt Core and SQL, and APIs that power dashboards, ML features, and self-service analytics. This position is remote, with collaboration across teams in Bristol, PA and beyond to translate business needs into scalable data solutions.
Position Overview: Join the data team to develop reliable, scalable analytics infrastructure that turns data into actionable insights. You will design data models, transformation pipelines, and APIs that empower dashboards, ML features, and downstream systems, collaborating with data scientists, analysts, and engineers to standardize metrics and improve data quality across the organization.
Responsibilities
- Design, develop, and maintain robust ELT/ETL data transformation pipelines using dbt Core and SQL targeting BigQuery.
- Author modular, tested SQL models and Python-based data transformations to support analytics, reporting, and ML feature generation.
- Implement data quality checks, lineage, and observability to ensure reliable analytics outputs and SLAs.
- Collaborate with product, analytics, and ML teams to define metric definitions and translate business requirements into performant data models.
- Build and maintain RESTful APIs and integrations to surface curated datasets and features for internal and external consumers; implement and consume LLM APIs where applicable.
- Deploy and monitor data services and lightweight API endpoints on GCP, leveraging Cloud Run and other serverless infrastructure when appropriate.
- Optimize performance and cost for BigQuery workloads through partitioning, clustering, and query tuning.
- Document data models, transformation logic, and operational runbooks; mentor teammates on best practices for dbt, SQL, and analytics engineering.
Requirements
- 3+ years of experience in analytics engineering, data engineering, or a related role building analytics pipelines and data models.
- Expert proficiency in SQL and strong experience with Python for data transformation, orchestration, or testing.
- Experience working with Healthcare Claims Data.
- 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 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.
- Nice to have: domain knowledge of healthcare claims and related data models.
- For this position, you must be currently authorized to work in the United States without the need for sponsorship for a non-immigrant visa.
Technologies
- dbt Core
- SQL
- Python
- BigQuery
- Google Cloud Platform (GCP)
- Cloud Run
- Vertex AI
- FastAPI
- RESTful APIs
- LLM APIs
Location: 100% Remote