Senior Data Solution Architect

Senior Data Solution Architect

Company:

The Boeing Company

Boeing’s Airplane Systems Integration team is hiring for a Senior Data Solution Architect to work at our Everett, WA location.

Position Responsibilities:

• Designs, develops, and maintains ETL routines and reporting using Microsoft SQL Server and Power BI.

• Identifies and recommends changes to optimize the ETL environment, implement monitoring, quality and validation processes to ensure data accuracy and integrity.

• Conducts or coordinates unit and system tests ensuring intelligence is consistent with defined needs.

• Designs and deploys database table structures, reports, and queries.

• Supports implemented BI solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance, and communicating functional and technical issues.

• Conducts comparison processes to identify and develop process improvements; provides recommendations on next steps and manages deliverables.

• Documents specifications for Data Warehouse (DWH) extracts, reports, dashboards, or other outputs.

• Facilitates and leads project planning and execution with cross functional teams across the organization.

• Design, develop, maintain, and optimize current AP Systems Reporting infrastructure systems (Including on Prem SQL Db, data warehouses, and cloud lake house)

• Guides other data and analytics professionals on data standards and practices

• Work closely with AP Systems business intelligence experts to ensure data product attributes accurately represent business process outputs to drive actionable reporting and modeling insights.

• Build repeatable data pipeline strategy across multi environments, leverage automation to make sure ETL solutions are repeatable and scalable

Basic Qualifications (Required Skills/Experience):

• Minimum of 10 years of relevant experience in developing data warehousing solutions, dashboards, scorecards, and analytics.

• Experience in Data Visualization / UX Designer skills - designs user flows and interfaces for data-driven applications and dashboards.

• Proficient in writing T-SQL code, SSIS packages, and Stored Procedures on Microsoft SQL Server.

• Proficiency in system architecture design, including selecting appropriate database technologies, data warehousing solutions, and distributed computing frameworks.

• Proficient in writing Rest API/mTLS to extract data from various physical and cloud databases/data lakes.

Preferred Qualifications (Desired Skills/Experience):

• Bachelor’s degree in Mathematics, Computer Science, or a related field. 

• 15+ years data engineering experience and transforming internal businesses through automation and other technologies.

• Aviation Industry Experience Strongly Preferred.

• Strong problem-solving and troubleshooting skills, with the ability to monitor and optimize the performance of data systems, ensuring data quality, integrity, and security.

• Strong knowledge of data integration and ETL processes, with experience in designing and implementing efficient data pipelines.

• Familiarity with AI concepts and algorithms, with the ability to collaborate with data scientists in implementing AI models and integrating them into data systems.

Work Authorization:

This position is expected to be 100% onsite. The selected candidate will be required to work onsite at one of the listed location options (Everett, WA).

Drug Free Workplace:

• Boeing is a Drug Free Workplace where post offer applicants and employees are subject to testing for marijuana, cocaine, opioids, amphetamines, PCP, and alcohol when criteria is met as outlined in our policies.

Pay Range Summary:

At Boeing, we strive to deliver a Total Rewards package that will attract, engage and retain the top talent.  Elements of the Total Rewards package include competitive base pay and variable compensation opportunities.  

The Boeing Company also provides eligible employees with an opportunity to enroll in a variety of benefit programs, generally including health insurance, flexible spending accounts, health savings accounts, retirement savings plans, life and disability insurance programs, and a number of programs that provide for both paid and unpaid time away from work.  

The specific programs and options available to any given employee may vary depending on eligibility factors such as geographic