Data Engineer (ETL tools, Oracle Data Integrator, Dataiku, Microsoft SSIS)

Job Description
This is a fully remote position
We're seeking a seasoned Senior Data Engineer to lead the design, development, and deployment of large-scale data systems and architectures. You will be responsible for building and maintaining high-performance data pipelines, ensuring data quality and integrity, and collaborating with cross-functional teams to drive business growth through data-driven insights. The ideal candidate will have a strong background in data engineering, experience with cloud-based technologies, and a passion for delivering high-quality data solutions.
Key Responsibilities:

• Design and implement scalable data pipelines and architectures to support business growth and data-driven decision making
• Develop and maintain large-scale data systems, including data warehouses, data lakes, and data processing platforms
• Develop and maintain database scripts, stored procedures, and functions to support business requirements
• Optimize ETL processes to improve performance, reduce latency, and increase data quality
• Troubleshoot ETL issues, resolve data inconsistencies, and implement data quality controls
• Recommend and code efficient and effective data integration and ingestion solutions for challenging problems for medium to large work efforts of medium to high complexity.
• Translate business requirements, data mappings into data integrations and ingestions code solutions.
• Collaborate with cross-functional teams to integrate data into business applications and analytics platforms
• Ensure data quality, integrity, and security through data validation, data governance, and data security best practices
• Develop and maintain data engineering standards, processes, and tools to ensure consistency and efficiency
• Develop and maintain documentation for ETL processes, including data flow diagrams, data mapping documents, and ETL scripts
• Stay up-to-date with emerging technologies and trends in data engineering and apply knowledge to improve data systems and processes

Required Education, Experience, & Skills

• 10+ years of experience in data engineering, with a focus on designing and implementing large-scale data systems
• US citizenship or green card
• 8 + years of hands-on experience in writing complex, highly-optimized queries across large data sets using Oracle, SQL Server and Redshift.
• 8 + years of hands-on experience using AWS Glue, python/pyspark to build ETL pipelines in a production setting, including writing test cases
• 8+ years of experience in ETL development, with a focus on designing and implementing efficient and scalable data integration solutions
• Strong experience with multiple database management systems, including relational databases such as Oracle, SQL Server, Redshift.
• Strong experience with ETL tools, such as Oracle Data Integrator, Dataiku, or Microsoft SSIS
• Strong experience with cloud-based technologies, including AWS and AWS Services or Azure Cloud Platform
• Proficiency in programming languages, including Python, Java, or Scala
• Experience with data warehousing, data lakes, and data processing platforms, such as Spark
• Experience in leading and delivering end-to-end projects independently.
• Well versed in modern software development practices (Agile, TDD, CICD)
• Strong understanding of data governance, data security, and data quality best practices
• Excellent communication and collaboration skills, with the ability to work with cross-functional teams
• Experience with containerization, such as Docker, and orchestration, such as Kubernetes
• Knowledge of data visualization tools, such as Tableau or Power BI

Preferred Education, Experience, & Skills

• Master's degree in Computer Science, Engineering, or related field
• Experience with big data technologies, such as NoSQL databases, Hadoop, or Spark
• Knowledge of machine learning and artificial intelligence concepts and technologies

Pay Information
Full-Time Salary Range: $75510 - $128340
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, Inc.
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.