Software Engineer - Workforce Insights

We’re building a world of health around every individual — shaping a more connected, convenient and compassionate health experience. At CVS Health®, you’ll be surrounded by passionate colleagues who care deeply, innovate with purpose, hold ourselves accountable and prioritize safety and quality in everything we do. Join us and be part of something bigger – helping to simplify health care one person, one family and one community at a time.

Position Summary

Workforce Insights is the governed technology platform supporting HR Insights Organizational Health dashboard, its drill-down experiences, and future business intelligence products. It brings together Big Query data models, governed views, Airflow pipelines on Cloud Composer, Git Hub Actions deployments, and a semantic layer in Apache Superset.

This Software Engineer will develop and operate software across the workforce analytics product. The work spans Python services and automation, SQL transformations, workflow code, deployment tooling, and BI integrations. The Software Engineer will partner with data and HR specialists to translate requirements into maintainable code, tests, and releases. Deep expertise in every part of the analytics stack is not expected; the role builds that domain knowledge with support from experienced teammates.

Key Responsibilities:

Develop Workfoce Insight Software

• Design, implement, test, and maintain well-scoped software features across Python, SQL, and workflow code, following team architecture and coding standards.

• 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 Big Query transformations and models as part of the product, following established conventions for grain, keys, history, and query efficiency.

Integrate Data and Metrics

• Implement approved workforce metric definitions in SQL and application or BI integrations, keeping logic understandable and testable.

• Preserve metric behavior when changing data models or interfaces; reconcile affected outputs to agreed reference numbers and investigate discrepancies with metric owners.

• Document changes that affect reported numbers and obtain definition-owner approval before release.

• Contribute to Superset datasets and dashboard integrations, and support evaluation of APIs, caching, SSO, or scheduled-report behavior.

Build with Security and Quality

• Follow established access-control, Big Query policy-tag, BI row-level security, and small-cell suppression patterns in code and data product.

• Keep PII out of tables, logs, and outputs where it does not belong; consult data owners when requirements are unclear.

• Add or run relevant security, data-quality, and regression tests with senior engineers and governance partners before release.

Operate and Release Software

• Develop and maintain Airflow workflows, Python automation, SQL assets, and deployment-related code used by the product.

• Use the established Git Hub 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.

Improve the Engineering Practice

• Keep technical documentation current for the components you change, including interfaces, data lineage, and operational procedures.

• Help modernize the Workforce Insight stack…