Data Engineer - Retail Data & Products (SQL & PL/SQL) (Woonsocket, RI)

$79,310 - $158,620/Yr

CVS Health - Woonsocket, RI

Full-time - Entry Level

Woonsocket, RI

Health and Personal Care Retailers

About the position

The Data Engineer position at CVS Health focuses on developing scalable data pipelines and optimizing data workflows within the Retail Pharmacy Data & Products team. The role emphasizes ensuring data quality and integrity while contributing to new product features using various technologies such as Oracle, Snowflake, and BigQuery. The ideal candidate is self-driven, possesses strong communication skills, and is eager to learn in a fast-paced environment.

Responsibilities

• Develop scalable data pipelines and optimize data workflows.
• Ensure the quality and integrity of data.
• Contribute to the development of new product features using technologies like Oracle, Snowflake, and BigQuery.
• Participate in Agile scrum activities and project status meetings.
• Engage in user story grooming and design discussions with technical leads.
• Analyze complex data structures from disparate sources and design large-scale data engineering pipelines.
• Build robust data pipelines for ETL processes and design database systems.
• Collaborate with other developers on ETL job and pipeline development.
• Document data engineering processes, workflows, and systems for knowledge sharing.
• Implement data quality checks and validation processes to ensure data accuracy and consistency.
• Work collaboratively with team members for business solutions and implementation.

Requirements

• 1+ years of experience in executing data warehousing ETL projects.
• 1+ years of experience with SQL.
• 1+ years of experience with Python.
• 1+ years of hands-on experience with bash shell scripts, UNIX utilities, and UNIX commands.
• 1+ years of hands-on experience with a major cloud platform (Google Cloud Platform, AWS, Azure).

Nice-to-haves

• Experience with Google Cloud Platform, including BigQuery, Cloud SQL, Python, Cloud Composer/Airflow, and Cloud Storage.
• Hands-on experience building and deploying data transformation and processing solutions in relational and analytical database technologies such as Oracle, Snowflake, or BigQuery.
• Ability to leverage multiple tools and programming languages to analyze and manipulate data sets from disparate sources.
• Strong problem-solving skills and critical thinking ability.
• Strong collaboration and communication skills within and across teams.
• Excellent communication and presentation skills.
• Understanding of software development methodologies including waterfall and agile.
• Health care/retail domain experience.
• Google Cloud Platform certification strongly preferred.
• Experience in developing APIs utilizing Java or Python.

Benefits

• Full range of medical, dental, and vision benefits.
• 401(k) retirement savings plan.
• Employee Stock Purchase Plan.
• Fully-paid term life insurance plan.
• Short-term and long-term disability benefits.
• Well-being programs.
• Education assistance and free development courses.
• CVS store discount and discount programs with participating partners.
• Paid Time Off (PTO) and paid holidays.