Lead Data and Integration Engineer (ETL)

Virginia, Armed Forces Americas

Remote position available

Job Description

This position is a remote opportunity, allowing you to work from the comfort of your own home from anywhere in the US.

This position will analyze problems and is an expert in at least two or more Data Management tools. Role will understand and develop requirements for a system (mapping documents) by working with Business and Stakeholders, including visualization. Focus on the design with emphasis on reusability, scalability, optimization and parameterization. Develop, test and maintain canonical layouts and drives standardization. Is proficient at automated testing strategies, including TDD. Integrate systems to enterprise data governance tools. Perform data and service integration. Design data as a service (DaaS). Contribute to 24x7x365 days of on-call staff coverage.

• 5-7 years of working experience with Informatica, 2-4 years with Snaplogic
• Should be proficient in Software Development Lifecycle
• Ability and Prior experience in taking a product through the entire lifecycle of analysis, design, coding, testing and implementation and support is a plus.
• Experience with big data related technologies such as Hadoop, Redshift is a plus

Role based competencies:
• Development of interfaces/load process using Databases Oracle/SQL Server/Flat files
• Collaborate with teams to identify and understand key information and data assets
• Should have strong knowledge of Oracle, SQL Server
• Should have working knowledge of Performance optimization and tuning tools.
• Should be able to work in Agile and Waterfall based projects

Technical Skills:
• Experience with ETL Tools such as Informatica, Snaplogic etc
• Experience in UNIX shell scripting is a plus.
• Experience in designing and architecting data interfaces is a plus
• Experience in implementing Data Quality validations is a plus
• Demonstrated ability in performance optimization - analysis of logs, traces, troubleshooting and performance tuning is required.
• IDE such as Toad, SQL Developer
• Knowledge of AWS resources and services is a plus

This position will act as a liaison between IT Architects and IT Analysts to break down a complex system into smaller components and coach/lead a team of Data and Integration Engineers to design and develop these components. This role- functions as primary practitioner coach on the team to grow the capabilities of other engineers on the team. Responsible for driving new initiatives, conducts POC's and evaluates other products for seamless integration. Is an expert at data integration with RDBMS, Big Data/Hadoop, Data Warehouse, Data Lake concepts and has relevant experience with various OS, network and storage concepts. Will perform data modeling and create data architecture footprints that has operational integration capabilities. Must understand how to build advanced jobs using map-reduce technology. Ability identify and track key metrics produced by the application. Contribute to 24x7x365 days of on-call staff coverage.
  • Develops, test and maintains code using software development methodology and appropriate technologies for the system being used.
  • Works closely with Business Analysts to develop detail systems design and written test plans for online and report application programs.
  • Performs analysis on projects and provides a project plan that shows the tasks needing to be completed and a time estimate for each task.
  • Participates in design walkthroughs with appropriate focus groups and related users to verify accuracy of design in meeting business needs.
  • Prepares installation instructions and coordinates installation procedures.
  • Supports and troubleshoots application code problems.
  • Provides status reports that give a detailed description of the current projects progress and indicates time devoted to each task of the project.
  • Coordinates, guides and mentors programming efforts performed by in-house programmers or outside consultants to ensure that all programming is completed according to the project plan.

General Job Information


Lead Data and Integration Engineer (ETL)



Job Family

Info Technology Group


United States of America

FLSA Status

United States of America (Exempt)

Recruiting Start Date


Date Requisition Created


Work Experience



Bachelors: Computer and Information Science

License and Certifications - Required

License and Certifications - Preferred

Other Job Requirements


  • 5+ years related experience including a minimum of 2+ years designing, building and deploying software in Cloud.
  • Agile and Design Thinking (Coursera).
  • Critical thinker.
  • Demonstrated problem solving techniques.
  • Strong verbal and written communication skills.
  • AWS Certified.
  • Big Data/Hadoop Certified.
  • Some ETL/data movement certifications.
  • ServiceNow training.

Magellan Health Services is proud to be an Equal Opportunity Employer and a Tobacco-free workplace. EOE/M/F/Vet/Disabled. Every employee must understand, comply and attest to the security responsibilities and security controls unique to their position.

Top 5 reasons to work at Magellan

When you say

To be the best you have to work with the best

We hear you
Life @ Magellan