Business Intelligence Analyst II at BAE Systems, Inc.
Merrimack, New Hampshire, United States — full-time
We are seeking a Business Intelligence Analyst with strong data modeling and dashboard development skills to join the Facilities Operational Excellence team. This role will support the Business Intelligence Manager in developing and managing high-quality data solutions, including data models, interactive dashboards, and data-rich reports that support strategic, operational, and financial decision-making. The analyst will perform data extraction, ETL, data transformation, and validation activities to support existing data environments and ensure data accuracy and integrity. This role will help establish trusted, accessible data and analytics capabilities while building the data infrastructure needed to support BAE Systems’ long-term strategic goals. BI Dashboard Development & Visualization Design, build, and maintain Power BI dashboards that translate data into clear, actionable insights for stakeholders. Develop and refine data models and dashboard solutions to improve performance, usability, and consistency. Create clear and effective visualizations that highlight trends, patterns, and key business information to support decision-making. Data Preparation & Integration Develop and maintain ETL processes to extract, transform, and load data from multiple sources for analysis and reporting. Implement data validation and quality checks to improve the accuracy and reliability of data solutions. Document data sources, transformation logic, and data models to support ongoing maintenance and reuse. Process Optimization & Continuous Improvement Use data and analytics to identify opportunities for process improvement and operational efficiency. Develop automation solutions using Power Automate and other business tools to reduce manual effort and improve data accuracy. Support the evaluation and implementation of new technologies and analytical capabilities. Collaboration, Documentation & Stakeholder Support Partner with Project Management, Facilities Operations, Strategic Planning, Finance, and other functional teams to understand business needs and develop effective data solutions. Translate business requirements into technical specifications and analytical solutions. Provide training and support to users of BI tools and dashboards. Maintain documentation for BI solutions, including data sources, data models, ETL processes, and dashboard functionality. Required Education, Experience, & Skills Bachelor’s degree in Data Analytics, Business, Finance, Engineering, Computer Science, or related field and 2 years of professional experience. Each additional level of education can substitute for 2 years of experience. 2+ years of experience developing dashboards using Power BI or Tableau. Strong understanding of data modeling and ETL processes. Excellent attention to detail, organization, communication, and problem-solving skills. Preferred Education, Experience, & Skills Experience developing ETL processes using Python. Experience developing and publis