Lead ETL Developer

Mbi Llc; Des Moines (IA); Hybrid; USD 110,000 - 150,000; Full time

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

• - The Lead ETL Developer will design, build, test, and deploy data ingestion and migration pipelines that source historical and real-time data from a variety of disparate systems, including flat files and relational databases.
• - The developer will transform and standardize incoming data into enterprise data models and ensure efficient, accurate loading into data warehouses, data lakes, and analytical databases.
• - This role is responsible for ensuring that transactional and analytical data models include required data elements and meet quality, reliability, and performance expectations.
• - The Lead ETL Developer will mentor and guide a team of ETL developers, establishing best practices and consistent development patterns throughout the project lifecycle.

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.

Fill the skill matrix below:

Skill

Amount

Candidate's No. of years of experience

Required

7

Expertise with modern ETL and reporting/BI tools

Required

7

Strong understanding of enterprise data models and best practices in ETL pipeline design.

Required

7

Proven experience as a Technical Lead guiding teams of 4 or more developers

Required

7

Demonstrated experience with Google Cloud Dataform

Required

7

Demonstrated experience with BigQuery

Required

7

Demonstrated experience with Medallion Architecture

Required

7

Exceptional communication and presentation skills, capable of engaging diverse audiences

Required