Lead Data Engineer

Job Description
Designs and develops complex and large-scale data structures and pipelines to organize, collect and standardize data to generate insights and addresses reporting needs

Writes complex ETL (Extract / Transform / Load) processes, designs database systems and develops tools for real-time and offline analytic processing

Develop frameworks, standards & reference material for architecture and associated products

Designs data marts and data models to support Data Science and other internal customers. Behaves as mentor to junior team members to provide technical advice

Applies knowledge of Aetna systems and products to consult and advise on additional efforts across multiple domains spanning broader enterprise

Collaborates with data science team to transform data and integrate algorithms and models into highly available, production systems

Uses in-depth knowledge on Hadoop architecture, HDFS commands and experience designing & optimizing queries to build scalable, modular, and efficient data pipelines

Uses advanced programming skills in Python, Java or any of the major languages to build robust data pipelines and dynamic systems

Integrates data from a variety of sources, assuring that they adhere to data quality and accessibility standards

Experiments with available tools and advice on new tools in order to determine optimal solution given the requirements dictated by the model/use case

Pay Range
The typical pay range for this role is:
Minimum: 115,000
Maximum: 230,000

Please keep in mind that this range represents the pay range for all positions in the job grade within which this position falls. The actual salary offer will take into account a wide range of factors, including location.

Required Qualifications
7 or more years of progressively complex related experience

Experience with bash shell scripts, UNIX utilities & UNIX Commands

Experience building and implementing data transformation and processing solutions

Advanced knowledge in Java, Python, Hive, Cassandra, Pig, MySQL or NoSQL or similar

Advanced knowledge in Hadoop architecture, HDFS commands and experience designing & optimizing queries against data in the HDFS environment

Preferred Qualifications
Has in-depth knowledge of large-scale search applications and building high volume data pipelines

Ability to leverage multiple tools and programming languages to analyze and manipulate large data sets from disparate data sources

Ability to understand and build complex systems and solve challenging analytical problems

Education
Bachelor's degree or equivalent work experience in Computer Science, Engineering, Machine Learning, or related discipline.

Master’s degree or PhD preferred

Business Overview
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. We strive to promote and sustain a culture of diversity, inclusion and belonging every day. CVS Health is an affirmative action employer, and is an equal opportunity employer, as are the physician-owned businesses for which CVS Health provides management services. We do not discriminate in recruiting, hiring, promotion, or any other personnel action based on race, ethnicity, color, national origin, sex/gender, sexual orientation, gender identity or expression, religion, age, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law. We proudly support and encourage people with military experience (active, veterans, reservists and National Guard) as well as military spouses to apply for CVS Health job opportunities.