ETL Engineer II

Job Description

Do you want to work on a high priority, mission critical Extraction, Transformation, and Load (ETL) task knowing your work will make a difference?

Why BAE: Our Promise to you You'll have an extraordinary experience working at BAE Systems. Here is why.
The Organization Be a part of a company that's part of its community, driven to improve our future, protect our freedom - and what matters. The Work We offer a flexible work environment to support the balance in your life and keep you performing at your best. The Opportunity From on-the-job training and leadership programs, to collaborating with leading experts and seasoned colleagues - you can feel the excellence. The People Here, we're all about trust, camaraderie and a shared ambition to lead the world in defense technologies and national security services. Plus, we're just nice people. The Reward You'll develop breakthrough (sometimes secretive) technology and intelligence solutions, building a clear advantage for customers. Flexibility at BAE Systems, Inc. Hear from BAE Systems employees on how they manage balance between work and life.
What will you be doing?
Work with customer development team to ingest approximately 175 datasets of varying types

Maintain, enhance the customer application which is designed to the review and analysis of various data types.

Perform extraction, transformation, and load of data sets in differing formats.

Make design enhancements to the data base schema, dictionary and normalize data into a consistent schema to accept new data types

Assist in the enhancement of a user-friendly web browser interface to allow the end users to conduct efficient search, and conduct link analysis.

Assist in the enhancement of reports for dissemination or offline viewing

Develop and maintain database backup plan.

This is an opportunity to work with large big datasets, tools, and data science professionals. If you have some ETL experience and want to grow your big data and development skills, this is a position for you.

Typical Education & Experience
Typically a Bachelor's Degree and 2 years work experience or equivalent experience

Required Skills and Education

At least 2 years experience with Java, PL/SQL, SQL, Oracle 11g and 12c, XML, XSLT, web services, SVN, RCS, Git, OLS Security, JIRA, Oracle 11g/12c, Linux (CentOS, Red Hat), and Windows.

Must be a strong communicator, written and verbal. Must be able to translate technical information for customer.

Some experience with in Bash Script.

Solid understanding of scripting using Python to conduct ETL.

Experienced with ETL for wide variety of structured and unstructured very large datasets.

Experience or familiarity with Solr or Elasticsearch .

BS in Computer Science or similar technical field recommended. Experience in lieu of education will be considered.
Quick learner; very flexible responding to changing priorities and case/mission driven tasking.

Preferred Skills and Education

It is desired for candidate to have experience and interest in ETL and database engineering and administration. Strength programming in Java and scripting with Python is highly desirable. This is an opportunity for junior to mid developers with strong foundation in Java and Python to use these skills creatively, learning from professionals to advance these skills significantly. Experience working in an agile development environment is desirable. This position is part of a growing ETL team with a broad spectrum of skills and experience to learn from.

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. Equal Opportunity Employer/Females/Minorities/Veterans/Disabled/Sexual Orientation/Gender Identity/Gender Expression. To see Inspired Work in action, visit www.baesystems.com and follow us on Facebook: www.facebook.com/baesystemsintel.


Back to top