Extract, Transform, Load (ETL) Developer (Master)

13d - Indeed
BAE Systems - Reston, VA 20191
At BAE Systems, we promote a strong, collaborative culture and provide our employees with the tools and skills they need to succeed. We are about trust, camaraderie, and a shared ambition to solve some of the world’s most complex challenges. You will get to work alongside a team of talented professionals who are passionate about their work and the mission. We offer competitive pay and benefits, a flexible work environment to support work/life balance as well as a learning environment and training opportunities to further develop you professionally. Come be a part of a company that is driven to improve our customers, our future, and to protect our freedom. We are developing the technology of tomorrow, delivered today. Drawing strength from our differences, we’re innovating for the future. And you can, too.

Our Mission Intelligence organization provides IT solutions, analytics support, and digital integration to major customers within the US Intelligence Community. We are always looking to provide our customers with a better solution by way of technology insertion, out of the box thinking, and state of the art solutions. We are looking for an experienced ETL Developer to join our team! This role will support a DevSecOps program in an Agile SAFe environment and leverage standard and custom tools for Extract, Transform and Loading of data between databases for the customer. The role requires the development custom code/scripts to quickly extract, triage and exploit data across domains and data. This position will serve as the developer of a group of ETLs supporting enterprise requirements and relaying feedback to team.
  • An ETL Developer is responsible for designing the data storage system for the enterprise and is charged with testing it before it goes live.
  • Designing and implementing a large scale ingest system in a big data environment.
  • Required to read, analyze and digest what the enterprise want to accomplish with its data and design the best possible ELT process to support those objectives.
  • Responsible for recommending methodologies to optimize the visualization, organization, storage, and availability of large scale data in support of enterprise requirements.
  • Provide scripting support to enhance dataset access solutions.
  • Hold meetings with PMO and enterprise stakeholders
  • Serve as a functional lead for ETL team.

Required Skills and Education
  • A must have minimum of 8 years of experience with data modeling.
  • Able to establish database designs in various forms to include star and snowflake schemas.
  • Extensive experience with relational databases, such as MySQL, that utilize SQL queries.
  • Extensive ETL/Data Integration experience using Pentaho, Shell Scripting, Python, Ruby on Rails, Elastic and Neo4J.
  • Must have previous supervising experience.

Preferred Skills and Education
Candidate must have a Bachelors with 12-15 years of relevant experience or Masters with 10-13 years of prior relevant experience.

About BAE Systems Intelligence & Security
BAE Systems Intelligence & Security, based in McLean, Virginia, designs and delivers advanced defense, intelligence, and security solutions that support the important missions of our customers. Our pride and dedication shows in everything we do—from intelligence analysis, cyber operations and IT expertise to systems development, systems integration, and operations and maintenance services. Knowing that our work enables the U.S. military and government to recognize, manage and defeat threats inspires us to push ourselves and our technologies to new levels. That’s BAE Systems. That’s Inspired Work.