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

$79,310 - $158,620/Yr

CVS Health - Woonsocket, RI

Full-time - Entry Level

Hybrid - Woonsocket, RI

5,001-10,000 employees

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 requires a self-driven individual with strong communication skills to ensure data quality and integrity while working in a fast-paced environment. The successful candidate will contribute to product feature development using various technologies and participate in Agile project activities.

Responsibilities

• Contribute to the development of new product features utilizing various technologies including Oracle, Snowflake, and BigQuery.
• Participate in Agile scrum activities and project status meetings regularly.
• Engage in user story grooming and design discussions with the technical lead.
• 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.
• Perform all data engineering job activities including development, testing, deployment, and support.
• 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

• Google Cloud Platform experience - BigQuery, Cloud SQL, Python, Cloud Composer/Airflow, and Cloud Storage.
• 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 is a plus.

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.
• Numerous 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 throughout the calendar year.