Data Engineering (Data Warehousing & BI) - CVS Health

Location: Greater Boston
Job Type: Engineering

IQ Workforce is a leading recruiting firm for the global analytics & data science community.

Our client partner, CVS Health, is hiring Data Engineering talent in their Enterprise Analytics organization. As CVS Health now makes up a PBM (Caremark) and one of the nation’s largest health insurers (Aetna), you will have the opportunity to create programs that use an unprecedented level of health data to improve health outcomes. If you are passionate about making a difference in the work you do, being recognized for your talent and expertise in solving complex and challenging analytical/data problems while contributing to the success of key strategic initiatives, consider growing your career with a Fortune 10 healthcare leader!

The Data Engineering team collaborates with product leaders and owners, IT architecture & development teams, using the latest in data and cloud technologies to help lead and deliver on new products.

Some of the work you do may include:
Participate in the design, build and management of large scale database structures and pipelines and efficient Extract/Load/Transform (ETL) workflows

Develop large scale data structures and pipelines to organize, collect and standardize data that helps generate insights and address reporting needs

Write ETL (Extract / Transform / Load) processes, design database systems and develop tools for real-time and offline analytic processing

Collaborate with the data science team to transform data and integrate algorithms and models into automated database processes

Some of the things we look for in potential candidates:
Proficiency in designing data layers for analytical and reporting use cases.

Strong data management and data modeling experience

Very Strong in complex SQL constructs and Code Optimization on RDBMS, Teradata preferred

Experience with developing Metrics and KPI data layers for broader business and analytic consumption and exposure to data visualization using Tableau

Experience in migrating RDBMS pipelines to Cloud/Hadoop using Python/Scala on Spark and good knowledge of Python/Scala