Data Warehouse Developer
The State of Wisconsin is looking for 3 (three) Data Warehouse Developer IIIs. MUST be CURRENT Wisconsin residents. No relocation is allowed. 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 ETLUsing 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 SQLETL job scheduling
- Loading data warehouses using ETL tools
Management of multiple ETL toolsExperience 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 buildingETF Technologies:
AlteryxSSISSSRSSQL Server
TableauSemarchyGit & GitHubTop 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 yearsETL job scheduling - 2 years
Loading data warehouses using ETL tools - 2 years
Nice to Have:
Management of multiple ETL toolsExperience with data quality tools and frameworks - preferred. Using source code version control software - preferred
Interview Process: 1-2 rounds via Microsoft Teams.
Duration:
06/30/2024, likely to extend. Onsite or Remote? This position can work 100% remote (within the state of WI) or in the office. Candidates MUST be CURRENT WI residents. No relocation is allowed.