Data Warehouse Developer - Madison, United States - Glow Networks

Glow Networks
Glow Networks
Verified Company
Madison, United States

3 weeks ago

Mark Lane

Posted by:

Mark Lane

beBee recruiter
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
  • 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)
  • Implementing change data capture (CDC)
  • Testing and debugging ETL.
  • Developing complex SQL
  • ETL job scheduling
  • Loading data warehouses using ETL tools
  • 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

ETF Technologies:


  • Alteryx
  • SSIS
  • SSRS
  • SQL Server
  • Tableau
  • Semarchy
  • Git; GitHub

Top Skills &; Years of 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
    • (should be recent experience)

    • ETL job scheduling
    - 2 years

    • Loading data warehouses using ETL tools
    - 2 years


    Nice to Have:


    • Management of multiple ETL tools
    • Experience with data quality tools and frameworks preferred.
    • Using source code version control software
    - preferred


    Interview Process:


    • 12 rounds via Microsoft Teams.

    Job Type:
    Contract


    Pay:
    $ $52.00 per hour


    Experience:


    • Alteryx
    : 2 years (required)

    • CDC: 2 years (required)
    • SQL: 2 years (required)

    Work Location:
    Remote
    More jobs from Glow Networks
    See all jobs of Glow Networks