Job Title: Lead ETL Developer
Duration (Contract): 9 Months
Client Location: Des Moines, IA 50309
Location Preference: Remote
Job Description:
As a Lead ETL Developer , you will lead the design, development, and deployment of enterprise data integration solutions supporting large-scale data migration and modernization initiatives. This role is responsible for extracting, transforming, and loading data from cloud-based platforms into enterprise data warehouse environments while ensuring data quality, scalability, reliability, and performance. You will serve as the technical leader for a team of ETL developers, providing architectural guidance, mentoring, best practices, and oversight throughout the project lifecycle. The ideal candidate will possess strong expertise in cloud-based data engineering, ETL development, data modeling, and enterprise analytics platforms, along with proven leadership experience managing complex data transformation initiatives.
Key Responsibilities:
Lead the development of ETL and data ingestion processes supporting large-scale cloud-to-data-warehouse migration initiatives.
Architect, design, and implement data pipelines using modern ETL tools and cloud-native data processing technologies.
Extract, transform, standardize, and load historical and real-time data from multiple source systems, including relational databases and flat files.
Provide technical leadership, guidance, and mentoring to a team of ETL developers.
Establish development standards, coding best practices, and architectural guidelines for the ETL team.
Collaborate with business and technical stakeholders to validate data requirements and align solutions with reporting and analytics objectives.
Develop and execute testing strategies to ensure data accuracy, completeness, integrity, and consistency throughout migration efforts.
Optimize ETL workflows and data pipelines for performance, scalability, maintainability, and operational efficiency.
Validate transactional and analytical data models to support business intelligence, reporting, and downstream application requirements.
Create and maintain technical documentation, architecture diagrams, and data integration specifications.
Deliver presentations and communications to both technical and non-technical stakeholders.
Support troubleshooting, issue resolution, and continuous improvement initiatives across the data ecosystem.
Required Skills, Experiences, Education, and Competencies:
Minimum 7 years of hands-on ETL development experience.
Strong expertise in enterprise ETL architecture, data integration, and data migration solutions.
Extensive experience with modern ETL tools and Business Intelligence/reporting platforms.
Proven experience designing and implementing scalable data pipelines and cloud-native data processing solutions.
Strong understanding of enterprise data warehouse concepts, data modeling methodologies, and ETL best practices.
Experience leading technical teams and mentoring 4 or more developers in enterprise environments.
Hands-on experience with Google Cloud Dataform and BigQuery.
Strong knowledge of Medallion Architecture and modern data engineering design patterns.
Experience integrating data from multiple heterogeneous data sources, including databases, files, and cloud platforms.
Expertise in data validation, data quality management, reconciliation, and testing methodologies.
Strong analytical, troubleshooting, and problem-solving skills.
Experience optimizing ETL performance, scalability, and operational reliability.
Excellent communication, presentation, stakeholder management, and documentation skills.
Ability to effectively communicate technical concepts to both technical and business audiences.
Experience supporting enterprise analytics, reporting, business intelligence, and data modernization initiatives.
The hourly range for roles of this nature are $60.00 to $80.00/hr. Rates are heavily dependent on skills, experience, location, and industry.
cyberThink is an Equal Opportunity Employer.
...Phoenix3 Collective is seeking a highly organized, creative, and execution-focused B2B Marketing Manager to join our growing marketing team. This role will sit at the intersection of brand, marketing, and sales growth , helping translate strategy into high-quality...
...facility, which moved into a new hospital building in 2019, offers full diagnostic capabilities including MRI, CT, and EEG, and utilizes Cerner as its electronic health record system. A robust network of ancillary support services and specialist consultations are available,...
Location: Atlanta,San Francisco and Tampa At EY, were all in to shape your future with confidence. Well help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go. Join EY and help to build a better...
...Job Description Nova Routes, a veteran-owned and operated Amazon Delivery Service Provider, is hiring full-time drivers to... ...Pay: $24.75 per hour Benefits: ~401(k) matching ~ Company truck ~ Dental insurance ~ Flexible schedule ~ Fuel card ~ Health...
...Community Behavioral Health, LLC (CBH) is hiring Psychiatric Rehabilitation Program (PRP) Direct Care Workers to support adults with serious mental health needs in the community, home, and clinic settings. This is a hands-on, community-based role focused on helping...