Software Engineer

Build and operate software that powers CVS Health Workforce Insights, including HR Insights and Organizational Health dashboards.

Responsibilities

• Design, implement, test, and maintain well-scoped features across Python, SQL, and workflow code, aligned to team architecture and coding standards.
• Convert product and operational requirements into technical tasks and collaborate with data engineers, analysts, and HR partners on expected behavior and acceptance criteria.
• Participate in code reviews, improve existing implementations, and add automated tests for business logic, data contracts, and integrations.
• Build and maintain BigQuery transformations and models, following conventions for grain, keys, history, and query efficiency.
• 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 by reconciling outputs to agreed reference numbers and investigating discrepancies with metric owners.
• Document changes that affect reported numbers and obtain definition-owner approval before release.
• Contribute to Apache Superset datasets and dashboard integrations; support API evaluation, caching, SSO, or scheduled-report behavior.
• Follow access-control and governance patterns including BigQuery policy-tag, BI row-level security, and small-cell suppression.
• Keep PII out of tables, logs, and outputs where it does not belong; consult data owners when requirements are unclear.
• Add or run security, data-quality, and regression tests with senior engineers and governance partners before release.
• Develop and maintain Airflow workflows, Python automation, SQL assets, and deployment-related code used by the product.
• Use the GitHub Actions release process across dev, pdev, and prod, including environment placeholders; follow IAM and service-account controls.
• Diagnose defects using logs and tests, contribute fixes, and help maintain monitoring and operational documentation; escalate production risks promptly.
• Support safe releases through the team’s review, validation, rollback, and incident processes.
• Maintain technical documentation for changed components, including interfaces, data lineage, and operational procedures.
• Help modernize the Workforce Insights stack through incremental refactoring, migration validation, and retirement of legacy components via the team change process.
• Maintain the team’s Apache Superset deployment by tracking upstream releases and security advisories, validating upgrades, and keeping configuration or extensions supportable.
• Prefer configuration and extension points over long-lived private forks; document necessary patches and, when appropriate, contribute fixes upstream.
• Share technical context and explain tradeoffs and metric behavior with technical and non-technical partners.

Requirements

• 3+ years of professional software development experience, or equivalent experience building and supporting production software.
• 3+ years with Python (or comparable general-purpose language), including readable, maintainable code and automated tests.
• 3+ years building or integrating APIs, services, data workflows, or other production systems, with ability to reason about interfaces and failure modes.
• 3+ years working across application code, data transformations, and operational tooling as product needs require.
• 2+ years advanced SQL expertise (preferably BigQuery
• 2+ years Kimball dimensional modeling: grain, conformed dimensions, slowly changing dimensions, bridge tables, factless facts, and fact additivity.
• 2+ years production experience with Airflow or Cloud Composer and Python for ETL, automation, data quality, and troubleshooting.
• 2+ years hands-on cloud data platform experience; GCP is strongly preferred, including working knowledge of BigQuery, Cloud Storage, IAM, service accounts, Secret Manager, and related security concepts.
• 1+ year 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 experience with Git, code review, and CI/CD practices, preferably GitHub Actions across multiple environments.
• 1+ year experience tracing data or metric discrepancies to root cause and explaining findings to technical and non-technical audiences.

Technologies

• Python
• SQL
• BigQuery
• Apache Superset
• Airflow
• Cloud Composer
• GitHub Actions
• BigQuery policy-tag
• Superset datasets
• IAM
• service accounts
• Secret Manager
• Cloud Storage
• Git

Benefits

• Medical, dental, and vision coverage
• Paid time off
• Retirement savings options
• Wellness programs

Preferred Qualifications

• Experience with Python data applications, SQL transformation frameworks, Airflow, or Cloud Composer.
• Experience with BigQuery, GCP services, containerized deployments, or GitHub Actions.
• Experience with BI or semantic-layer integrations such as Superset, ThoughtSpot, Looker, or Power BI.
• HR or people-analytics knowledge, including Workday data, workforce metrics, or organizational hierarchies.
• Experience handling sensitive employee data, access controls, policy tags, or small-cell suppression.
• REST API automation; exposure to Superset on GKE, Celery, Redis, or OAuth.
• Experience maintaining open-source software used by a team, including tracking releases and vulnerabilities, planning upgrades, managing customizations, or contributing changes upstream.
• A Google Cloud Professional Data Engineer certification.
• Master’s degree in a relevant technical or analytical discipline.

Education

• Bachelor’s degree in Computer Science, Data Engineering, Data Science, Information Systems, or a related field, or equivalent practical experience.

Location and Work Details

• Location: Sacramento, CA (onsite)
• Weekly hours: 40
• Time type: Full time

Compensation

• Salary range: USD 83,430 - 222,480 per yearly
• Incentive: Eligible for a CVS Health bonus, commission or short-term incentive program in addition to the base pay range listed above