Description: Aetna's Medicare Stars Team is growing and expanding! This is exciting opportunity to join a high performing, collaborative team as a Junior Data Engineer.
This role will be responsible for the successful delivery, design, build and management of large-scale data structures and pipelines and efficient Extract/Transform/Load (ETL) workflows.
This individual assists in the development of large-scale data structures and pipelines to organize, collect and standardize data that helps generate insights and addresses reporting needs.
Applies understanding of key business drivers to accomplish own work.
Uses expertise, judgment and precedents to contribute to the resolution of moderately complex problems. Leads portions of initiatives of limited scope, with guidance and direction.
Writes ETL (Extract / Transform / Load) processes, designs database systems and develops tools for real-time and offline analytic processing.
Collaborates with client 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 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 clients and other internal customers.
Integrates data from a variety of sources, assuring that they adhere to data quality and accessibility standards.
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.
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.
Has strong knowledge of large-scale search applications and building high volume data pipelines.
Bachelor's degree or equivalent work experience in Computer Science, HealthCare Informatics, Computer Engineering, Information Systems, Machine Learning, or related discipline.
Required Skills: Technology - Developing Software Solutions, Technology - Leveraging Technology, Technology - Promoting Emerging Technology Desired Skills: General Business - Applying Reasoned Judgment, Leadership - Anticipating and Innovating, Leadership - Collaborating for Results Technology Experience: Database - Microsoft SQL Server, Development Language - SQL, Development Tool - Microsoft Visual Studio Potential Telework Position: No Percent of Travel Required: 0 - 10% EEO Statement: Aetna is an Equal Opportunity, Affirmative Action Employer Benefit Eligibility: Benefit eligibility may vary by 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.