Apply on Employer Site

Boeing · 2 months ago

Senior Data Solution Architect

USA - Everett, WA

Full-time

Onsite

Senior Level, Lead/Staff

$171K/yr - $231K/yr

10+ years exp

The Boeing Company is seeking a Senior Data Solution Architect to join their Airplane Systems Integration team in Everett, WA. This role involves designing and maintaining ETL routines and reporting, optimizing data environments, and leading project planning with cross-functional teams.

AerospaceIndustrial

No H1B

U.S. Citizen Only

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

Qualification

Data warehousing solutionsT-SQL programmingETL processesData visualizationSystem architecture designRest API developmentTroubleshooting skillsProblem-solving skillsCollaboration skillsCommunication skills

Required

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

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