Job Description
The Opportunity: Join BAE Systems’ Intelligence and Security Sector and be part of a diverse and enthusiastic team who supports the U.S Navy’s Strategic System Program (SSP). We are searching for a Data Integration Specialist to support the Software Solutions Team. This is a hybrid position requiring a minimum of 50% of the two week pay period hours in the office (three days one week/two days one week).
The Role: As a Data Integration Specialist you will be a critical part of our data team responsible for designing, developing, and maintaining ETL processes that ensure the availability, accuracy, and reliability of data for analytics and reporting within Informatica Power Center. You will collaborate with data analysts, data engineers, and business stakeholders to deliver high-quality solutions that drive data-driven decision-making and business growth.
Key Responsibilities
- ETL Development: Design, develop, test, and maintain ETL processes to extract data from various sources, transform it into a usable format, and load it into data warehouses or data lakes.
- Data Integration: Integrate and consolidate data from multiple sources, ensuring data consistency and accuracy.
- Performance Optimization: Identify and resolve performance bottlenecks within ETL processes to ensure efficient data extraction and transformation.
- Data Quality Assurance: Implement data quality checks and validation procedures to maintain data integrity and consistency.
- Documentation: Create and maintain comprehensive documentation of ETL processes, data models, and data lineage.
- Collaboration: Collaborate with data analysts and business users to understand data requirements and ensure ETL solutions meet business needs.
- ETL Framework Maintenance: Manage and enhance the ETL framework to support scalability and sustainability.
- Troubleshooting: Troubleshoot and resolve ETL-related issues in a timely manner to minimize downtime.
Who You Are:
- You are eager to work in a DoD environment supporting the customer’s mission
- You love learning how to use and administer new tools and technologies
- You enjoy working with people and collaborating across teams
- You have a high degree of personal drive, initiative and the ability to drive change
Required Education, Experience, & Skills
BAE has found that success in this position requires:
- Proven experience as an ETL Developer or in a similar role
- Proficiency in ETL tools and technologies, such as Informatica Power Center
- Strong SQL and scripting skills for data manipulation and transformation
- Experience with data modeling and warehousing concepts
- Knowledge of data integration best practices and techniques
- Strong analytical and problem-solving skills
- Excellent communication and teamwork skills
- Attention to detail and a commitment to data accuracy and quality
- An active Secret clearance; ability to obtain and maintain a Top Secret clearance
- An IAT II certification (for example Security+) as specified in the DoD 8570
- Or have a SECNAV 5239 qualifying degree AND the ability to meet the requirements for an IAT II certification as specified in the DoD 8570 within 6 months of hire date
- On-site Tuesday and Wednesday with a third day of your choice for a minimum of three days in the office each week.
- Ability to obtain and maintain Common Access Card (CAC) along with badge access to the customer’s facility, and to obtain and maintain a network account in good standing on the customer’s network
Preferred Education, Experience, & Skills Additional experience that will further contribute to your success include:
- Experience with Informatica Power Center and Developer Tools
- Experience with Oracle and MS SQL Server
Pay Information
Full-Time Salary Range: $112420 - $191070
Please note: This range is based on our market pay structures. However, individual salaries are determined by a variety of factors including, but not limited to: business considerations, local market conditions, and internal equity, as well as candidate qualifications, such as skills, education, and experience.
Employee Benefits: At BAE Systems, we support our employees in all aspects of their life, including their health and financial well-being. Regular employees scheduled to work 20+ hours per week are offered: health, dental, and vision insurance; health savings accounts; a 401(k) savings plan; disability coverage; and life and accident insurance. We also have an employee assistance program, a legal plan, and other perks including discounts on things like home, auto, and pet insurance. Our leave programs include paid time off, paid holidays, as well as other types of leave, including paid parental, military, bereavement, and any applicable federal and state sick leave. Employees may participate in the company recognition program to receive monetary or non-monetary recognition awards. Other incentives may be available based on position level and/or job specifics.
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.
Our Commitment To Diversity, Equity, And Inclusion
At BAE Systems, we work hard every day to nurture an inclusive culture where employees are valued and feel like they belong. We are conscious of the need for all employees to see themselves reflected at every level of the company and know that in order to unlock the full potential of our workforce, everyone must feel confident being their best, most sincere self and be equipped to thrive. We provide impactful professional development experiences to our employees and invest in social impact partnerships to uplift communities and drive purposeful change. Here you will find significant opportunities to do meaningful work in an environment intentionally designed to be one where you will learn, grow and belong.