Data Warehouse Analyst

IO Datasphere, Inc. has been providing project management, software development and IT staff augmentation services to our clients in the Midwest and throughout the U.S. since 1996. We are an approved vendor on contract to provide software development and IT staff augmentation services for the States of Illinois, Michigan, Minnesota, Iowa, and Wisconsin. We also provide these services to businesses, as well as local and county governments, in the Midwest and nationwide. Our client is looking for a Data Warehouse Analyst. The team is responsible for the longitudinal data warehouse 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 staff, school districts and the general public. This person will be a member of a team practicing the Agile/Scrum development methodology. The candidates will be working to gather requirements, assure quality and generally build out the agency s modernized Public portal. Tasks • 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. • Work with and serve as a liaison between management and business units within, external stakeholders, product owners, developers, and the scrum master and product owner to identify and analyze opportunities for improving reporting processes and business systems. • Responsible for conducting research, analyzing and documenting system requirements and business rules, and creating user stories. • Responsible for creating functional requirements and specifications, preparing process flow diagrams, and assisting with quality assurance. • Work closely with others to accomplish project objectives, or function independently to accomplish daily work requirements as a member of the team. • Objectives, priorities and deadlines are established in consultation with the department leaders, project managers, and IT managers. Knowledge, Skills and Abilities Required: • Strong written and verbal communication skills, including meeting facilitation skills. • Ability to work in a team environment as well as independently • Ability to synthesize requirements and work with developers to create options/recommendation papers for decisions to be made by any stakeholder level. • Ability to work with both business/program area owners and translate their needs to developers. • Ability to synthesize requirements and work with developers to create options/recommendation papers for decisions to be made by any stakeholder level. NOTE: 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. Location: Remote from within the State of WI Contract: 1 years Skills Required: • 3-5 years - Experience in data warehousing or dashboarding projects • 3-5 years - Experience/Ability to create test plans and perform application, reporting and system regression tests • 3-5 years - Experience/Ability to estimate phases of work and contribute to project planning, including experience writing user stories with clearly defined acceptance criteria. • 3-5 years - Experience using relational databases (writing queries, etc.) using SQL Server • Possess a fundamental understanding of end-to-end customer dashboard use integration and dependencies • Experience preparing business requirements and functional specifications • Experience using Azure DevOps or similar tools to manage user stories and sprint backlogs. • Knowledge of Microsoft Fabric and Power BI reporting solutions. Skills Desired A plus to have: • Knowledge of data warehousing and reporting in the education sector (K-12/P20W). • 2-5 years - Experience using Agile/Scrum Development Methodology • Experience working with education software or reporting systems at the school, district, or state levels. • Experience using Asana to track and report on project milestones. • Rate depends on experience • Candidates authorized to work in the US are encouraged to apply. We can accept H1b, , TN, and other valid work visas for IT. However, we cannot accept OPT or CPT visas at this time. • Companies submitting candidates should only submit direct W2 employees for this position. Please submit your resume by using the "URL" below