ETL / Data Developer - Mid-level

Job Description
BAE Systems is looking for a Mid-level ETL / Data Developer to join a strong team supporting our government customer. 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.
The Mid-level ETL / Data Developer will be:

• Proficient with Power BI, data analysis, data query, data aggregation, data visualization, software development, system architecture, data transformation, data management, and big data technology.
• Capable of utilizing Extract, Transform, Load (ETL) processes.
• Experienced in writing complex statements, scripts, stored procedures, triggers, and views implement business intelligence and data warehousing solutions.
• Solid foundation in, and application of, data warehousing and reporting platform concepts with ability to recommend solutions and drive best practices.
• Familiarity with multiple business intelligence environments is preferred.
• Develop ETL mappings to extract data from a source data system (databases, files, etc.), transform the data based on business requirements and load the data into a target data system (databases, files, etc.).
• Conduct performance tuning of the mappings developed to ensure that the data is extracted, transformed, and loaded in a reasonable amount of time based on the requirements.
• Develop Business Intelligence (BI) reports using BI software and perform unit testing of the reports developed.
• Work on multiple phases of the Development Life Cycle (requirements, design, development, testing and deployment) of BI Dashboard and reports.
• Develop required documentation in support of the development life cycle.

#CLOUD2
Required Education, Experience, & Skills

• Possesses and applies expertise on multiple complex work assignments.
• Assignments may be broad in nature, requiring originality and innovation in determining how to accomplish tasks.
• Operates with appreciable latitude in developing methodology and presenting solutions to problems.
• Contributes to deliverables and performance metrics where applicable.
• Minimum of 5 years' experience recommended.
  • In absence of years of experience, certifications or past work may be used to show the level of experience needed to perform at this level.

Preferred Education, Experience, & Skills

• Apache (Niagra Falls (NiFi), TIKA, Hadoop (Hbase, MapReduce, Spark), Airflow)
• Databricks and Lakehouse architecture
• AWS (ElasticSearch, SQS, OpenSearch, CloudWatch, CloudTrail, ELB, EMR, KMS, SNS, Systems Manager)
• .NET
• C#
• JavaScript
• Java (SpringBoot)
• Terraform
• Splunk
• Oracle/SQL
• Python
• Microsoft VBA
• Linux shell
• Perl
• JavaFX

Pay Information
Full-Time Salary Range: $102200 - $173700
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.