Hiring for ETL Lead - 100% REMOTE ON W2 Job at Career Soft Solution, Iowa

  • Career Soft Solution
  • Iowa

Job Description

This is Mudassir from Career Soft Solutions. I have an exciting opportunity for you with my client.

IA-DOM-DOIT-TS4 VISION ETL Lead

100% REMOTE

Contract on W2

State Date 09/28/2026

End Date 06/30/2027

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.

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.

Skill

Required / Desired

Hands-on ETL development experience

Required

7

Years

Expertise with modern ETL and reporting/BI tools

Required

7

Years

Strong understanding of enterprise data models and best practices in ETL pipeline design.

Required

7

Years

Proven experience as a Technical Lead guiding teams of 4 or more developers

Required

7

Years

Demonstrated experience with Google Cloud Dataform

Required

7

Years

Demonstrated experience with BigQuery

Required

7

Years

Demonstrated experience with Medallion Architecture

Required

7

Years

Exceptional communication and presentation skills, capable of engaging diverse audiences

Required

Thankyou

Mudassir Md

Sr Lead Recruitment Specialist

Ph: 9082631772

Mudassir.md@careersoftusa.com

3608 Preston Road, Suite 110 , Plano, TX 75093

CONFIDENTIALITY & COMMUNICATION DISCLAIMER: This email and any attachments may contain confidential or proprietary information intended solely for the recipient. If you received this email in error, please notify the sender and delete it immediately.

If you do not wish to receive future commercial communications from us, please reply Unsubscribe.

Job Tags

Contract work, Immediate start, Remote work

Similar Jobs

State Controller's Office

Trainer Job at State Controller's Office

 ...administration, benefits administration, time management, and travel and expense management) and Payroll with employee self-service...  ...direction provided by the Training Manager (Supervisor I), the Trainer will assist in the planning, design, development, delivery and... 

Spradious

Data Engineer Job at Spradious

 ...pipeline projects for our US-based clients. This is an ongoing, full-time engagement not a one-off project.**Location: Pakistan (Remote)****What you'll work on:*** Designing, building, and maintaining production ETL/ELT pipelines* Integrating data across... 

Elite Windows

Competitive Entry Level Sales Role - No Experience Needed $6,000-$11,000 Monthly OTE Job at Elite Windows

 ...Intro to Elite Since entering the window industry, we've spent years learning what works and what doesn't through real-world experience. In 2025, we more than doubled our revenue from the previous year, generating over $10 million in total sales . We've built proven... 

Artisan Crew

Viral marketer / Viral Content Creator: 1099 Job at Artisan Crew

 ...them to Youtube and gotten no views and left it at that or a person who will studiously submit spammy links of stuff we've done to Reddit, we mean a full package real deal amazingly creative but needs work / clients for whom to do that work person. We need a person who... 

Caring Professionals

Nurse Manager Job at Caring Professionals

 ...Job Description Alcester Care & Rehab: Director of Nursing Alcester Care & Rehab is seeking a caring and compassionate person for the Nurse Manager position. This individual directs the licensed and non-licensed staff who provide health care and nursing services to...