Senior Data Engineer - Data Modeling

At CVS Health, we’re building a world of health around every consumer and surrounding ourselves with dedicated colleagues who are passionate about transforming health care.

As the nation’s leading health solutions company, we reach millions of Americans through our local presence, digital channels and more than 300,000 purpose-driven colleagues – caring for people where, when and how they choose in a way that is uniquely more connected, more convenient and more compassionate. And we do it all with heart, each and every day.

Position Summary

• Facilitate sessions with business teams to analyze business/data requirements related to Canonical data modeling, project driven modeling, master data management and reference data management.
• Define the naming standards to standardize the logical and physical model creation process.
• Develop and manage required artifacts, like the Business Glossary, ECDM (Enterprise Conceptual Data Model) and ELDM (Enterprise Logical Canonical Data Model) Data Lineage diagrams and data asset inventory, based on analysis of existing data models
• Create , register and socialize domain data models and APIs for enterprise data domains
• Conduct data analysis and data profiling for understanding relationships between entities, source data and constraints associated with source data.
• Support Agile teams across multiple business units such as PBM, AETNA
• Follow the data governance process and work with business trustees to define metadata and get approval for business glossary attributes
• Establish lineage between Business Glossary attributes and existing physical data attributes in existing operational data models across business units.
• Create data model for enterprise reference data management and enterprise master data management initiatives.
• Create logical physical data models in Erwin and implement DDL in google cloud platform; performs data profiling on large data sets, works on metadata management in Alation.
• Analyze current information technology environments to identify and assess critical capabilities and recommend solutions
• Experiment with available tools and advise on new tools in order to determine optimal solution given the requirements dictated by the model/use case
   

Required Qualifications

• 5+ years of data modeling experience, including experience in 3NF modeling and Dimensional modeling
• 3+ years of experience in Data Governance, Data Quality and Metadata Management

Preferred Qualifications

• Experience with gathering functional requirements and conceptual design
• Data analysis and solutions
• Data Modeling for Data Lake, Data warehousing, ODS
• Experience with Reference Data Management and Master Data Management
• Experience working with ETL development
• Programming skills in Python and SQL
• Ability to leverage multiple tools and programming languages to analyze and manipulate data sets from disparate data sources
• Ability to understand complex systems and solve challenging analytical problems
• Experience with bash shell scripts, UNIX utilities & UNIX Commands
• Strong knowledge of large-scale search applications and building high volume data pipelines

Education

• Bachelor’s Degree in Computer Science, Engineering, Statistics, Physics, Math, or related field or Advanced Degree

Anticipated Weekly Hours

40

Time Type

Full time

Pay Range

The typical pay range for this role is:

$92,700.00 - $185,400.00

This pay range represents the base hourly rate or base annual full-time salary for all positions in the job grade within which this position falls.  The actual base salary offer will depend on a variety of factors including experience, education, geography and other relevant factors.  This position is eligible for a CVS Health bonus, commission or short-term incentive program in addition to the base pay range listed above. 
 

Our people fuel our future. Our teams reflect the customers, patients, members and communities we serve and we are committed to fostering a workplace where every colleague feels valued and that they belong.

Great benefits for great people

We take pride in our comprehensive and competitive mix of pay and benefits – investing in the physical, emotional and financial wellness of our colleagues and their families to help them be the healthiest they can be. In addition to our competitive wages, our great benefits include:

• Affordable medical plan options, a 401(k) plan (including matching company contributions), and an employee stock purchase plan.