Lead ETL Developer
JobDiva
Title: Lead ETL Developer
Location: Des Moines, IA (Remote)
Duration: 9 Months
Interview type: Either Web Cam or In Person Interview
Job Description
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.
Required Skills and Experience
- Minimum 7 years of hands-on ETL development experience.
- Expertise with modern ETL and reporting/BI tools.
- Strong understanding of enterprise data models and best practices in ETL pipeline design.
- Proven experience as a Technical Lead guiding teams of 4 or more developers.
Demonstrated experience with:
- Google Cloud Dataform
- BigQuery
- Medallion Architecture
- Exceptional communication and presentation skills, capable of engaging diverse audiences.
Required/Desired Skills:
- Hands-on ETL development experience
- Expertise with modern ETL and reporting/BI tools
- Strong understanding of enterprise data models and best practices in ETL pipeline design.
- Proven experience as a Technical Lead guiding teams of 4 or more developers
- Demonstrated experience with Google Cloud Dataform
- Demonstrated experience with BigQuery
- Demonstrated experience with Medallion Architecture
- Exceptional communication and presentation skills, capable of engaging diverse audiences
Vacancy posted 1 day ago
Similar jobs that could be interesting for youBased on the Lead ETL Developer in Des Moines, IA vacancy
- ...ETL DeveloperWe will transfer visas and process GCs if needed! Charlotte, NC, Chandler, AZ, Phoenix, AZ, Minneapolis, MN, Des Moines, IA - hybrid onsite 2-3 days/week 12+ months- hybrid onsiteRequired Skills:4+ years of Ab Initio experience4+ years of Teradata experience...Suggested2 days per week3 days per week
RIT Solutions
Des Moines, IA2 days ago - ...Lead ETL DeveloperHonorVet Technologies is a Service Disable Veteran-Owned IT staffing firm, ISO 9001 and ISO 27001 certified, working... ...believe there's a fit worth exploring. Job Title: Lead ETL Developer Duration: 8+ Months Location: Des Moines, IA- Remote Interview...SuggestedRemote work
HonorVet Technologies
Des Moines, IA3 days ago - ...Key Responsibilities Lead development redesign and modernization of legacy reporting into new... ...mentoring and guidance to a team of 4 Power BI developers. Work closely with business partners data engineers and ETL developers to ensure accurate data sourcing from...SuggestedFull time
innovitusa
Des Moines, IA1 day ago $95k - $138k
...technology strategy. We are looking for someone to act as a Technical lead and help guide implementations. You will work within a highly... ...is embedded into everything we do - from the products we develop to the quality service we provide. We’re driven by the belief that...SuggestedHourly payPermanent employmentTemporary workWork experience placementH1bWork at office3 days per weekPrincipal Financial Group
Des Moines, IA3 days ago$111.3k - $215.1k
...Seramount, Fair360 and others. If you're as passionate about your future as we are, join our team.KPMG is currently seeking a Technical Lead, Forward Deployed Engineering to join our AI & Data Labs practice.Responsibilities:Rapidly build and deploy end-to-end AI systems as...SuggestedH1bLocal areaKPMG
Des Moines, IA5 days ago$97.5k - $209.5k
...providing advanced solution development and in-depth product knowledge to advance Oracle Health's strategic priorities. As a Lead Consulting Developer, you will focus on developing and optimizing Python code to support AI and machine learning initiatives. This role...Temporary workFlexible hoursOracle
Des Moines, IA1 day ago- ...Lead Application Developer Are you self-driven and thrive in a fast-paced success-oriented environment? Do you have experience in C# / .net, web services, and SQL? Are you customer service oriented, have effective communication skills, and a analytical thinker? If...Full timeWork at officeWork visa
FBL Financial
West Des Moines, IA3 days ago - ...Reference25-247651TypeContractExperience6 Job position: Technical Lead (Node JS/Full Stack) Location: Des Moines, IA Number of years... ..., Node JS, NoSQL DB, CI/CD, CDK Other Requirements: Backend Developer (Node, Lambda, Type Script. Role will be 60% development, 40%...
HonorVet Technologies
Des Moines, IA1 day ago $110.7k - $218.3k
...you will help clients answer questions like: How do I access, develop, and motivate my workforce? What should my AI strategy be for the... ...a Senior Consultant on the team, you will be responsible for: Leading the design, coordination, and delivery of Oracle HCM Cloud technical...Local areaDeloitte
Des Moines, IA4 days ago$99k - $232k
...LevelManagerJob Description & SummaryThe OpportunityAs a Gemini Tech Lead you will lead client-facing generative AI and data... ...Vertex AI, AWS Bedrock, or Azure AI Services based solutions- Developing Python-based prototypes and workflow automation to accelerate delivery...Full timeH1bPwC
Des Moines, IA1 day ago- ...Tech Lead Founded in 1998 and headquartered in Farmington Hills, MI, Kyyba has a global presence delivering high-quality resources and top-notch recruiting services, enabling businesses to effectively respond to organizational changes and technological advances. At...Visa sponsorshipWork visa
Kyyba
Des Moines, IA5 days ago - ...Tech Lead Providing L3 level support to NOC/SOC/GSD/RDMS Acknowledge the ticket in your queue For Server Management, Perform the RCA and work towards resolution. Take care of respective escalation like server/network, security analysis, pure voice support for pure...Night shift
Keylent Inc
Des Moines, IA5 days ago $130k - $200k
Position Summary CCaaS Technical Lead, Senior ConsultantOur Deloitte Sales & Service team empowers organizations to build deeper... ...workstreams for CCaaS and Contact Center AI implementations.Develop solution designs, integration patterns, technical specifications...Local areaDeloitte
Des Moines, IA4 days ago- ....Responsibilities:Serve as the Subject Matter Expert (SME) and lead architect for enterprise-wide F5 Application Delivery Controller... ...and robust application defenseDrive DevOps integration by developing automated provisioning, configuration management, and self-service...H1bLocal area
KPMG
Des Moines, IA1 day ago - ...adopt and scale AI solutions. QualificationsPreferred: Experience developing cloud-native applications and platform services using... ...actively listening and applying coaching feedback. Ability to lead, support and work within a diverse development team model including...Permanent employmentH1b
Wellmark Blue Cross Blue Shield
Des Moines, IA2 days ago - ...which support Wellmark’s business and Technology applications. Leads system development and guides the team in the design, development... ...attention to detail. Previous experience troubleshooting and developing creative technical solutions. Ability to provide innovative solutions...Permanent employmentH1b
Wellmark Blue Cross Blue Shield
Des Moines, IA4 days ago - ...Client: IA-DOM-DOIT Role: Power BI Lead Location: 200 E Grand Avenue, Des... ...this need, an internal team of Power BI developers is being assembled, and the project requires... ...with business partners, data engineers, and ETL developers to ensure accurate data...Remote work
Info Way Solutions
Des Moines, IA2 days ago - ...BinaryBees | People Management, People Connects Salesforce Technical Lead Must Be Citizen or Green Card REMOTE The Salesforce... ...but also providing technical leadership and guidance to junior developers while ensuring the successful delivery of projects. The ideal...Full timeRemote work
BinaryBees Business Solutions LLC
Des Moines, IA6 hours ago $151.6k - $222.4k
...the TeamThe Automation and Configuration Management (ACM) team develops and maintains a configuration platform that enables internal and... ...and build vs. buy tradeoffs to support thousands of customers. Lead and deliver complex, high-impact projects spanning configuration...Full timeTemporary workLocal areaImmediate startRemote workFlexible hoursCISCO Systems
West Des Moines, IA2 days ago- Lead Cloud Platform Developer Are you passionate about cloud technologies, automation, and building platform capabilities that empower development teams? Do you enjoy solving complex technical challenges, mentoring others, and driving operational excellence through modern...Full timeWork at officeWork visa
Farm Bureau Financial Services
West Des Moines, IA1 day ago - ...driving organizational change to transform how we work. Job Description Leads the design, development, and evolution of complex software engineering solutions and internal developer platform capabilities that support Wellmark’s business and technology...Permanent employmentFull timeH1b
Wellmark, Inc.
Des Moines, IA22 days ago - ...Position Title: Lead Engineer Location: Remote (EST) Duration: Long Term Contract (only W2) Team: The team owns the platform end-to-end—from data generation and ingestion through application delivery and user experience. We are responsible for building and maintaining...Long term contractRemote work
Mindlance
Des Moines, IA4 days ago $118.4k
...and software development using the latest technologies and design patterns. A lead engineer will take a leadership role with other development individuals (engineers, application developers, etc.) to drive and develop products meeting the needs of our clients and product...Temporary workFor contractorsWork at officeLocal areaHighmark Health
Des Moines, IA1 day ago- ...technical presentations, and/or regularly represents the firm in professional and technical societies. Collaborates internally to develop and implement strategies and best practices that align with discipline trends and standards. Provides direction in putting...Full timeWork at officeFlexible hours
Olsson
Des Moines, IA4 days ago $105.79k - $141.05k
...to enhance code quality, automate workflows, and deliver exceptional customer experiences. The Main Responsibilities Design, develop, and support scalable digital experiences on AEMaaCS, leveraging modern frontend technologies such as React and Vue.js, APIs, integrations...Full timeTemporary workRemote workLumen
Des Moines, IA2 days ago- ...Opportunities in This Role Technical Direction and Solution Leadership: Lead technical design for Palantir applications, workflows,... ...support across Foundry application teams. Application Engineering: Develop and review maintainable solutions using modern engineering...Full time
CliftonLarsonAllen
Des Moines, IA2 days ago $112.8k - $264.1k
...ecosystem. We are looking for a hands-on engineering manager to lead the Authorization team within IAM. This team is responsible for... ...inclusion, documentation, quality, and long-term maintainability. + Develop and communicate team roadmaps, project plans, risks, and...Temporary workFlexible hoursOracle
Des Moines, IA1 day ago- Job Summary Seeking a Lead Power BI Developer to modernize legacy reporting into Power BI solutions, serving as technical lead for a development... ...4+ Power BI developers Coordinate with data engineers and ETL teams for accurate data sourcing Build accessible, standardized...
- ...innovation, providing comprehensive services for large commercial developments, healthcare facilities, laboratories, educational institutions,... ...make a tangible difference in communities and industries.The Lead Engineer role oversees high-level project design and manages...Full timeFlexible hours
Olsson
Des Moines, IA1 day ago - ...Responsibilities: • Consultant will be guiding the team of developers to build-out a set of services to help serve up data to their... ...communications platform (SmartComm) Requirements: • Experience with leading large implementations • Team Leadership experience •...
3B Staffing LLC
West Des Moines, IA5 days ago
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Lead ETL Developer. Be the first to apply!
