Database Dsgn Eng Sr Prin
Apply NowCompany: BAE Systems
Location: Huntsville, AL 35810
Description:
Job Description
As a member of our team, you will join a diverse group of driven professionals who design the products and systems that support enhanced capabilities, protect national security, and keep critical information and infrastructure secure. With us, you will be able to make an impact while you hone your skills and grow in your career.
BAE Systems is looking for an experienced ETL Engineer to join a strong team supporting our government customer. This position will provide the ability to make a significant impact to the mission.
Successful candidate will need to be able to maintain existing software as the transition from server-based to cloud-based occurs. The candidate will work with a GOTS-based Extract, Transform and Load (ETL) system that loads information into Postgres database with billions of rows and deals with a file repository that is in a Petabyte range. In addition, the candidate will be highly involved in the engineering planning and transition of the existing system software / data into a Cloud-based (currently AWS) solution.
Required Skills and Education
About BAE Systems Intelligence & Security
BAE Systems, Inc. is the U.S. subsidiary of BAE Systems plc, an international defense, aerospace and security company which delivers a full range of products and services for air, land and naval forces, as well as advanced electronics, security, information technology solutions and customer support services. Improving the future and protecting lives is an ambitious mission, but it's what we do at BAE Systems. Working here means using your passion and ingenuity where it counts - defending national security with breakthrough technology, superior products, and intelligence solutions. As you develop the latest technology and defend national security, you will continually hone your skills on a team-making a big impact on a global scale. At BAE Systems, you'll find a rewarding career that truly makes a difference. Intelligence & Security (I&S), 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. At BAE Systems, we celebrate the array of skills, experiences, and perspectives our employees bring to the table. For us, differences are a source of strength. We're laser-focused on high performance, and we work hard every day to nurture an inclusive culture where all employees can innovate and thrive. Here, you will not only build your career, but you will also enjoy work-life balance, uncover new experiences, and collaborate with passionate colleagues.
Preferred Skills and Education
EEO Career Site
Equal Opportunity Employer. Minorities . females . veterans . individuals with disabilities . sexual orientation . gender identity . gender expression
As a member of our team, you will join a diverse group of driven professionals who design the products and systems that support enhanced capabilities, protect national security, and keep critical information and infrastructure secure. With us, you will be able to make an impact while you hone your skills and grow in your career.
BAE Systems is looking for an experienced ETL Engineer to join a strong team supporting our government customer. This position will provide the ability to make a significant impact to the mission.
Successful candidate will need to be able to maintain existing software as the transition from server-based to cloud-based occurs. The candidate will work with a GOTS-based Extract, Transform and Load (ETL) system that loads information into Postgres database with billions of rows and deals with a file repository that is in a Petabyte range. In addition, the candidate will be highly involved in the engineering planning and transition of the existing system software / data into a Cloud-based (currently AWS) solution.
- Design, develop, and maintain the ETL (Extract, Transform, Load) processes for master data management (MDM) system.
- Build and optimize data pipelines to extract data from various sources, transform it into the required format, and load using Databricks and AWS services.
- Collaborate with stakeholders to gather data requirements, understand data sources, and ensure data quality and integrity throughout the ETL process.
- Implement data validation, cleansing, and enrichment techniques to improve the accuracy and completeness of data.
- Monitor and troubleshoot ETL processes to identify and resolve issues in a timely manner.
Required Skills and Education
- Bachelor's degree in Engineering, Computer Science, or other related analytical, scientific, or technical discipline
- At least 6 years' experience with ETL
- Strong proficiency in programming languages such as Scala, or Java.
- Experience in designing and developing ETL workflows using tools like Apache Spark or AWS Glue.
- In-depth knowledge of ETL best practices, data integration techniques, and data quality management.
- Familiarity with different data storage technologies and databases, such as Amazon S3 or Amazon Redshift.
- Proven experience in the engineering planning and transition of existing system software / data into a Cloud-based AWS solution. Must have experience in Linux command lines and continuous integration.
About BAE Systems Intelligence & Security
BAE Systems, Inc. is the U.S. subsidiary of BAE Systems plc, an international defense, aerospace and security company which delivers a full range of products and services for air, land and naval forces, as well as advanced electronics, security, information technology solutions and customer support services. Improving the future and protecting lives is an ambitious mission, but it's what we do at BAE Systems. Working here means using your passion and ingenuity where it counts - defending national security with breakthrough technology, superior products, and intelligence solutions. As you develop the latest technology and defend national security, you will continually hone your skills on a team-making a big impact on a global scale. At BAE Systems, you'll find a rewarding career that truly makes a difference. Intelligence & Security (I&S), 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. At BAE Systems, we celebrate the array of skills, experiences, and perspectives our employees bring to the table. For us, differences are a source of strength. We're laser-focused on high performance, and we work hard every day to nurture an inclusive culture where all employees can innovate and thrive. Here, you will not only build your career, but you will also enjoy work-life balance, uncover new experiences, and collaborate with passionate colleagues.
Preferred Skills and Education
- Understanding of concepts of Data Lakehouse architecture as well as OpenSearch is a plus.
- Experience using software repository tools such GIT or SVN.
EEO Career Site
Equal Opportunity Employer. Minorities . females . veterans . individuals with disabilities . sexual orientation . gender identity . gender expression