Skip to main content

Information Technology

Aetna IT is committed to keeping our members at the heart of everything we do. Our top-talent workforce delivers leading-edge technology, drives innovation, turns vision into action and challenges the art of the possible. We provide best-in-class services to our members by delivering groundbreaking healthcare tools, enabling consumer-friendly interactions and protecting data security. Your mission will be to deliver innovating technology solutions including: Hybrid cloud infrastructure, artificial intelligence/machine learning capabilities and infrastructure as code.

Aetna, a CVS Health Company, is a company with a world-class IT team and we will be counting on you to carry on our success as the preferred provider of infrastructure services for our business partners.

Back to Job Navigation (Overview)

Success Profile

What makes a successful Information Technologist?
Here are the traits we are looking for:

  • Adaptable
  • Collaborative
  • Communicator
  • Digitally Savvy
  • Good Listener
  • Problem-solver
  • Results Driven
  • Team Player
  • Technologically savvy
  • Versatile
  • Relationship expertise
  • Diplomatic
  • Trustworthy
  • Business Savvy

Back to Job Navigation (Success)

Benefits

  • Medical

  • Dental

  • Vision

  • Healthcare
    FSA

  • Dependent
    Care FSA

  • Health and
    Wellness
    Programs

Back to Job Navigation (Rewards)

Job Details

Lead Data Engineer

Primary Location: Wellesley, Massachusetts
Additional Locations: MA-Wellesley
Apply
Description:
Participate in the design, build, and management of large scale data structures and pipelines and efficiently extract/ load/ transform (ETL) workflows. Responsible for developing large scale data structures and pipelines to organize, collect and standardize data that helps generate insights and addresses reporting needs. Write complex ETL (Extract / Transform / Load) processes, designs database systems and develops tools for real-time and offline analytic distributed data processing. Collaborate with data science team to transform data and integrate algorithms and models into automated processes. Use in-depth knowledge on Hadoop architecture, HDFS commands, Apache Spark, Hive and experience designing & optimizing queries to build data pipelines. Use strong programming skills in Scala, Python, Java or any of the major languages to build robust data pipelines and dynamic systems. Build data marts and data model to support Data Science and other internal customers. 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. Experiment with available tools and advises on new tools in order to determine optimal solution given the requirements dictated by the model/use case.


Background Experience:
Master’s degree in Computer Science, Computer Applications or Computer Information Systems. Will accept a combination of degrees equivalent to a U.S. Master’s degree.

Minimum 2 years of experience working with data engineers in analytics-focused teams to deliver complex analytics projects on aggressive timelines; strong Big Data and Apache Spark experience for building and running products and applications at scale, in mission-critical situations; and experience with programming languages such as Python and Java to build robust data pipelines and dynamic systems. Must also have experience in working on high volume databases with strong experience in SQL (preferably DB2 UDB 9.x or later and Teradata); the development of transformation pipelines using Informatica 9x; PL/SQL; MySQL; and production scheduling tools like Zeke or TIDAL.


Potential Telework Position:
No

Percent of Travel Required:
N/A

EEO Statement:
Aetna is an Equal Opportunity, Affirmative Action Employer

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

Candidate Privacy Information:
Aetna takes our candidate's data privacy seriously. At no time will any Aetna recruiter or employee request any financial or personal information (Social Security Number, Credit card information for direct deposit, etc.) from you via e-mail. Any requests for information will be discussed prior and will be conducted through a secure website provided by the recruiter. Should you be asked for such information, please notify us immediately.

Click To Review Our Benefits (PDF)

Apply

Influential Content

Back to Job Navigation (Trending)

Sign up for Job Alerts

Explore This Area

Check out where you could be working if you apply.

View Map

Similar Jobs

Join Our Talent Community

Sign up to receive information about job openings that are tailored to your skills and interests. Plus, get the latest career news from Aetna.