Participate in the design, build and management of large scale database structures and pipelines and efficient Extract/Load/Transform (ETL) workflows for Aetna Databases. 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. Work with Hadoop architecture, HDFS commands and experience designing & optimizing queries to build data pipelines. Work with programming skills including Python, Java, Hive, Spark, and MySQL to build robust data pipelines and dynamic systems. Develop framework for API based integrations for building models as Service architecture and allow integration with multiple external and internal system. Build tools and software to automate manual processes using technologies including Shell scripting, Java, Python & SQL. Build data marts and data models to support clients and internal customers. Integrate data from a variety of sources, ensuring that they adhere to data quality and accessibility standards.
Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
Minimum 5 years of experience developing large scale data structures and applications to organize, collect and standardize data. Experience developing systems to integrate with multiple external or internal applications leveraging Java/Python based Rest API integrations; working with Hadoop architecture and HDFS commands; utilizing advanced programming skills in languages including Java, Python, SQL, and Spark to build robust data pipelines and dynamic systems; identifying ways to improve data reliability, efficiency, and quality; and developing prototype products and working on Proofs of Concept to pick latest market tools and technologies quickly and add to product landscape to help build stable framework and product.
Percent of Travel Required
At Aetna, a CVS Health company, 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 are committed to maintaining a diverse and inclusive workplace. CVS Health is an equal opportunity and affirmative action employer. We do not discriminate in recruiting, hiring or promotion based on race, ethnicity, gender, gender identity, age, disability or protected veteran status. 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.
Apply on company website