Lead ETL Developer - GCP / BigQuery

Nexiva•Des Moines, IA
•Onsite

About The Position

The Lead ETL Developer will lead the VISION–CWIS FACS Conversion Initiative, which extracts data from Google Cloud Platform (GCP) BigQuery and delivers it to enterprise SQL data warehouses. The initiative supports continuity and modernization for applications that depend on FACS. The role designs, builds, tests, and deploys data ingestion and migration pipelines sourcing historical and real-time data from disparate systems, including flat files and relational databases. It transforms and standardizes incoming data into enterprise data models and loads it into data warehouses, data lakes, and analytical databases. The developer ensures transactional and analytical data models contain required data elements and meet quality, reliability, and performance expectations. The Lead ETL Developer also provides leadership, training, architecture guidance, and technical oversight to a team of ETL developers, establishing consistent best practices and development patterns throughout the project lifecycle.

Requirements

  • Seven years of hands-on ETL development experience.
  • Seven years of experience with modern ETL and reporting/BI tools.
  • Seven years of experience with enterprise data models and ETL pipeline design best practices.
  • Seven years of experience as a technical lead guiding teams of four or more developers.
  • Seven years of demonstrated experience with Google Cloud Dataform.
  • Seven years of demonstrated experience with BigQuery.
  • Seven 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 have U.S. citizenship or a Green Card (GC/USC only).

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 four 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