Lead ETL Developer: BigQuery to SQL Pipelines

André; United States; On-site; USD 130,000 - 165,000; Full time

Job summary

Andr Global Inc. is seeking a Lead ETL Developer to design, build, test, and deploy data ingestion pipelines that source data from various systems and load into enterprise data warehouses.

You will standardize data, ensure quality, and mentor a team of ETL developers to follow best practices. The role focuses on migrating from GCP BigQuery to SQL-based warehouses, implementing robust pipelines, and collaborating with business stakeholders to meet reporting and analytical needs.

Qualifications

• 7+ years of hands-on ETL development experience.
• Experience guiding teams of 4 or more developers.
• Proficiency with data models and ETL pipeline design.
• Strong communication and presentation skills for diverse audiences.

Responsibilities

• Lead ETL and data ingestion processes for migration from GCP BigQuery to SQL warehouses.
• Architect and implement pipelines using modern ETL tools and cloud-native frameworks.
• Mentor a team of 4+ ETL developers on best practices and coding standards.
• Collaborate with stakeholders to validate data requirements for reporting needs.
• Develop robust testing strategies ensuring data integrity and accuracy.
• Optimize pipelines for scalability, performance, and maintainability.
• Verify data models include elements required by downstream BI solutions.
• Prepare clear communications and technical documentation for varied audiences.

Skills

ETL development

BI tools

Data modeling

Team lead

Communication

Tools

Google Cloud Dataform

BigQuery

Medallion Architecture

Job description

Andr Global Inc. is seeking a Lead ETL Developer to design, build, test, and deploy data ingestion pipelines that source data from various systems and load into enterprise data warehouses.

You will standardize data, ensure quality, and mentor a team of ETL developers to follow best practices. The role focuses on migrating from GCP BigQuery to SQL-based warehouses, implementing robust pipelines, and collaborating with business stakeholders to meet reporting and analytical needs.