Redshift Jobs in Missouri (NOW HIRING)

Associate Data Solutions Architect

Company:

The Boeing Company

The Boeing Company is currently seeking an Associate Data Solutions Architect to join the team in Seattle, WA; Hazelwood, MO; Berkeley, MO; or Dallas, TX.

The Data Solutions Architect will help design, build, and operate data pipelines and workloads across on-prem and cloud platforms (Google Cloud Platform (GCP) and Amazon Web Services (AWS)). The role partners with data and Business Intelligence (BI) analysts, data scientists, product specialists, and platform engineers to enable reliable, scalable ingestion, transformation, and serving of data for analytics and Artificial Intelligence (AI) use cases in supply chain.

Position Responsibilities:

• Implement, test, and maintain Extract, Transform, Load/Extract, Load Transform (ETL/ELT) pipelines to ingest data from on-prem systems and cloud sources into data lakes/warehouses

• Develop data transformations and data models to support reporting, analytics, and Machine Learning (ML) workloads

• Build and maintain batch and streaming data workflows using orchestration tools (Airflow, Cloud Composer, Prefect, etc.) and data integration platforms (Informatica, Talend, Fivetran, etc.)

• Work with on-prem technologies (databases, file shares, middleware) and cloud services (BigQuery, Redshift, Cloud Storage, S3, Dataflow, Glue) to move and transform data

• Collaborate with data owners to profile data, identify quality issues, and implement data validation and cleansing rules

• Design and implement data cataloging, lineage, and basic governance controls for datasets

• Monitor pipeline health, troubleshoot failures, and implement alerts and automated retries

• Contribute to Continuous Integration and Continuous Delivery (CI/CD) for data pipelines and infrastructure-as-code patterns (Terraform, Cloud Deployment Manager, etc.)

• Produce clear technical documentation and runbooks for operational support and handoffs

• Support production handover, incident response, and post-incident retrospectives

BasicQualifications (Required Skills/Experience):

• 1+ years of experience building data pipelines, ETL/ELT processes, and/or data engineering tasks

• 1+ years of experience with SQL

• Experience designing queries and data models for analytics

• Experience with scripting languages (Python or R programming) for data processing and automation

• Experience with orchestration tools (Airflow, Prefect, Cloud Composer)

• Experience with relational databases (Oracle, SQL Server, Postgres)

• Experience with cloud data service (BigQuery, Redshift, Snowflake, and/or equivalent)

• Experience with data quality, basic data governance, and logging/monitoring concepts

Preferred Qualifications (Desired Skills/Experience):

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field and/or equivalent experience

• 3+ years of experience with data engineering across on-prem and cloud environments

• Experience with troubleshooting skills with a collaborative mindset

• Experience with good written and verbal communication skills

• Experience with cloud platforms GCP and/or AWS (BigQuery, Cloud Storage, Dataflow, Pub/Sub, DataProc, S3, Redshift, Glue, Lambda)

• Experience building streaming and/or near-real-time pipelines (Kafka, Pub/Sub, Kinesis, Spark Streaming)

• Experience building ETL data pipelines (Informatica, Talend, Fivetran, etc.)

• Experience with infrastructure-as-code tooling (Terraform, CloudFormation) and CI/CD practices for data workflows

• Experience implementing data cataloging/lineage tools (Data Catalog, Amundsen, Collibra, Alation) and data quality frameworks (Great Expectations, AWS Glue Data Quality)

• Experience with containerization (Docker) and deploying microservices and/or data jobs on Kubernetes

• Experience tuning for SQL and data processing jobs for cost-optimization on cloud platforms

• Experience working in supply chain, manufacturing, and/or within aerospace environments

Drug Free Workplace:

Boeingis 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 & Benefits:

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 location, date of hire, and the applicability of collective bargaining agreements.

Pay is based upon candidate experience and qualifications, as well as market and business considerations.

Summary pay range: $95,200 - $138,000

Language Requirements:

Not Applicable

Education:

Not Applicable

Relocation:

This position offers relocation based on candidate eligibility.

Export Control Requirement:

This position must meet U.S. export control compliance requirements. To meet U.S. export control compliance requirements, a "U.S. Person" as defined by 22 C.F.R. 120.62 is required. "U.S. Person" includes U.S. Citizen, U.S. National, lawful permanent resident, refugee, or asylee.

Safety Sensitive:

This is not a Safety Sensitive Position.

Security Clearance:

This position does not require a Security Clearance.

Visa Sponsorship:

Employer will not sponsor applicants for employment visa status.

Contingent Upon Award Program

This position is not contingent upon program award

Shift:

Shift 1 (United States of America)

Stay safe from recruitment fraud! The only way to apply for a position at Boeing is via our Careers website. Learn how to protect yourself from recruitment fraud - Recruitment Fraud Warning