Senior Data Engineer - Data Modeling

Bring your heart to CVS Health. Every one of us at CVS Health shares a single, clear purpose: Bringing our heart to every moment of your health. This purpose guides our commitment to deliver enhanced human-centric health care for a rapidly changing world. Anchored in our brand - with heart at its center - our purpose sends a personal message that how we deliver our services is just as important as what we deliver.
Our Heart At Work Behaviors™ support this purpose. We want everyone who works at CVS Health to feel empowered by the role they play in transforming our culture and accelerating our ability to innovate and deliver solutions to make health care more personal, convenient and affordable.
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
• 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

Pay Range
The typical pay range for this role is:
$90,000.00 - $180,000.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.
In addition to your compensation, enjoy the rewards of an organization that puts our heart into caring for our colleagues and our communities. The Company offers a full range of medical, dental, and vision benefits. Eligible employees may enroll in the Company's 401(k) retirement savings plan, and an Employee Stock Purchase Plan is also available for eligible employees. The Company provides a fully-paid term life insurance plan to eligible employees, and short-term and long term disability benefits. CVS Health also offers numerous well-being programs, education assistance, free development courses, a CVS store discount, and discount programs with participating partners. As for time off, Company employees enjoy Paid Time Off ("PTO") or vacation pay, as well as paid holidays throughout the calendar year. Number of paid holidays, sick time and other time off are provided consistent with relevant state law and Company policies.
For more detailed information on available benefits, please visit jobs.CVSHealth.com/benefits
CVS Health requires certain colleagues to be fully vaccinated against COVID-19 (including any booster shots if required), where allowable under the law, unless they are approved for a reasonable accommodation based on disability, medical condition, religious belief, or other legally recognized reasons that prevents them from being vaccinated.
You are required to have received at least one COVID-19 shot prior to your first day of employment and to provide proof of your vaccination status or apply for a reasonable accommodation within the first 10 days of your employment. Please note that in some states and roles, you may be required to provide proof of full vaccination or an approved reasonable accommodation before you can begin to actively work.
CVS Health is committed to recruiting, hiring, developing, advancing, and retaining individuals with disabilities. As such, we strive to provide equal access to the benefits and privileges of employment, including the provision of a reasonable accommodation to perform essential job functions. CVS Health can provide a request for a reasonable accommodation, including a qualified interpreter, written information in other formats, translation or other services through ColleagueRelations@CVSHealth.com If you have a speech or hearing disability, please call 7-1-1 to utilize Telecommunications Relay Services (TRS). We will make every effort to respond to your request within 48 business hours and do everything we can to work towards a solution.