Data Warehouse Developer- IIIClient looking for a Data Warehouse Developer- III. We have an immediate opening at the Department of Employee Trust Funds (ETF) for a Data Engineer to participate in data integration and data warehousing for a new Invoicing system. This is part of a larger effort to modernize our core business systems.
Prior experience with invoicing, billing, or payment systems is preferred. The duration of this position is expected to be 15 months. 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 yearsUsing 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 yearsImplementing change data capture (CDC) – 4 yearsTesting and debugging ETL – 6 yearsDeveloping complex SQL - 6 yearsETL job scheduling – 2 yearsLoading data warehouses using ETL tools – 2 yearsData integration for invoicing, billing, or payment systems – 2 years preferred.Management of multiple ETL toolsExperience with data quality tools and frameworksUsing source code version control softwareMentoring to others on ETL developmentManaging multiple, concurrent projects and tasksHaving strong interpersonal skills including communication, mentoring, collaborating, and team buildingTop Skills & Years of Experience:Developing complex SQL - 6 yearsGathering requirements and developing technical specifications for ETL – 6 yearsUsing 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 yearsImplementing change data capture (CDC) – 4 yearsTesting and debugging ETL – 6 yearsETL job scheduling – 2 yearsLoading data warehouses using ETL tools – 2 years (preferably with SQL Server)Nice to Have:Data integration for invoicing, billing, or payment systems HIGHLY PREFERRED – 2 yearsManagement of multiple ETL toolsExperience with data quality tools and frameworks - preferredUsing source code version control software - preferredInterview Process:• 1-2 rounds via Microsoft Teams.Duration:• 06/30/2024, likely to extend. Onsite or Remote: • WI residency is NOT required. This position can work 100% remote or in the office.Access to FTI (Federal Tax Information):• YesSecurity Required:• Yes