The Senior Developer will execute ETL processes, develop BI reports, write complex SQL statements, and manage software development within Agile frameworks. A strong background in data manipulation and visualization using Python and BI tools is essential.
Job Description
Proficiency 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.
Required Education, Experience, & Skills
Preferred Education, Experience, & Skills
Preferred Education: Bachelor's Degree in one of the following areas: Computer Science, Computer Engineering, Software Engineering, Electrical Engineering, Computer and Information Security, Computer Security, and/or Network Administration from an accredited university/college.
Minimum/General Experience: Recent work experience as a senior-level or technical lead in a related position on a major program, project, or activity. A minimum of seven (7) years recent experience in the direct performance of a major program, project, or activity relating to computer software development at the user and kernel level, computer programming, and /or computer digital forensics.
Pay Information
Full-Time Salary Range: $130355 - $221603
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.
This position will be posted for at least 5 calendar days. The posting will remain active until the position is filled, or a qualified pool of candidates is identified.
Proficiency 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.
Required Education, Experience, & Skills
- Experience and desire to execute complex extraction, transformation, and load of large diverse datasets using Python and other languages as needed
- Must be a strong written and verbal communicator
- 8+ years of ETL work experience
- 5+ years Python development experience
- 1+ years Agile project experience
- Must be able to write SQL queries to pull data from the MySQL, Postgres & SQL Server databases.
- 1+ years of working knowledge of Linux, Docker, Kubernetes, Git, Gitflow, CI/CD Pipelines, Jira, PowerBI, Splunk, DBeaver and Visual Studio Code.
- 1 + years of experience developing and/or working in an Amazon Workspace environment
- 1+ years of experience in querying and retrieving data from a Lucene based index.
- BS in Computer Science or similar technical.
- Experience creating tools, platforms, and environments for demos, product testing, and software releases.
- Experience creating products, utilities, scripts, and tools to automate builds, deployment, and testing.
- Experience building and maintaining development and testing environments and production-equivalent staging environments.
- Experience troubleshooting operational tests, releases, software defects, and other issues.
- Must have strong problem solving and analytical skills, as well as the ability to develop business requirements and specifications
- Ability to work on problems of limited scope and conduct analysis of data processes
- Ability to work independently to complete project activities; possessing initiative to address issues and opportunities
- Flexible and able to work under tight schedules to meet deadlines
- Ability to implement solutions and identify operational or management issues
- Creative, collaborative, team-oriented
Preferred Education, Experience, & Skills
Preferred Education: Bachelor's Degree in one of the following areas: Computer Science, Computer Engineering, Software Engineering, Electrical Engineering, Computer and Information Security, Computer Security, and/or Network Administration from an accredited university/college.
Minimum/General Experience: Recent work experience as a senior-level or technical lead in a related position on a major program, project, or activity. A minimum of seven (7) years recent experience in the direct performance of a major program, project, or activity relating to computer software development at the user and kernel level, computer programming, and /or computer digital forensics.
Pay Information
Full-Time Salary Range: $130355 - $221603
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.
This position will be posted for at least 5 calendar days. The posting will remain active until the position is filled, or a qualified pool of candidates is identified.
Top Skills
Ci/Cd Pipelines
Dbeaver
Docker
Etl Processes
Git
Gitflow
JIRA
Kubernetes
Linux
MySQL
Postgres
Power BI
Python
Splunk
SQL
SQL Server
Visual Studio Code
BAE Systems, Inc. Burlington, Massachusetts, USA Office
600 District Ave, Burlington, MA, United States, 01803
Similar Jobs at BAE Systems, Inc.
Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
The role involves analyzing cyber threat data, performing reverse engineering, developing software solutions, and collaborating within a team environment in cybersecurity.
Top Skills:
.Net C#AngularApache KafkaApache NifiAWSCSSDjangoDockerElasticsearchGitGraphQLJavaScriptJqueryKubernetesLinuxMySQLNode.jsPostgresReactRedisSplunkSvelte
Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
The Senior Data Engineer will develop visual analytics applications, manage large relational databases, and integrate systems to enhance data processing and intelligence.
Top Skills:
AWSElasticsearchGraphQLLuceneMySQLNode.jsNoSQLPostgresPythonRabbitMQReactRedisSQL
Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
The role involves developing ETL processes, migrating data to cloud systems, and maintaining security operations for law enforcement purposes.
Top Skills:
Active Directory Federation ServicesDockerElasticsearchETLGitlabGreHyperglanceIpa/FreeipaIpsecJIRAKubernetesLdapLinuxmacOSNetappPowershellPythonRabbitMQSambaShellSmtpSonicwall FirewallSshSslTerraformVsphereVxrailWdsWindowsWindows Active DirectoryWsus
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories