View All Jobs/Careers

Job Information

Aetna Senior Data Engineer in Hartford, Connecticut

Req ID: 65975BR

Job Description

Are you passionate about cutting edge technology?

Is your dominant trait intense curiosity — Are you ready to make discoveries while swimming in data? Do you desire to go beneath the surface of a problem, find the questions at heart, and extract them into a very clear set of hypotheses that can be tested? You are in the right place; working with Aetna gives you just that…. Scrutinizing data in a world-class Hadoop cluster, generating insights to guide consumers in their journey to wellness, and help them achieve their health ambitions, whether it s running the Inca Trail Marathon or playing tackle football with their grandkids? Aetna s Data Engineer team is focused on delivering strategically-impactful programs and tools to help members across all life stages feel the joy of achieving their best health, in their own way.

This position Leads and participates in the design, built and management of large scale data structures and pipelines and efficient Extract/Load/Transform (ETL) workflows.

Fundamental Components included but are not limited to:

  • Develops large scale data structures and pipelines to organize, collect, and standardize data that helps generate insights and addresses reporting needs.

  • Writes ETL (Extract / Transform / Load) processes, design database systems, and develop tools for real-time and offline analytic processing.

  • Collaborates with the data science team to transform data and integrate algorithms and models into automated processes.

  • Uses knowledge in Hadoop architecture, HDFS commands, and experience designing & optimizing queries to build data pipelines. Uses strong programming skills in Python, Java, or any of the major languages to build robust data pipelines and dynamic systems.

  • Builds data marts and data models to support Data Science and other internal customers.

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

  • Analyzes current information technology environments to identify and assess critical capabilities and recommend solutions.

  • Experiments with available tools and advices on new tools to determine the optimal solutions given the requirements dictated by the model/use case.

Qualifications Requirements and Preferences:

  • 5 or more years of progressively complex related experience

  • Ability to understand complex systems and solve challenging analytical problems.

  • Experience with bash shell scripts, UNIX utilities & UNIX Commands.

  • Knowledge in Java, Python, Hive, Cassandra, Pig, MySQL or NoSQL or similar. Expertise in Hadoop architecture, HDFS commands, and experience designing & optimizing queries against data in the HDFS environment.

  • Experience building data transformation and processing solutions

  • Strong problem-solving skills and critical thinking ability.

  • Strong collaboration and communication skills within and across teams.

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

  • strong knowledge of large scale search applications and building high volume data pipelines.

  • Master s degree or Ph.D. preferred. Bachelor's degree or equivalent work experience in Computer Science, Engineering, Machine Learning, or related discipline.

Benefit Eligibility

Benefit eligibility may vary by position. Click here to review the benefits associated with this position.

Job Function: Data & Analytics

Aetna is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected Veterans status.