Lead ETL Architect: Cloud Data Pipelines & Mentorship

Mbi Llc

Des Moines (IA)

Hybrid

USD 110,000 - 150,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Mbi Llc is seeking a Lead ETL Developer to design, build, and deploy data pipelines across historical and real-time sources. You will mentor a team, establish best practices, and ensure data quality for reporting and analytics.

The role focuses on migrating from GCP BigQuery to SQL-based warehouses, using modern ETL tools and cloud-native frameworks, while communicating complex concepts to diverse audiences.

Qualifications

  • Expertise with modern ETL and reporting/BI tools.
  • Strong understanding of enterprise data models and best practices in ETL pipeline design.
  • Proven experience as a Technical Lead guiding teams of 4 or more developers.
  • Demonstrated experience with Google Cloud Dataform.
  • Demonstrated experience with BigQuery.
  • Demonstrated experience with Medallion Architecture.
  • Exceptional communication and presentation skills, capable of engaging diverse audiences.

Responsibilities

  • Lead development of ETL and data ingestion processes supporting the migration from GCP BigQuery to SQL-based data warehouse environments.
  • Architect and implement pipelines using modern ETL tools and cloud-native data processing frameworks.
  • Train and mentor a team of 4+ ETL developers on best practices, coding standards, and data model design.
  • Collaborate with business and technical stakeholders to validate data requirements and ensure alignment with reporting and analytical needs.
  • Develop robust testing strategies to ensure data integrity, completeness, and accuracy throughout the migration process.
  • Optimize pipelines for scalability, performance, and maintainability.
  • Validate transactional and analytical data models to ensure they contain the necessary elements for downstream applications and BI solutions.
  • Prepare and deliver clear communication, presentations, and technical documentation suitable for both technical and non-technical audiences.

Skills

ETL/BI tools
Data modeling
Technical leadership
Google Dataform
BigQuery
Medallion architecture
Communication skills

Job description

Mbi Llc is seeking a Lead ETL Developer to design, build, and deploy data pipelines across historical and real-time sources. You will mentor a team, establish best practices, and ensure data quality for reporting and analytics.

The role focuses on migrating from GCP BigQuery to SQL-based warehouses, using modern ETL tools and cloud-native frameworks, while communicating complex concepts to diverse audiences.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead ETL Developer: BigQuery to SQL Pipelines
Lead ETL Developer: BigQuery to SQL Pipelines

André • United States

On-site
USD 130,000 - 165,000
Lead ETL Developer
Lead ETL Developer

Mbi Llc • Des Moines (IA)

Hybrid
USD 110,000 - 150,000
ETL Lead
ETL Lead

TechDigital Group • Secaucus (NJ)

On-site
USD 120,000 - 180,000
ETL Lead - 100% REMOTE
ETL Lead - 100% REMOTE

André • United States

On-site
USD 130,000 - 165,000
Lead Big Data Engineer - Cloud Pipelines & Analytics
Lead Big Data Engineer - Cloud Pipelines & Analytics

Compunnel Inc. • Atlanta (GA)

On-site
USD 120,000 - 150,000
ETL Developer – Cloud Data Pipelines & Warehousing
ETL Developer – Cloud Data Pipelines & Warehousing

Ethereum Technologies LLC • Denver (CO)

On-site
USD 90,000 - 150,000
Lead Data Engineer: Cloud Architect & AI Pipelines
Lead Data Engineer: Cloud Architect & AI Pipelines

Texas Gas Transmission • Houston (TX)

On-site
USD 140,000 - 190,000
Senior Data Engineer, GCP Cloud Data Pipelines
Senior Data Engineer, GCP Cloud Data Pipelines

InventYOU AB • Kentucky

On-site
USD 120,000 - 180,000
ETL Engineer: Build Scalable Data Pipelines & Warehouses
ETL Engineer: Build Scalable Data Pipelines & Warehouses

Quantum Technologies. LLC • San Jose (CA)

On-site
USD 140,000 - 170,000
Lead Data Engineer: Architect & Deliver Scalable Pipelines
Lead Data Engineer: Architect & Deliver Scalable Pipelines

EPAM Systems • United States

Remote
USD 140,000 - 190,000
Healthcare benefits
Employee training & certificates
Paid time off