Data Solution Architect

Boeing Future of Flight; Everett (WA); On-site; USD 131,000 - 145,000; Full time

Benefits offered by this job

Medical

Dental

Vision

401K

Job summary

Boeing is seeking a Data Solution Architect on a contract basis to join the Airplane Systems Integration team. The role focuses on designing and maintaining ETL pipelines, data warehouses, and BI reports using Microsoft SQL Server and Power BI.

Responsibilities include coordinating cross-functional projects, optimizing data architectures, and ensuring data quality and security in on-prem and cloud environments.

Qualifications

• Minimum of 5 years of relevant experience in developing data warehousing solutions, dashboards, scorecards, and analytics.
• Proficient in writing T-SQL code, SSIS packages, and Stored Procedures on Microsoft SQL Server.
• Strong knowledge of data integration and ETL processes, with experience in designing and implementing efficient data pipelines.
• Proficiency in system architecture design, including selecting appropriate database technologies, data warehousing solutions, and distributed computing frameworks.
• Familiarity with AI concepts and algorithms, with the ability to collaborate with data scientists in implementing AI models and integrating them into data systems.
• Strong problem-solving and troubleshooting skills, with the ability to monitor and optimize the performance of data systems, ensuring data quality, integrity, and security.
• Proficient in writing Rest API/mTLS to extract data from various physical and cloud databases/data lakes.
• Experience in Data Visualization / UX Designer skills - designs user flows and interfaces for data-driven applications and dashboards.

Responsibilities

• Designs, develops, and maintains ETL routines and reporting using Microsoft SQL Server and Power BI.
• Identifies and optimizes ETL environment, implements monitoring, quality and validation processes.
• Conducts unit and system tests to ensure data integrity and alignment with requirements.
• Designs and deploys database tables, reports, and queries.
• Supports BI solutions by monitoring queries and data loads and addressing data issues.
• Guides data standards and practices across teams.
• Builds repeatable data pipeline strategies across environments with scalable ETL solutions.

Skills

ETL routines

MS SQL Server

Power BI

T-SQL

SSIS

Stored Procedures

Data integration

AI concepts

REST API/mTLS

Data Visualization

Education

Bachelor's degree in mathematics, Computer Science, or related field

Tools

AP Systems Reporting infrastructure

Job description

This posting is for a contract assignment and is not a full-time employment offer with Boeing. Candidates selected for roles will be employed as contract workers through a Boeing approved 3rd party for the duration of the specified project.

Boeing Commercial Airplanes (BCA) is looking for a Data Solution Architect to join the Airplane Systems Integration team.

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

Required Skills:

• Minimum of 5 years of relevant experience in developing data warehousing solutions, dashboards, scorecards, and analytics.
• Proficient in writing T‑SQL code, SSIS packages, and Stored Procedures on Microsoft SQL Server.
• Strong knowledge of data integration and ETL processes, with experience in designing and implementing efficient data pipelines.
• Proficiency in system architecture design, including selecting appropriate database technologies, data warehousing solutions, and distributed computing frameworks.
• Familiarity with AI concepts and algorithms, with the ability to collaborate with data scientists in implementing AI models and integrating them into data systems.
• Strong problem-solving and troubleshooting skills, with the ability to monitor and optimize the performance of data systems, ensuring data quality, integrity, and security.
• Proficient in writing Rest API/mTLS to extract data from various physical and cloud databases/data lakes.
• Experience in Data Visualization / UX Designer skills - designs user flows and interfaces for data-driven applications and dashboards.

Preferred Skills:

• Bachelor’s degree in mathematics, Computer Science, or a related field.
• 10-15+ years data engineering experience and transforming internal businesses through automation and other technologies.
• Aviation Industry Experience Strongly Preferred.

Pay Rate Range

Min Pay Rate $95

Max Pay Rate $105

Currency USD

Unit hourly

Benefits Information

• *Optional Benefits: Medical, Dental, Vision, 401K

Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.