Extract-Transform-Load Business Intelligence Engineer

Key Skills

Agile methodologies, Alteryx, Analytical and Problem solving, Business Intelligence, C# Programming, Data extraction, Data pipelines, Effective communication skills, ETL frameworks, Planning and organization, PowerShell Programming, Project management, Python Programming, SQL, Tableau, Talend, Transformer

Job Description

Why BAE Systems? BAE Systems is the third largest defense contractor in the world with an exceptional, mission-focused culture. The 800+ BAE Systems employees and sub-contractors located at Hill Air Force Base, Utah are closely aligned to the United States Air Force Nuclear Weapons Center. We support the Center in sustaining the existing LGM-30 Minuteman III (MM III) weapon system and acquiring its replacement, the Sentinel formerly known as Ground-Based Strategic Deterrent. We are a uniquely-valued mission partner delivering daily technical excellence and innovative solutions to our government customers. BAE Systems has earned accolades as a “Top Workplace” in Utah based on employee feedback for four consecutive years, earning special distinction for providing a healthy work-life balance for our valued employees. We typical work 40 hours a week and we work very hard to ensure this is a great place to work!

Why Utah? You’ve got to see it to believe it! Utah is an amazing state with diverse geography, an eclectic culture and an exceptional quality of life. We are located north of Salt Lake City at the foot of the beautiful Wasatch Mountains. The area offers an incredible range of outdoors pursuits across the seasons including hiking, climbing, hunting, fishing, camping, boating and world-class skiing at resorts that hosted the 2002 Winter Olympics. The state is home to five amazing National Parks and an easy drive from two more; Grand Teton and, famously, the first National Park in the world, Yellowstone. The Salt Lake City area offers a vast array of cultural activities and businesses including multiple professional sports teams. It is a western states hub for exceptional, cutting-edge medical care with people traveling from across the region for a range of nationally renowned specialty care centers and doctors. The Salt Lake International Airport is expanding and offers easy, direct access to just about anywhere you want to fly.

Why Sentinel? The Sentinel Program is an enormous and complex “Mega-Project” modernizing the entire ICBM weapon system deployed across tens of thousands of square miles in five states. Without any doubt, Sentinel is one of the DoD’s most important acquisition efforts for the next decade, if not longer. It includes a complete refurbishment of hundreds of aging Minuteman III ICBM facilities to secure and support a newly designed, technologically advanced ballistic missile. It will also provide an entirely new command and control system as well as vast array of required support equipment specifically engineered to operate and sustain the new weapon system over the decades ahead. Sentinel is one of the Department of Defense’s newest official “program of record,” having just achieved Milestone B. It enjoys broad, strong support at the national level. It is a long-term project -- the weapon system will deploy over a nine-year period beginning in approximately 2026, and remain operational until at least 2075. Sentinel is a career-defining program that will present unique and challenging opportunities that simply are not available with smaller projects.

Tell me about this job: The primary focus of this position is to build and maintain a data pipeline. The current data pipeline is a combination of manual file exports (CSV, JSON, XML), and T-SQL code in an on-prem, air-gapped SQL Server database. We are moving to a cloud-based network and would like to create a more maintainable data pipeline using modern ETL tools. This is a great opportunity to work on a data pipeline from the ground up, please apply to find out more!

#ASFS

Required Education, Experience, & Skills

• Bachelor’s degree or higher in software engineering, computer science, or information technologies. Other degrees will be considered provided that a candidate can demonstrate experience developing and maintaining a data warehouse.
• 10 years of experience (8 with Master’s degree)
• Experience building data pipelines with ETL tools, such as Talend, Alteryx, or SSIS
• Coding experience with SQL, C# or Powershell, or Python
• Self-motivated and works well under minimal supervision
• Communication skills (written or verbal), including the ability to help others understand tools, technologies, and processes used to solve a problem
• This position requires the successful candidate to be able to obtain a Secret level clearance. The criteria for obtaining and holding a clearance are driven by US government requirements. You must be a US citizen to obtain a security clearance.

Preferred Education, Experience, & Skills

• Experience working on an Agile team
• Cross-functional engineering experience, such as aerospace/computer science or physics/programming OR
• Cross-functional business experience, such as project management/computer science or sales and marketing/data science
• Superior organizational skills and an affinity for detail
• Willingness to recommend solutions to improve new and existing database systems
• Security+ certificate

Pay Information

Full-Time Salary Range: $100530 - $170910

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.