Senior Data Engineer - Cloud & On-Prem Data Warehouse

Colorado Psychiatric; Denver, Northern (CO, KY); Hybrid; USD 65,000 - 173,000; Full time

Benefits offered by this job

Medical, dental, and vision coverage

Paid time off

Retirement savings options

Job summary

CVS Health in Denver, CO seeks a Senior Data Engineer to deliver modern data solutions across on-prem and cloud platforms. You will design, build, and optimize data pipelines while collaborating with engineering, analytics, data science, and product teams in an agile environment.

The role emphasizes SQL, Python, PySpark, data warehousing, and dimensional modeling, with experience across AWS/GCP/Azure and on-prem SQL Server or Oracle.

Qualifications

• 4+ years of experience with SQL and relational database management systems.
• 2+ years of experience in Cloud Data Engineering Platforms such as AWS, GCP, Azure, Databricks, Snowflake.
• 2+ years of experience in on-prem Data Engineering Platforms such as Microsoft SQL Server, Oracle, Teradata.
• Programming and modifying code in SQL, Python, and PySpark for data warehousing services.
• Hands-on experience with dimensional data modeling, schema design, and data warehousing.
• Hands-on experience with troubleshooting data issues.
• Willingness to implement process improvements and take ownership in a fast-paced team environment.
• Excellent oral and written communication skills.

Responsibilities

• Design, build, and optimize data solutions for on-prem and cloud environments.
• Collaborate with engineering, analysts, data scientists, and product teams in an Agile setting.
• Process payer data into the Data Warehouse and support migrations from on-prem to cloud.

Skills

SQL

Relational DBMS

Python

PySpark

Data warehousing

Cloud platforms

Data modeling

Troubleshooting

Communication

Education

Bachelor's degree in Computer Science / Engineering

Tools

AWS

GCP

Azure

Databricks

Snowflake

Microsoft SQL Server

Oracle

Job description

CVS Health in Denver, CO seeks a Senior Data Engineer to deliver modern data solutions across on-prem and cloud platforms. You will design, build, and optimize data pipelines while collaborating with engineering, analytics, data science, and product teams in an agile environment.

The role emphasizes SQL, Python, PySpark, data warehousing, and dimensional modeling, with experience across AWS/GCP/Azure and on-prem SQL Server or Oracle.