Remote Lead ETL Architect: BigQuery & Medallion

Stellar Professionals; Des Moines (IA); Remote; USD 110,000 - 170,000; Full time

Job summary

Stellar Professionals is seeking a Lead ETL Developer to architect modern data migration pipelines, mentor a team of engineers, and drive a critical database modernization initiative.

As a remote role with an EST shift based in Des Moines, IA, you will guide a 4+ person ETL team, design pipelines sourcing data from Google BigQuery into enterprise SQL data warehouses, and implement Medallion Architecture for scalable analytics while ensuring data quality and performance.

Qualifications

• 7+ years of hands-on ETL development experience.
• 7+ years leading teams of 4+ developers.
• Expert knowledge of Google BigQuery and Google Cloud Dataform.
• Strong expertise in Medallion Architecture (Bronze/Silver/Gold).
• Proficiency in data modeling, SQL data warehousing, and BI/reporting tools.
• Excellent verbal and written communication for cross-functional stakeholder engagement.

Responsibilities

• Lead, train, and oversee a team of 4+ ETL developers.
• Design, build, and deploy automated data pipelines from Google BigQuery to enterprise SQL data warehouses.
• Implement Medallion Architecture models to standardize raw data for analytics.
• Develop testing strategies to maintain data integrity and performance.

Skills

ETL development

Technical leadership

Medallion Architecture

Data modeling

SQL data warehousing

BI/reporting tools

Communication skills

Tools

Google BigQuery

Google Cloud Dataform

Job description

Stellar Professionals is seeking a Lead ETL Developer to architect modern data migration pipelines, mentor a team of engineers, and drive a critical database modernization initiative.

As a remote role with an EST shift based in Des Moines, IA, you will guide a 4+ person ETL team, design pipelines sourcing data from Google BigQuery into enterprise SQL data warehouses, and implement Medallion Architecture for scalable analytics while ensuring data quality and performance.