W2 - Data Warehouse Developer III (Alteryx, SQL, CDC, ETL, Data load, Job scheduling, Test) - Remote

4 weeks ago


Madison, United States Tanson Corp Full time
Job DescriptionJob DescriptionDescription:This is a REPOST. Please do not submit the same candidates. This repost is open to nationwide candidates and does not require relocation to WI. Candidates MUST have Alteryx experience related to ETL, not just Alteryx experience based in data prep. The manager is also looking for candidates with strong and recent SQL skills. Candidates will be required to complete an SQL exercise when they interview with ETF and will need to answer very detailed questions regarding their background with Alteryx.
The client is looking for a Data Warehouse Developer III.Will close to submissions on 5/15/2024 at 4:00PM CST.
Top Skills & Years of Experience:
a. Gathering requirements and developing technical specifications for ETL 6 years
b. Using ETL tools to design ETL jobs (ETL 6 years, MINIMUM 2 years of ETL with Alteryx)
c. Developing various types of data loads (e.g. incremental, history/full, survivorship rules) 6 years
d. Implementing change data capture (CDC) 4 years
e. Testing and debugging ETL 6 years
f. Developing complex SQL - 6 years (should be recent experience)
g. ETL job scheduling 2 years
h. Loading data warehouses using ETL tools 2 years
Nice to Have:
a. Management of multiple ETL tools
b. Experience with data quality tools and frameworks - preferred
c. Using source code version control software - preferred
Interview Process: 1-2 rounds via Microsoft Teams.
Duration: 6/30/2024, likely to extend.
Onsite or Remote? No WI residency required. Open to nationwide candidates. This position can work 100% remote or in the office.
We have an immediate opening at the Department of Employee Trust Funds (ETF) for a strong Data Engineer to participate in our Data Management Program. Data is one of our most valuable assets and we strive to become a more data-literate and data-driven organization. This position will work on a small, collaborative team that uses agile practices to deliver value to our business partners.
Desired Experience
  • Gathering requirements and developing technical specifications for ETL - 6 years
  • Using ETL tools to design ETL jobs (ETL 6 years, preferably 2 years of with Alteryx)
  • Developing various types of data loads (e.g. incremental, history/full, survivorship rules) - 6 years Implementing change data capture (CDC) -4 years
  • Testing and debugging ETL - 6 years
  • Developing complex SQL - 6 years
  • ETL job scheduling - 2 years
  • Loading data warehouses using ETL tools - 2 years
  • Management of multiple ETL tools
  • Experience with data quality tools and frameworks
  • Using source code version control software
  • Mentoring to others on ETL development
  • Managing multiple, concurrent projects and tasks
  • Having strong interpersonal skills including communication, mentoring, collaborating, and team building
ET F Technologies
  • Alteryx
  • SSIS
  • SSRS
  • SQL Server
  • Tableau
  • Semarchy
  • Git & github
