Overview
Remote
On Site
Compensation information provided in the description
Contract - W2
Contract - 21 day((s))
Skills
Sql Server
test plans
user stories
Data Warehouse Analyst III (Dashboard
Job Details
Description:
The client is looking for TWO (2) Data Warehouse Analyst III's
Will close to submissions on _10/21/25__at 4:00PM CST.
Top Required Skills & Years of Experience: 3-5 years of experience in the below
- Prior experience in data warehousing or dashboarding projects (3-5 years)
-Ability to create test plans and perform application, reporting and system regression tests
-Ability to estimate phases of work and contribute to project planning, including experience writing user stories with clearly defined acceptance criteria.
-Experience using relational databases (writing queries, etc.) using SQL Server
Nice to Have Skills:
-Ability to synthesize requirements and work with developers to create options/recommendation papers for decisions to be made by any stakeholder level.
-Strong written and verbal communication skills, including meeting facilitation skills.
-Knowledge of data warehousing and reporting in the education sector (K-12/P20W).
Interview Process:
Teams
Teams
Duration of the Contract:
6/30/26 with the possibility of extension
6/30/26 with the possibility of extension
Onsite or Remote?
Candidate MUST be a WI resident or willing to relocate to WI prior to starting the role at their own expense
Position is nearly 100% remote, with 1-2 in person meetings in Madison, WI per year.
Candidate MUST be a WI resident or willing to relocate to WI prior to starting the role at their own expense
Position is nearly 100% remote, with 1-2 in person meetings in Madison, WI per year.
Project details:
The client is seeking two Business Analysts who will serve as a member of the Data Warehouse
and Decision Support (DWDS) section in the Bureau of Information Technology Services (BITS) in the Division of Management Services. The DWDS team is responsible for the statewide longitudinal data warehouse (SLDS), development, system testing, analysis, and maintenance and integration of data in the SLDS, WISEdash and other reporting systems (Microsoft Fabric/Power BI). These systems
require extensive K-12 sector knowledge and experience integrating complex data and developing dashboards and reports to convey that information to DPI staff, school districts and the general public. The candidates will be working to gather requirements, assure quality and generally build out the agency's modernized WISEdash Public portal.
This person will be a member of a team practicing the Agile/Scrum development methodology.
The client is seeking two Business Analysts who will serve as a member of the Data Warehouse
and Decision Support (DWDS) section in the Bureau of Information Technology Services (BITS) in the Division of Management Services. The DWDS team is responsible for the statewide longitudinal data warehouse (SLDS), development, system testing, analysis, and maintenance and integration of data in the SLDS, WISEdash and other reporting systems (Microsoft Fabric/Power BI). These systems
require extensive K-12 sector knowledge and experience integrating complex data and developing dashboards and reports to convey that information to DPI staff, school districts and the general public. The candidates will be working to gather requirements, assure quality and generally build out the agency's modernized WISEdash Public portal.
This person will be a member of a team practicing the Agile/Scrum development methodology.
This person will work on the transition of reporting and software features into technical requirements, such as epics, features, and stories following Agile/Scrum-based software development, as well as determine release plans and project scope. This position will work with and serve as a liaison between management and business units within DPI, external stakeholders, product owners, developers, and the scrum master and product owner to identify and analyze opportunities for improving reporting processes and business systems.
This position will be responsible for conducting research, analyzing and documenting system requirements and business rules, and creating user stories. This position will also be responsible for creating functional requirements and specifications, preparing process flow diagrams, and assisting with quality assurance.
Under general supervision of the DWDS section manager, this person will work closely with others to
accomplish project objectives, or function independently to accomplish daily work requirements as a member of the DWDS team. Objectives, priorities and deadlines are established in consultation with the department program area leaders, project managers, and DWDS and IT managers.
accomplish project objectives, or function independently to accomplish daily work requirements as a member of the DWDS team. Objectives, priorities and deadlines are established in consultation with the department program area leaders, project managers, and DWDS and IT managers.
Required Skills:
- Prior experience in data warehousing or reporting projects (3-5 years)
- Strong written and verbal communication skills, including meeting facilitation skills.
- Ability to work in a team environment as well as independently
- Possess a fundamental understanding of end-to-end customer dashboard use integration and dependencies
- Experience preparing business requirements and functional specifications
- Experience writing user stories with clearly defined acceptance criteria
- Ability to estimate phases of work and contribute to project planning.
- Ability to create test plans and perform application, reporting and system regression tests
- Ability to synthesize requirements and work with developers to create options/recommendation papers for decisions to be made by any stakeholder level.
Required Technical Skills:
- Ability to work with both business/program area owners and translate their needs to developers.
- Experience using Azure DevOps or similar tools to manage user stories and sprint backlogs.
- Experience using relational databases (writing queries, etc.) using SQL Server
- Knowledge of Microsoft Fabric and Power Bl reporting solutions.
Preferred Experience:
- Minimum 2-5 years' experience using Agile/Scrum Development Methodology
- Experience working with education software or reporting systems at the school, district, or state levels.
- Knowledge of data warehousing and reporting in the education sector (K-12/P20W).
- Experience using Asana to track and report on project milestones.
Pay rate: $35/hr on W2.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.