Aetna Resources, LLC, a CVS Health company, is hiring for the following role in New York, NY: Sr. Data Engineer to work on the design, build, and management of large-scale data 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 addresses reporting needs. Write etl processes, design database systems, and develop tools for real-time and offline analytic processing. Utilize hadoop architecture, hdfs commands, and designing and optimizing queries to build data pipelines. Work with cloud technologies amazon web service (aws), google cloud platform (gcp) or microsoft azure for data storage and application hosting. Utilize business intelligence tools like tableau, birst, microstrategy etc. for building business reports and dashboards for various metrics defined as per business requirements. Apply programming skills to build robust data pipelines and dynamic systems. Work alongside aetnas data science team to transform data and integrate algorithms and models into automated processes. Build data marts and data models to support data science and other internal customers. Build analytical pipelines or applications by use of various tools available. Integrate data from a variety of sources, assuring that they adhere to data quality and accessibility standards. analyze current information technology
environments to identify and assess critical capabilities and recommend solutions. Leverage multiple tools and programming languages to analyze and manipulate data sets from disparate data sources and advise on new tools to determine optimal solution given the requirements dictated by the model use case. Work with data science teams in developing real time applications by model integration. Execute poc on new technologies to advance team technological knowledge. Develop spark programs to perform real time transformations that implement business logic. Optimize and restructure applications.Required Qualifications
2 years of experience as Data Engineer, Software Engineer, or a related occupation. Minimum 2 years of experience building robust data flows and analytical platforms. Must have experience working with big data including hive, pig, map reduce, sqoop, oozie, and spark; programming languages python 2.7, python 3.5, and sql; unix shell scripting; and sas. Requires experience, optimizing and designing databases including teradata, exasol, netezza, oracle, mysql, ms sql, hbase, and mongodb; implementing sql queries; working with cloud storages (aws s3, aws redshift, and bigquery(gcp)), cloud technologies (aws, gcp, snowflake or azure), bi tools tableau, birst, and microstrategy; and content workflow software jira.Preferred Qualifications
Please see required qualifications.Education
Masters degree in Computer Information Systems, Computer Science, IT or related field.Business Overview
At CVS Health, we are joined in a common purpose: helping people on their path to better health. We are working to transform health care through innovations that make quality care more accessible, easier to use, less expensive and patient-focused. Working together and organizing around the individual, we are pioneering a new approach to total health that puts people at the heart.
We strive to promote and sustain a culture of diversity, inclusion and belonging every day. CVS Health is an equal opportunity and affirmative action employer. We do not discriminate in recruiting, hiring or promotion based on race, ethnicity, sex/gender, sexual orientation, gender identity or expression, age, disability or protected veteran status or on any other basis or characteristic prohibited 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.