Data Warehouse Developer - Madison, United States - Glow Networks
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)
- Testing and debugging ETL
- 6 years
- ETL job scheduling
- Loading data warehouses using ETL tools
Nice to Have:
- Management of multiple ETL tools
- Experience with data quality tools and frameworks preferred.
- Using source code version control software
Interview Process:
- 12 rounds via Microsoft Teams.
Job Type:
Contract
Pay:
$ $52.00 per hour
Experience:
- Alteryx
- CDC: 2 years (required)
- SQL: 2 years (required)
Work Location:
Remote
More jobs from Glow Networks
-
Deploy Services Design Build Manager
Dallas, United States - 14 hours ago
-
Security Analyst
Naperville, United States - 2 weeks ago
-
Access Transport Tech On W2
San Diego, United States - 3 weeks ago
-
Business Analyst/consultant-iii Only W2 Hybrid
Madison, United States - 1 week ago
-
Jr. Structural Engineer
Fenton, United States - 1 month ago
-
Financial Planning and Analysis Lead
Boise, United States - 1 day ago