Job Listing Information
- 24-Sep-2026 to 08-Oct-2026 (UTC)
- Des Moines, IA, USA
- Full Time
- Long Term Contract Length
- 40 Weekly Hours
Position Summary
- 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 |
Required/Desired |
Amount |
Candidate's No. of years of experience |
|
Hands-on ETL development 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 |
|