Data Warehouse Analyst

Codeworks is an IT Services firm headquartered in SE Wisconsin, known for our strong commitment to quality and for our direct client relationships. Who We’re Looking For: The Wisconsin DPI is hiring two Business Analysts to support its Data Warehouse and Decision Support (DWDS) team within the Bureau of Information Technology Services. The team manages the statewide longitudinal data system (SLDS) and platforms like WISEdash and Power BI, delivering education data to internal and public stakeholders. These contract roles focus on gathering requirements, defining scope, testing, and supporting the modernization of data reporting systems including the WISEdash Public Portal. Responsibilities Collaborate on an Agile/Scrum team to define, plan, and deliver project features. Translate reporting and software feature requests into user stories with clear acceptance criteria. Act as liaison between business units, technical teams, and external stakeholders. Estimate project phases, contribute to release planning, and document business processes. Create and execute test plans, including application and regression testing. Conduct data analysis and write SQL queries against relational databases. Support continuous improvement of data warehouse and reporting solutions. Qualifications Required (3–5 years of experience): Experience with data warehousing or dashboarding projects. Skilled in SQL and working with relational databases (SQL Server preferred). Proficiency in writing user stories, defining acceptance criteria, and estimating project phases. Strong skills in test planning, execution, and regression testing. Strong organizational, analytical, and communication skills. Preferred: Experience creating solution options or recommendations based on business requirements. Familiarity with education sector reporting (K–12 or P20W environments). Experience with platforms such as Power BI or Microsoft Fabric. Strong meeting facilitation and stakeholder engagement skills. Additional Information Remote work with 1–2 in-person meetings/year in Madison, WI. Candidates must reside in Wisconsin (or relocate at their own expense before the start date). Agile/Scrum methodology focused on collaboration and transparency. About Codeworks: Codeworks has over 25 years of experience serving Fortune 1000 companies in Wisconsin as well as our client's national locations. Our recruiting team excels at evaluating, advising, and connecting IT professionals with new opportunities that will satisfy their expectations regarding income and opportunity for growth. At Codeworks, we're committed to diversity, equity, and inclusion in our workforce and beyond. We believe in equal opportunities and value the unique perspectives that every individual brings to our team. Join us in creating an inclusive, innovative, and collaborative workplace where your talents can thrive. Codeworks is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. Codeworks, LLC discloses that the anticipated hourly pay range for this position is between $30 and $42. This range is subject to change based on job-related factors, including client requirements where applicable. All full time Codeworks employees are eligible to enroll in the company’s medical, dental, vision, and life insurance plans. Additionally, employees can participate in Codeworks’ 401(k) retirement plan.