Pay range: $48 to $54 per hour on W2.

  • Madison, United States Tanson Corp Full time

    Job DescriptionJob DescriptionDescription:This is a REPOST. Please do not submit the same candidates. This repost is open to nationwide candidates and does not require relocation to WI. Candidates MUST have Alteryx experience related to ETL, not just Alteryx experience based in data prep. The manager is also looking for candidates with strong and recent SQL...


  • Madison, United States Tanson Corp Full time

    Job DescriptionJob DescriptionDescription:This is a REPOST. Please do not submit the same candidates. This repost is open to nationwide candidates and does not require relocation to WI. Candidates MUST have Alteryx experience related to ETL, not just Alteryx experience based in data prep. The manager is also looking for candidates with strong and recent SQL...


  • Madison, United States Certec Consulting Full time

    Data Warehouse Developer-III - 1762 **RFP REPONSE DUE 06/01** **RATE is POSTED ON WEBSITE** **W2/1099 only No C2C** **Submission Procedure DO NOT EMAIL**: **Skills Matrix** (link) **Step 2 PLEASE **DO NOT **SUBMIT VIA **LINKEDIN, INDEED OR DICE USE **THE EASY APPLY BUTTON AT**: Any other submission format may not be reviewed Desired Experience: -...


  • Madison, United States Glow Networks Full time

    We have an immediate opening at the Department of Employee Trust Funds (ETF) for a strong Data Engineer to participate in our Data Management Program. Data is one of our most valuable assets and we strive to become a more data-literate and data-driven organization. This position will work on a small, collaborative team that uses agile practices to deliver...

  • Data Management

    7 days ago


    Madison, United States Apptad Inc Full time

    Job DescriptionJob DescriptionJob Title: Data Management - Data Warehouse Developer IIILocation: Madison, WI (Remote)Primary Skills: Tableau,GIT,SSRS,SSIS,ETLJob Description:We have an immediate opening for a strong Data Engineer to participate in our Data Management Program. Data is one of our most valuable assets and we strive to become a more...

  • Data Management

    1 day ago


    Madison, United States Apptad Inc Full time

    Job DescriptionJob DescriptionJob Title: Data Management - Data Warehouse Developer IIILocation: Madison, WI (Remote)Primary Skills: Tableau,GIT,SSRS,SSIS,ETLJob Description:We have an immediate opening for a strong Data Engineer to participate in our Data Management Program. Data is one of our most valuable assets and we strive to become a more...


  • Madison, United States Novalink Solutions LLC Full time

    Job DescriptionJob DescriptionWe have an immediate opening at the Department of Employee Trust Funds (ETF) for a strong Data Engineer to participate in our Data Management Program. Data is one of our most valuable assets and we strive to become a moredata-literate and data-driven organization. This position will work on a small, collaborative team that uses...


  • Madison, United States Novalink Solutions LLC Full time

    Job DescriptionJob DescriptionWe have an immediate opening at the Department of Employee Trust Funds (ETF) for a strong Data Engineer to participate in our Data Management Program. Data is one of our most valuable assets and we strive to become a moredata-literate and data-driven organization. This position will work on a small, collaborative team that uses...

  • Data Management

    1 month ago


    Madison, United States Zenith Services Full time

    We have an immediate opening at the Department of Employee Trust Funds (ETF) for a strong Data Engineer to participate in our Data Management Program. Data is one of our most valuable assets and we strive to become a more data-literate and data-driven organization. This position will work on a small, collaborative team that uses agile practices to deliver...


  • Madison, United States Focused HR Solutions Remote Work Freelance Full time

    100% remote. Our direct client has an opening for an   Data Warehouse Developer 129720.This position is for up to 13 months with the option of extension, and the client is in Madison, WI.    Alteryx experience related to ETL, as many had experience based more on data prep. The manager is also looking for candidates with strong and recent SQL skills....


  • Madison, United States Focused HR Solutions Full time

    100% remote. Our direct client has an opening for an   Data Warehouse Developer 129720.This position is for up to 13 months with the option of extension, and the client is in Madison, WI.    Alteryx experience related to ETL, as many had experience based more on data prep. The manager is also looking for candidates with strong and recent SQL skills....


  • Madison, United States Focused HR Solutions Full time

    100% remote. Our direct client has an opening for an   Data Warehouse Developer 129720.This position is for up to 13 months with the option of extension, and the client is in Madison, WI.    Alteryx experience related to ETL, as many had experience based more on data prep. The manager is also looking for candidates with strong and recent SQL skills....


  • Madison, United States Focused HR Solutions Remote Work Freelance Full time

    100% remote. Our direct client has an opening for an   Data Warehouse Developer 129720.This position is for up to 13 months with the option of extension, and the client is in Madison, WI.    Alteryx experience related to ETL, as many had experience based more on data prep. The manager is also looking for candidates with strong and recent SQL skills....


  • Madison, United States Focused HR Solutions Full time

    100% remote. Our direct client has an opening for an   Data Warehouse Developer 129720.This position is for up to 13 months with the option of extension, and the client is in Madison, WI.    Alteryx experience related to ETL, as many had experience based more on data prep. The manager is also looking for candidates with strong and recent SQL skills....


  • Madison, United States Focused HR Solutions Remote Work Freelance Full time

    100% remote. Our direct client has an opening for an   Data Warehouse Developer 129720.This position is for up to 13 months with the option of extension, and the client is in Madison, WI.    Alteryx experience related to ETL, as many had experience based more on data prep. The manager is also looking for candidates with strong and recent SQL skills....


  • Madison, United States Beacon Hill Full time

    100% REMOTE, long-term contractCandidates MUST have Alteryx experience related to ETL, not just Alteryx experience based in data prep. The manager is also looking for candidates with strong and recent SQL skills. Candidates will be required to complete an SQL exercise when they interview with ETF and will need to answer very detailed questions regarding...

  • data management

    6 days ago


    Madison, United States Randstad Full time

    data management - data warehouse developer iii. madison , wisconsin posted 3 days ago job details summary $51.66 - $56.66 per hour contract bachelor degree category computer and mathematical occupations reference1053570 job details job summary: We have an immediate opening at the Department of Employee Trust Funds (ETF) for a good Data...

  • data management

    3 days ago


    Madison, United States Randstad Full time

    data management - data warehouse developer iii. madison , wisconsin posted 5 days ago job details summary $51.66 - $56.66 per hour contract bachelor degree category computer and mathematical occupations reference1053570 job details job summary: We have an immediate opening at the Department of Employee Trust Funds (ETF) for a good Data...

  • data management

    1 day ago


    Madison, United States Randstad Full time

    data management - data warehouse developer iii. madison , wisconsin posted 7 days ago job details summary $51.66 - $56.66 per hour contract bachelor degree category computer and mathematical occupations reference1053570 job details job summary: We have an immediate opening at the Department of Employee Trust Funds (ETF) for a good Data...

  • Data Management

    2 weeks ago


    Madison, Wisconsin, United States Randstad USA Full time

    job summary: We have an immediate opening at the Department of Employee Trust Funds (ETF) for a good Data Engineer to participate in our Data Management Program. Data is one of our most valuable assets and we strive to become a more data-literate and data-driven organization. This position will work on a small, collaborative team that uses agile practices to...