Description:
The Client is looking for 3 (three) Data Warehouse Developer IIIs.
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
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: 12 rounds via Microsoft Teams.
Duration: 6/30/2024 likely to extend.
Onsite or Remote Candidates MUST be CURRENT WI residents. No relocation is allowed. This position can work 100% remote (within
the state of WI) 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 dataliterate and datadriven 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.