Business Intelligence Analyst

Boeing•Auburn, WA

1d•Onsite

About The Position

Boeing Commercial Airplanes (BCA) Fabrication Division is seeking a Senior Business Intelligence Analyst to support our Supply Chain Integration Core Team in Auburn, Washington. Our Boeing Commercial Airplanes (BCA) Supply Chain Functional Excellence – Performance & Integration team focuses on a data-driven transformation of the organization by providing real-time insights for complex business problems and enhances and aides their decision-making process. The selected candidate will partner with multiple business functions, understand data needs, and deliver high-impact dashboards, reports, process automations, or web applications. This role dominates end-to-end data workflows, from gathering requirements with stakeholders to designing robust data transformation pipelines and creating actionable BI dashboards. The ideal candidate thrives at the intersection of data engineering and business intelligence, enabling data-driven decisions across the organization.

Requirements

4+ years of experience in Supply Chain Business Intelligence
3+ years of SQL proficiency: Demonstrated expertise in writing complex SQL queries and manipulating large datasets
3+ years of experience with BI/visualization tools (Tableau, RShiny, Power BI, Cognos), including report design and performance tuning
3+ years of experience with ETL/ELT workflows and data transformation, including common tools or orchestration frameworks
Experience working with enterprise data warehouses and implementing star/snowflake schemas.
Experience working cross-functionally with business stakeholders to understand needs and deliver actionable data products

Nice To Haves

Bachelor’s degree or higher in Computer Science, Data Analytics, Supply Chain, Manufacturing/Industrial Engineering or closely related field
Deep understanding of the DAX language and data modeling in Power BI
Knowledge of BOMs/MBOMs/EBOMs, MES, PLM systems, and how they interact with supply chain processes
Proficiency in data warehouse development, including the design, development, implementation, and monitoring of fact and dimension objects following Kimball dimensional modeling best practices
Experience building complex Tableau reports and optimizing performance for large datasets
Direct experience in Aerospace business functions such as Supply Chain, Manufacturing, Engineering, Quality, etc.
Experience with programming/scripting languages (e.g., Python) for data manipulation and automation
Experience with ERP systems (Infor LN, SAP, Oracle ERP, Microsoft Dynamics 365 etc.)
Experience in working with ambiguous requirements, asking the right questions to extract business needs from stakeholders and translate into logical and physical data models
Critical thinking, verbal and written communication skills

Responsibilities

Collaborate with business partners to gather data requirements, define KPIs, and translate business needs into technical data solutions
Design, build, and maintain scalable ETL/ELT pipelines to ingest and transform raw data into clean, reliable datasets for reporting
Develop and maintain dashboards, reports, and visualizations that communicate metrics, trends, and status updates using BI tools (e.g., Power BI, Tableau, IBM Cognos)
Contribute to the development of a comprehensive data warehouse supporting analytics and reporting for a complex ERP system
Design and optimize database schema, tables, indexes, and views for efficient data storage and retrieval
Monitor and improve data quality, resolve pipeline errors, and enforce governance and documentation standards
Support ongoing improvement of data processes and automation to reduce manual tasks and accelerate insights
Provide technical guidance to data analysts and support cross-functional teams in interpreting and utilizing dashboard results
Establish new, scalable, efficient, automated processes for tracking and reporting on progress of initiatives