W2 - Data Warehouse Developer III (Alteryx, SQL, CDC, ETL, Data loads, Job scheduling, Testing) - Re

2 weeks ago


Madison, United States Tanson Corp Full time
Job DescriptionJob DescriptionDescription:This is a REPOST. Please do not submit the same candidates. Prior candidates were lacking 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. This repost is open to nationwide candidates and does not require relocation to WI.
The client is looking for 1 Data Warehouse Developer IIIs.Will close to submissions on 5/1/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, preferably 2 years of 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.Job Description
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 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 week ago


    Madison, United States Vision It US Full time

    Job DescriptionJob DescriptionCandidates MUST be WI residents or willing to relocate to WI at their own expense prior to starting. This position can work 100% remotely (within the state of WI). Job Description: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....

  • ETL Developer

    2 weeks ago


    Madison, United States Technoviz Full time

    JOB REQUIREMENTS: Designing and creating the data warehouse and all related extraction, transformation and loading data functions. Designing and creating complex universes, Webi reports and Xcelsius Dashboards. Document all technical and system specifications documents for all ETL processes and perform unit tests on all processes and prepare required...


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

    Our direct client has an opening for a Data Warehouse Developer rec 89341    This position is for 8 months with the option of extension and is located in Madison WI  WE CAN WORK CORP TO CORP OR W2. If you are interested, please submit the following:YOUR CURRENT RESUME YOUR HOURLY RATE   Qualifications:7-Year Standard Background Check run internally by...


  • Madison, United States Tanson Corp Full time

    Job DescriptionJob DescriptionDescription:This is a REPOST due to location requirement change. Candidates MUST have strong SQL skills, with minimum 3 years' experience. The client is looking for a Quality Assurance Analyst IV.Will close to submissions on 5/24/24 at 4:00PM CST.Top Skills & Years of Experience: a. Experience in quality inspection,...


  • Madison, United States Tanson Corp Full time

    Job DescriptionJob DescriptionDescription:This is a REPOST. The title has been changed from a Systems Architect II to a Business Analyst/Consultant IV. The manager is looking for a Business Systems Analyst with reporting and data warehouse requirements development experience and source to target mapping. This individual MUST also be able to write SQL. The...

  • Data Management

    4 hours ago


    Madison, United States Goli Tech Full time

    Job DescriptionJob DescriptionCandidates MUST be WI residents or willing to relocate to WI at their own expense prior to starting. This position can work 100% remotely (within the state of WI). Job Description:ETF has an immediate need for a quality assurance analyst for both functional and non-functional testing of data management solutions including a data...

  • Senior SQL Developer

    2 weeks ago


    Madison, United States Wisconsin Foundation and Alumni Association Full time

    Overview The Wisconsin Foundation and Alumni Association (WFAA)*, the private fundraising and alumni relations organization for UW-Madison, is recruiting for a SQL Developer / Database Administrator (DBA). In this role, you will be responsible for database and data warehouse development, query development, management reporting and database maintenance and...

  • Data Management

    3 days ago


    Madison, United States Goli Tech Full time

    Job DescriptionJob DescriptionCandidates MUST be WI residents or willing to relocate to WI at their own expense prior to starting. This position can work 100% remotely (within the state of WI). Job Description We have an immediate opening at the Department of Employee Trust Funds (ETF) for a Business/Systems Analyst to participate in our Data Management...


  • Madison, United States CyberTec Full time

    Job Title: Mid-level Data Engineer Visa: USC,GC Location - 100% remote position - company located in Madison,WI Preferably East or West coast . Client: Exact Science. Estimated Duration: 6 month with potential to go long term or permanent Rate Range - $60-65/hr. /c2c Years of Experience: 6+ YEARS Interview: Phone and Teams Skill Matrix: Tech Year of...


  • Madison, United States Glow Networks Full time

    J**Desired Experience**: - Serving as a liaison between the business and technical staff to design and implement efficient data integration processes. Creating and maintaining source to target (S2T) documentation - 5 years. - Developing complex SQL - 5 years - Gathering requirements and developing user stories - 5 years - Translating business requirements...

  • Data Management

    10 hours ago


    Madison, United States Zenith Services Full time

    **Responsibilities**: - Draft quality assurance policies and procedures. - Design, develop, and execute testing plans - Perform analysis for adherence to agency policies - Implement and monitor test scripts to assess functionality, reliability, performance, and quality of the service or product. - Make recommendations and implement processes to utilize...


  • Madison, United States Apptrics LLC Full time

    **Job title **:Business Systems Analyst - 130478 **Location**: Madison Wisconsin **Duration**:12+ Months **Top Required Skills & Years of Experience**: - Serve as a liaison between the business and technical staff to design and implement efficient data integration processes. Creating and maintaining source to target (S2T) documentation - 5 years -...

  • Data Scientist

    2 weeks ago


    Madison, United States Rentable Full time

    Job DescriptionJob DescriptionWe're Changing the Rentals IndustryWe're a profitable, growth-stage company building industry-leading martech and data SaaS products for the rentals industry. While originally known for building and operating one of the U.S.'s largest rental marketplaces - Rentable, we recently launched a martech product and a...


  • Madison, United States Madison Metropolitan School District Full time

    **Doyle - Dashboard & Report Developer - 1.0 FTE (40 hpw)** **Technical Services** **Doyle Administration Building** $39.02 - 39.02 Hourly Wage **Position Summary**: **Responsibilities**: - Coordinate with the Data Warehouse/Dashboard Supervisor to migrate dashboard and warehouse tools from legacy systems (e.g. Data Dashboard 1.0, self-hosted Unified...

  • Data Scientist

    2 days ago


    Madison, United States Rentable Full time

    Job DescriptionJob DescriptionWe're Changing the Rentals IndustryWe're a profitable, growth-stage company building industry-leading martech and data SaaS products for the rentals industry. While originally known for building and operating one of the U.S.'s largest rental marketplaces - Rentable, we recently launched a martech product and a...

  • IT Project Manager

    3 days ago


    Madison, United States SunPlus Data Group Inc Full time

    Job Description Job Description SunPlus Data Group is looking for a Project Manager for the State of WI Department of Administration. This is for 6 months with possible extension Hours are generally M-F, 40 hrs/week Pay is $53 W2 hourly & $60 hr 1099 Job #128547 **Position is Hybrid - ON SITE 1 day/week. Current WI Residents ONLY (NO RELOCATION) It usually...

  • Data Engineer

    3 days ago


    Madison, United States Wisconsin Collaborative for Healthcare Quality Full time

    The Opportunity Are you passionate about leveraging data to drive innovation and create impactful solutions? M3 is seeking a skilled Applied Intelligence Data Engineer to play a pivotal role in our journey towards data excellence. As an Applied Intelligence Data Engineer, you will be at the forefront of developing, optimizing, and maintaining our data...

  • IT Project Manager

    3 weeks ago


    Madison, United States SunPlus Data Group, Inc Full time

    Job DescriptionJob DescriptionSunPlus Data Group is looking for a Project Manager for the State of WI Department of Administration.This is for 6 months with possible extensionHours are generally M-F, 40 hrs/weekPay is $53 W2 hourly & $60 hr 1099Job #128547**Position is Hybrid - ON SITE 1 day/week.  Current WI Residents ONLY (NO RELOCATION)It usually takes...