Software Engineer - Workforce Insights
CVS Health1 day ago
Woonsocket, RI, USA +5 moreMid Level
H1B sponsor
Base Salary
$83k - $222k/yr
Responsibilities
- Design, implement, test, and maintain software features across Python, SQL, and workflow code.
- Translate product and operational requirements into technical tasks and collaborate with data engineers, analysts, and HR partners.
- Build and maintain BigQuery transformations, models, governed workforce metrics, and data integrations.
- Develop and maintain Airflow workflows, Python automation, SQL assets, and deployment-related code.
- Contribute to Apache Superset datasets, dashboard integrations, semantic-layer functionality, and BI behavior such as APIs, caching, SSO, and scheduled reports.
- Apply access controls, BigQuery policy tags, row-level security, small-cell suppression, and PII-handling practices.
- Use GitHub Actions release processes across development, pre-production, and production environments.
- Diagnose defects, investigate metric discrepancies, contribute monitoring and fixes, and support rollback and incident processes.
- Maintain technical documentation, validate migrations, modernize the stack, and support Apache Superset upgrades and upstream contributions.
Requirements
- At least 3 years of professional software development experience or equivalent experience building and supporting production software.
- At least 3 years of experience with Python or a comparable general-purpose language, including maintainable code and automated tests.
- At least 3 years of experience building or integrating APIs, services, data workflows, or other production systems.
- At least 3 years of experience across application code, data transformations, and operational tooling.
- At least 2 years of advanced SQL experience, preferably with BigQuery, including scripting, partitioning, clustering, materialized views, query optimization, and cost awareness.
- At least 2 years of Kimball dimensional modeling experience, including dimensions, slowly changing dimensions, bridge tables, factless facts, and fact additivity.
- At least 2 years of production experience with Airflow or Cloud Composer and Python for ETL, automation, data quality, and troubleshooting.
- At least 2 years of hands-on cloud data platform experience; GCP and knowledge of BigQuery, Cloud Storage, IAM, service accounts, and Secret Manager are preferred.
- At least 1 year of experience with an enterprise semantic or BI layer such as Superset, ThoughtSpot, Looker, Tableau, or Power BI.
- At least 1 year of experience with Git, code review, CI/CD practices, and preferably GitHub Actions across multiple environments.
- At least 1 year of experience tracing data or metric discrepancies to root cause and explaining findings to technical and non-technical audiences.
- Preferred qualifications include Python data applications, SQL transformation frameworks, containerized deployments, HR or people-analytics knowledge, sensitive employee-data controls, REST API automation, Superset on GKE, Celery, Redis, OAuth, open-source maintenance, Google Cloud Professional Data Engineer certification, or a relevant master’s degree.
- A bachelor’s degree in Computer Science, Data Engineering, Data Science, Information Systems, or a related field, or equivalent practical experience, is required.
Benefits
- Full-time position with a 40-hour anticipated workweek.
- Benefits include medical, dental, and vision coverage, paid time off, retirement savings options, wellness programs, and other resources based on eligibility.
- The position is eligible for a CVS Health bonus, commission, or short-term incentive program in addition to base pay.
Tech Stack
Categories
BackendData Engineering
About CVS Health
CVS Health is a U.S. health care company that operates thousands of retail pharmacies, runs the CVS Caremark pharmacy benefits manager, and owns the Aetna health insurance business. It sells prescriptions, retail health goods, and insurance plans, and provides primary and urgent care through MinuteClinic and other services for consumers, employers, and government programs. Founded in 1963 and headquartered in Woonsocket, Rhode Island, it is a public company traded on the NYSE.