Data Engineer I

2 hours, 26 minutes ago
Full-time
Entry Level
Software Development
Capital Rx

Capital Rx

Capital Rx provides comprehensive health benefit management and transparent pharmacy benefit management solutions, integrating various healthcare services to support millions of plan members across diverse sectors.

Health Care Providers & Services
251-1K
Founded 2017

Description

  • Partner with operational and analytics teams to translate business needs into analytics-ready data models, curated data marts, and reusable datasets.
  • Build and maintain dbt projects across staging, intermediate, and mart layers, including macros, exposures, packages, and source freshness.
  • Design and evolve dimensional data models, including facts, dimensions, grain, and slowly changing dimension patterns.
  • Own metrics definitions end to end, including KPI logic, naming standards, calculation rules, governance, and semantic layer consistency.
  • Implement data quality checks and monitoring using dbt tests, constraints, anomaly checks, and observability practices.
  • Create documentation and enablement materials such as dbt docs, lineage, data dictionaries, metric definitions, and onboarding guides.
  • Optimize Snowflake warehouse performance and cost through SQL tuning, incremental models, materializations, and efficient data design.
  • Use Git-based development practices, peer review, CI checks, versioning, and environment promotion to deploy changes safely.
  • Investigate and resolve data issues to protect system reliability and data integrity.
  • Support critical analytics data products and participate in on-call coverage as needed.

Requirements

  • Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent practical experience.
  • Strong SQL skills and experience building analytics datasets in a modern cloud data warehouse, with Snowflake preferred.
  • Hands-on experience with dbt Core, including model development, tests, documentation, macros, and deployments.
  • Solid understanding of data modeling concepts, including dimensional/Kimball modeling, facts, dimensions, grain, and slowly changing dimensions.
  • Experience defining and managing metrics, including translating business logic into KPI definitions and maintaining metric governance.
  • 1+ years of experience delivering production-grade analytics models, marts, or BI-ready datasets; internships or co-ops may be considered depending on leveling.
  • Ability to collaborate effectively with technical and non-technical stakeholders and communicate clearly in documentation and discussions.
  • Self-motivated, detail-oriented, and able to solve complex technical challenges while delivering high-quality work.
  • Experience in healthcare, PBM, insurance, or other regulated data environments is preferred.
  • Deep familiarity with Snowflake and experience working across multiple warehouses or databases such as Redshift or Postgres is preferred.
  • Familiarity with semantic or metrics layer patterns and enabling KPI consumption across BI tools is preferred.
  • Experience with CI/CD for analytics and data observability or monitoring practices is preferred.
  • Working knowledge of Python for data tooling or analytics enablement is preferred.

Benefits

  • Salary range of $100,000 to $120,000 USD.
  • Opportunity to work on healthcare data infrastructure for a mission-driven enterprise health technology company.
  • Remote or flexible work details are not specified in the posting.
  • Equal employment opportunity and a workplace committed to diversity and inclusion.
  • Application privacy practices and data retention details are provided by the company.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Data Engineer

Dropbox 1K-5K Internet Software & Services

Dropbox is seeking a Data Engineer for its Analytics Data Engineering team within Data Science & AI Platform to build new, large-scale analytics pipelines and data architecture from the ground up using modern big data technologies.

Apache Airflow Apache Spark C++ Databricks Java Python Scala SQL
11 minutes ago

Staff Data Platform Engineer

Typeform 251-1K Internet Software & Services

Typeform is hiring a Staff Data Platform Engineer to lead the architecture and ownership of its data and AI platform, supporting near-real-time pipelines, governance, and infrastructure for AI-driven products.

CI/CD GitOps HubSpot Kafka Machine Learning Microservices OpenTelemetry Python SQL Terraform
1 hour, 11 minutes ago

Senior Software Engineer II, Data Platform

instacart.careers 1K-5K Internet Software & Services

Instacart is hiring a Senior Software Engineer to shape the data platform behind its grocery delivery business, focusing on secure, scalable infrastructure that supports data use across teams and products.

Apache Airflow Apache Spark ClickHouse dbt Hadoop Hive Kafka PostgreSQL Python Ruby on Rails Scala Snowflake SQL
1 hour, 11 minutes ago

Senior Data Engineer

Correlation One 251-1K Professional Services

Correlation One is seeking a Senior Data Engineer to build and operate analytics-ready data systems that support decision-making across its workforce training organization.

Apache Airflow CI/CD dbt GCP GitHub Python REST API SQL Terraform
1 hour, 26 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers