Software Engineer, Workforce Insights & Analytics

CVS Health; Indianapolis (IN); On-site; USD 83,000 - 222,000; Full time

Job summary

CVS Health is seeking a Software Engineer to join Workforce Insights, building analytics platforms with Python, SQL, and Airflow. You will design and operate BigQuery data transformations, contribute to Superset dashboards, and work with HR data to deliver governance-aware metrics.

Responsibilities include implementing data pipelines, collaborating with data engineers and analysts, and ensuring code quality, tests, and secure releases.

Qualifications

• 3+ years of professional software development experience.
• 3+ years of Python or a comparable general-purpose language, including writing readable, maintainable code and automated tests.
• 3+ years of experience building or integrating APIs, services, data workflows, or other production systems; ability to reason about interfaces and failure modes.
• 3+ years of experience working across application code, data transformations, and operational tooling as product needs require.
• 2+ years of experience demonstrating advanced SQL expertise, preferably in BigQuery, including scripting, partitioning, clustering, materialized views, query optimization, and cost awareness.
• 2+ years of experience with Kimball dimensional modeling, including grain, conformed dimensions, slowly changing dimensions, bridge tables, factless facts, and fact additivity.
• 2+ years of experience with production experience with Airflow or Cloud Composer and Python for ETL, automation, data quality, and troubleshooting.
• 2+ years of hands‑on experience with cloud data platforms; GCP is strongly preferred, with working knowledge of BigQuery, Cloud Storage, IAM, service accounts, Secret Manager, and related security concepts.
• 1+ year of experience with an enterprise semantic or BI layer such as Superset, ThoughtSpot, Looker, Tableau, Power BI, or similar, including governed metrics and row-level security.
• 1+ year of experience with Git, code review, and CI/CD practices, preferably GitHub Actions across multiple environments.
• 1+ year of experience tracing data or metric discrepancies to root cause and explain findings to both technical and non-technical audiences.

Responsibilities

• Design, implement, test, and maintain software features across Python, SQL, and workflow code.
• Translate product and operational requirements into technical tasks; collaborate with data engineers, analysts, and HR partners on expected behavior and acceptance criteria.
• Participate in code reviews, improve existing code where appropriate, and write automated tests for business logic, data contracts, and integrations.
• Build and maintain BigQuery transformations and models as part of the product, following established conventions for grain, keys, history, and query efficiency.
• Develop and operate Airflow workflows, Python automation, SQL assets, and deployment-related code used by the product.
• Use the established GitHub Actions release process across dev, pdev, and prod, including environment placeholders; follow existing IAM and service-account controls.
• Diagnose defects using logs, tests, and system behavior; contribute fixes, monitoring, and operational documentation, and elevate production risks promptly.
• Support safe releases through the team's review, validation, rollback, and incident processes.
• Keep technical documentation current for the components you change, including interfaces, data lineage, and operational procedures.

Skills

Python

SQL

Airflow

BigQuery

GitHub Actions

Data modeling

Testing

Security

ETL

Collaboration

Education

Bachelor's degree in Computer Science or related field

Tools

Superset

Power BI

Looker

GitHub

Cloud Composer

GCP

Job description

CVS Health is seeking a Software Engineer to join Workforce Insights, building analytics platforms with Python, SQL, and Airflow. You will design and operate BigQuery data transformations, contribute to Superset dashboards, and work with HR data to deliver governance-aware metrics.

Responsibilities include implementing data pipelines, collaborating with data engineers and analysts, and ensuring code quality, tests, and secure releases.