Job Description
Leads and participates in the design, built and management of large scale
data structures and pipelines and efficient Extract/Load/Transform (ETL)
workflows.
Required Qualifications
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, designs database
systems and develops tools for real-time and offline analytic processing.
Collaborates with 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 advises on new tools in order to
determine optimal solution given the requirements dictated by the
model/use case
Preferred Qualifications
Strong problem solving skills and critical thinking ability.
Strong collaboration and communication skills within and across teams.
5 or more years of progressively complex related experience.
Ability to leverage multiple tools and programming languages to analyze
and manipulate data sets from disparate data sources.
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.
Knowledge in Hadoop architecture, HDFS commands and experience
designing & optimizing queries against data in the HDFS environment.
Experience building data transformation and processing solutions.
Education
Masters degree or PhD preferred.
Bachelor's degree or equivalent work experience in Computer Science,
Engineering, Machine Learning, or related discipline.
Business Overview
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.
Hartford, CT
Aetna Inc. operates as a health care benefits company in the United States. It operates through three segments: Health Care, Group Insurance, and Large Case Pensions. The Health Care segment offers medical, pharmacy benefit management service, dental, behavioral health, and vision plans on an insured and employer-funded basis. It also provides point-of-service, preferred provider organization, health maintenance organization, and indemnity benefit plans, as well as health savings accounts and consumer-directed health plans.
In addition, this segment offers Medicare and Medicaid products and services, as well as other medical products, such as medical management and data analytics services, medical stop loss insurance, workers’ compensation administrative services, and products that provide access to its provider networks in select geographies. The Group Insurance segment offers life insurance products, including group term life insurance, voluntary spouse and dependent term life insurance, group universal life insurance, and accidental death and dismemberment insurance; disability insurance products; and long-term care insurance products, which provide the benefits to cover the cost of care in private home settings, adult day care, assisted living, or nursing facilities.
The Large Case Pensions segment manages various retirement products comprising pension and annuity products primarily for tax-qualified pension plans. The company provides its products and services to employer groups, individuals, college students, part-time and hourly workers, health plans, health care providers, governmental units, government-sponsored plans, labor groups, and expatriates. Aetna Inc. was founded in 1853 and is based in Hartford, Connecticut. As of November 28, 2018, Aetna Inc. operates as a subsidiary of CVS Pharmacy, Inc.