Lead ETL Developer - GCP / BigQuery

Nexiva•Des Moines, IA

About The Position

The Lead ETL Developer will lead the design, development, testing, and deployment of data ingestion and migration pipelines for a conversion initiative moving data from GCP BigQuery into enterprise SQL data warehouse environments. The pipelines will source historical and real-time data from disparate systems, including flat files and relational databases, and transform and standardize it for loading into data warehouses, data lakes, and analytical databases. The role ensures that transactional and analytical data models include required data elements and meet quality, reliability, and performance expectations. The Lead ETL Developer will provide leadership, training, architecture guidance, and technical oversight to a team of ETL developers. They will establish consistent development patterns and best practices across the project, collaborate with business and technical stakeholders, and communicate technical information to both technical and non-technical audiences. The initiative supports continuity and modernization for applications that currently depend on FACS.

Requirements

  • 7 years of hands-on ETL development experience.
  • 7 years of expertise with modern ETL and reporting/BI tools.
  • 7 years of experience with enterprise data models and ETL pipeline design best practices.
  • 7 years of experience as a technical lead guiding teams of 4 or more developers.
  • 7 years of demonstrated experience with Google Cloud Dataform.
  • 7 years of demonstrated experience with BigQuery.
  • 7 years of demonstrated experience with Medallion Architecture.
  • Exceptional communication and presentation skills, with the ability to engage diverse audiences.
  • Local candidates only; in-person interview required.
  • Must be a U.S. citizen or Green Card holder.

Responsibilities

  • Lead development of ETL and data ingestion processes supporting 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 or more ETL developers on best practices, coding standards, and data model design.
  • Collaborate with business and technical stakeholders to validate data requirements and align with reporting and analytical needs.
  • Develop 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 communications, presentations, and technical documentation for technical and non-technical audiences.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service