Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

VISION ETL Lead

Info Way Solutions LLC

Job Description

Job Description

Role: TS4 VISION ETL Lead
Duration: 9 Months
Location: 200 E Grand Avenue | Des Moines, IA 50309
Work Arrangement: Remote
Interview: Either Web Cam or In Person Interview


*****Submit State client exp profiles only*****


Job Description:
The VISION – CWIS FACS Conversion Initiative requires the extraction of data from the Google Cloud Platform (GCP) BigQuery environment and the delivery of that data into enterprise SQL data warehouses.

Overview
The VISION – CWIS FACS Conversion Initiative requires the extraction of data from the Google Cloud Platform (GCP) BigQuery environment and the delivery of that data into enterprise SQL data warehouses. This effort is critical to ensuring continuity and modernization for all applications that currently depend on FACS.
A dedicated ETL development team is being formed from the existing resource pool, and we are seeking a highly skilled Lead ETL Developer to provide leadership, training, architecture guidance, and technical oversight throughout this conversion effort.
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.

Required Skills: Skill Required / Desired Amount of Experience • 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
Vacancy posted 21 days ago
Similar jobs that could be interesting for youBased on the VISION ETL Lead in Des Moines, IA vacancy
  • $94.71 per hour

     ...Description Job Description Title/Role: IA-DOM-DOIT-TS4 VISION Power BI Lead (812377) Req. Status: Open No. of Openings: 1 Start Date...  ...· Work closely with business partners, data engineers, and ETL developers to ensure accurate data sourcing from BigQuery data... 
    Suggested
    Remote work

    PeopleNTech LLC

    Des Moines, IA
    21 days ago
  • $32.5 per hour

     ...schedule Comprehensive benefits including medical, dental, and vision Enjoy team collaboration and role advancement About the...  ...About Renuity Renuity, headquartered in Charlotte, NC, is a leading home improvement services business with a rapidly expanding... 
    Suggested
    Hourly pay

    Renuity

    Des Moines, IA
    11 days ago
  • $170k - $230k

     ...HDR is searching for an Industrial Wastewater (IWW) Program Lead - Oil, Gas, and Chemicals Practice. Candidates should have a minimum...  ...health, performance, and success, which includes medical, dental, vision, short and long-term disability, life insurance, an employee... 
    Suggested
    Full time
    Temporary work
    Part time
    For contractors

    HDR

    Des Moines, IA
    1 day ago
  • $132.23k - $176.31k

     ...AI‑ready connectivity, join us today. The Role The Senior Lead Marketing Data Platform Architect is responsible for defining, governing...  ..., this individual will establish the long-term platform vision, define architectural standards, and guide modernization initiatives... 
    Suggested
    Full time
    Temporary work

    Lumen

    Des Moines, IA
    3 days ago
  •  ...operations. They supervise Transportation Security Officers and Lead Transportation Security Officers, coordinate staffing, address operational...  ...to applicable testing requirements Must meet TSA medical, vision, hearing, color-perception, and physical standards Must be... 
    Suggested
    Permanent employment
    Full time
    Temporary work
    Trial period
    Flexible hours
    Shift work
    Night shift
    Weekend work
    Day shift
    Afternoon shift
    Early shift

    Airport Security Careers

    Urbandale, IA
    14 days ago
  •  ...scale business growth.You Are:The Integration Lead Architect playing a pivotal role in...  ...APIs, asynchronous/event-based integrations, ETL/data transformation pipelines, and enterprise...  ...of benefits including medical, dental, vision, life, and long-term disability coverage,... 
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Des Moines, IA
    1 day ago
  •  ...recreation. Position Purpose The primary responsibility of a Lead Camp Counselor position at the Blank Park Zoo is to create a fun...  ...☐ Never ☒ Occasionally ☐ Constantly – Tasting or smelling. Vision Required Education and Experience Progress toward a degree... 
    Summer work
    Seasonal work
    Local area
    Flexible hours

    Blank Park Zoo

    Des Moines, IA
    4 days ago
  • $132.5k - $302.4k

     ...Accenture helps the world's leading enterprises reinvent by building their digital core and unleashing the power of AI to create value...  ...market competitive suite of benefits including medical, dental, vision, life, and long-term disability coverage, a 401(k) plan, bonus... 
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Des Moines, IA
    4 days ago
  • $118.4k

     ...JOB SUMMARY We are seeking a highly experienced and strategic Lead Enterprise Architect to drive technology strategy and innovation...  ..., and systems, directly contributing to our long-term strategic vision, ESSENTIAL RESPONSIBILITIES Lead to provide strategic... 
    For contractors
    Local area

    Highmark Health

    Des Moines, IA
    5 days ago
  •  ...Lead, Sales (Key Holder) Role We hope you're interested in building a home with us. Even if you don't feel that you meet every requirement...  ...and holidays (full-time) Health benefits, dental and vision insurance, including same-sex domestic partner benefits (full-time... 
    Full time
    Part time
    H1b
    Local area
    Relocation package
    Monday to Friday
    Flexible hours
    Shift work
    Weekend work

    Williams-Sonoma

    West Des Moines, IA
    3 days ago
  • $750 per month

     ...Formulary Lead, Formulary Operations Due to growth, we are adding a Formulary Lead, Formulary Operations to our team! The Formulary...  ...? ~ Top of the industry benefits for Health, Dental, and Vision insurance ~20 days paid time off ~4 weeks paid parental leave... 
    Flexible hours

    Disabledperson, Inc

    Des Moines, IA
    14 hours ago
  •  ...Visual Merchandising Lead The Visual Merchandising Lead (Visual Lead) position will partner with management and District Visual Manager...  ...and holidays (full-time) Health benefits, dental and vision insurance, including same-sex domestic partner benefits (full-time... 
    Full time
    Part time
    Seasonal work
    H1b
    Local area
    Relocation package
    Flexible hours
    Shift work
    Weekend work

    Rejuvenation

    Des Moines, IA
    5 days ago
  • $45.54k

     ...Fulfillment Lead Assists with daily activities of shipping department regarding materials movement or handling, receiving, loading...  ...incentive program. RRD offers benefits including medical, dental, and vision coverage, paid time off, disability insurance, 401(k) with match... 
    Contract work
    Local area
    Shift work

    RR Donnelley

    Des Moines, IA
    4 days ago
  •  ...Airport Ramp Ops Lead (UA) - DSM PT Unifi has decades of experience in the aviation services industry. We continue to innovate, adapt...  ...on our experience and expertise in airline ground services. Our vision is to be the most respected company by providing exceptional... 
    Hourly pay
    Weekly pay
    Full time
    Seasonal work
    Immediate start
    Night shift
    Rotating shift
    Weekend work

    Unifi

    Des Moines, IA
    2 days ago
  •  ...life. Here's an overview of what you can expect: Health and Wellness Personalized Health Insurance Plans including dental and vision coverage, available to you from Day 1. Wellness Programs designed to help you maintain a healthy lifestyle. Life Insurance... 
    Temporary work
    Local area
    Shift work
    Weekend work

    Trinity Health

    Des Moines, IA
    5 days ago
  •  ...Lead Transportation Security Officer Opportunities in Urbandale Lead Transportation Security Officers—or LTSOs—help keep airport screening...  ...to applicable testing requirements Must meet TSA medical, vision, hearing, color-perception, and physical standards Must be available... 
    Full time
    Flexible hours
    Shift work
    Night shift
    Weekend work
    Day shift
    Afternoon shift
    Early shift

    Airport Security Careers

    Urbandale, IA
    2 days ago
  • WHO YOU ARE: We are seeking an experienced and proactive Lead Person to oversee and enhance our sanitation processes, ensuring a spotless...  ...vary depending on location. What We Offer Medical, Dental, & Vision Insurance Basic Life Insurance Short-term Disability Long-... 
    Contract work
    Temporary work
    Local area
    Shift work

    Fortrex, Inc.

    Des Moines, IA
    3 days ago
  •  ...budgets. Candidates should have a high school diploma, valid driver's license, and at least two years of experience in technical draft or special events. Benefits include medical, dental, vision, 401k, paid vacation, and holidays. #J-18808-Ljbffr Columbia Distributing
    Full time

    Columbia Distributing

    Des Moines, IA
    14 hours ago
  • $74.6k - $93.3k

    Strategic Partnerships and Communications Lead Opportunity As the nation’s original travel insurance comparison site, InsureMyTrip, a...  ...learning culture with ongoing development opportunities Medical, vision, and dental coverage, Basic life and disability insurance 401(... 
    Work experience placement
    Work at office
    Local area
    Work from home

    InsureMyTrip

    Des Moines, IA
    1 day ago
  •  ...offers a robust suite of benefits for regular, full-time, non-union employees including: health insurance options for Medical, Dental & Vision plans, Short- and Long-Term Disability plans, Flexible Spending Accounts, Health Savings Accounts, Life Insurance Options, Paid... 
    Daily paid
    Full time
    Temporary work
    Work at office
    Local area
    Flexible hours
    Afternoon shift

    Agiliti Health, Inc.

    Urbandale, IA
    2 days ago
  •  ...will monitor output, adjust stations, and direct crew to maintain efficiency. We offer competitive pay, comprehensive benefits including medical, dental, vision, 401(k) with match, and opportunities for growth within a global print and packaging leader. #J-18808-Ljbffr... 

    R.R. Donnelley

    Des Moines, IA
    4 days ago
  •  ...Team Lead Responsible for assisting in the oversight of gym operations to ensure positive member experience. Essential duties and...  ...member or friend Team Member Support Team Health, Dental and Vision Insurance Critical Illness Insurance Short Term Disability... 
    Temporary work
    Shift work

    Planet Fitness

    Des Moines, IA
    3 days ago
  • $80k - $140k

     ...M&A Integration Lead We are seeking a dynamic and collaborative M&A Integration Lead to lead the end-to-end integration of acquired...  ...security. This includes comprehensive medical, dental, and vision options alongside company-paid disability and life insurance. We... 
    Work at office
    Remote work

    Vision Financial Group, Llc - Iowa

    Des Moines, IA
    4 days ago
  • $19 - $21 per hour

     ...product development.Functions as part of the team with Production Leads/Supervisors to verify first articles are approved prior to the...  ...The employee is frequently required to talk and hear. Specific vision abilities required by this job include close vision, distance vision... 
    Weekly pay
    Temporary work
    Flexible hours
    Shift work
    3 days per week

    KATECHO

    Des Moines, IA
    3 days ago
  • $21 per hour

    Quality LeadThe Quality Lead ensures that all products are manufactured in accordance with current Good Manufacturing Practices (GMP)...  ...The employee is frequently required to talk and hear. Specific vision abilities required by this job include close vision, distance vision... 
    Hourly pay
    Shift work
    Weekend work

    KATECHO

    Des Moines, IA
    3 days ago
  •  ...Team Lead Responsible for assisting in the oversight of gym operations to ensure positive member experience. Essential duties and...  ...member or friend Team Member Support Team Health, Dental and Vision Insurance Critical Illness Insurance Short Term Disability... 
    Temporary work
    Local area
    Shift work

    Planet Fitness

    Urbandale, IA
    1 day ago
  •  ...understands, incorporates, and demonstrates the Trinity Health Mission, Vision, and Values in behaviors, practices, and decisions.Deliver...  ...to patient inquiries.Actively participates in meetings, leads to huddles, ensuring adherence to safety, infection control, and... 
    Local area

    Saint Alphonsus Health System

    West Des Moines, IA
    4 days ago
  •  ...life outside of the clinic. Reason for Opening: Current Medical Lead is Internally Transferring to our other local clinic on great...  ...Total Wellbeing Comprehensive coverage including Health, Dental, Vision, and more, plus Maternity Leave and 24/7 TeleDoc access.... 
    Temporary work
    Local area

    Mission Pet Health

    Des Moines, IA
    3 days ago
  •  ...Lead Cook Position Are you a Lead Cook looking to work for an amazing organization by serving others and connecting with your co-...  ...Benefits can be found at Immanuel: HEALTH: Medical, dental, vision, Health Savings Account (HSA), and Flexible Spending Account (FSA... 
    Full time
    Flexible hours

    Immanuel

    Urbandale, IA
    14 hours ago
  • $51.09 - $59.09 per hour

     ...Genesis10 is currently seeking a Lead Business Execution Consultant - Hybrid position with a Global Financial Institution located in...  ...experience on average.) ~ Behavioral Health Platform ~ Medical Dental Vision ~ Health Savings Account ~ Voluntary Hospital Indemnity (... 
    Hourly pay
    Permanent employment
    Contract work
    Temporary work
    For contractors

    Genesis10

    West Des Moines, IA
    a month ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to VISION ETL Lead. Be the first to apply!