WIDA Data Warehouse Manager

The WIDA Data Warehouse Manager position is located within the Assessment department and will report to the Director of Psychometrics and Research. This position will be responsible for leading the design, implementation, and maintenance of WIDA's data warehouse systems, ensuring efficient and secure data storage to support mission-aligned data use and data-supported initiatives including program evaluation, research, and fulfillment of federal and state accountability requirements. The Data Warehouse Manager will collaborate closely with internal teams, including research, assessment, technology, and state and consortium relations, as well as external partners to ensure data accessibility, integrity, and system alignment with WIDA's mission to advance the academic success of multilingual learners, including those with disabilities. In addition, the Data Warehouse Manager will supervise a team of Data Warehouse Analysts and direct their work efforts to align with the needs of the organization.

Remote work is an option for this position on a voluntary basis; however, it is important to note that this role is headquartered in Madison, WI, and the tasks of the position require occasional work-related travel. If working remotely out-of-state, travel back to UW-Madison would not be reimbursable, and other business travel will require cost comparisons between your home and Madison, WI.

UW Travel Policy and Remote Work Policies outline business travel requirements for fully remote employees, and WIDA is committed to supporting employees with their business travel and minimizing or eliminating out-of-pocket expenses whenever possible. Please review UW Remote Work Policy UW-5087, in particular, Section III, Part G which addresses an employee's Headquarters Location. We will be happy to support and address questions about remote work or travel during the interview process.

• 20% Develops data architectures and database management policies and standards
• 20% Identifies and resolves data issues and upholds database-use guidelines
• 10% Installs, configures, maintains, backs up, restores, and performance-tunes databases
• 10% Implements complex security measures to safeguard digital information
• 10% Monitors and analyzes database audit tables and logs and provides complex data warehousing support and data extraction
• 10% Identifies, develops, and facilitates unit staff training opportunities in the effective utilization of databases
• 10% Serves as a subject matter expert on database systems and procedures for new projects and facilitates planning
• 10% Supervises team members to ensure performance toward progress and achievement of program goals

Diversity is a source of strength, creativity, and innovation for UW-Madison. We value the contributions of each person and respect the profound ways their identity, culture, background, experience, status, abilities, and opinion enrich the university community. We commit ourselves to the pursuit of excellence in teaching, research, outreach, and diversity as inextricably linked goals.

The University of Wisconsin-Madison fulfills its public mission by creating a welcoming and inclusive community for people from every background - people who as students, faculty, and staff serve Wisconsin and the world.

For more information on diversity and inclusion on campus, please visit: Diversity and Inclusion

Required
Bachelor's Degree

Required
- Minimum 3 years of experience in SQL database design and development, including advanced query writing, stored procedures, triggers, functions, normalization, ETL processes, and use of SQL Server Integration Services (SSIS).
- Demonstrated experience designing and optimizing cloud-based infrastructure, particularly using Microsoft AZURE.
- Experience managing and maintaining longitudinal data warehouses, including the development of data pipelines, reporting systems, and quality assurance processes.
- Proficiency with statistical or software packages and programming languages such as: Python, R, SAS, SPSS, Stata, and advanced use of Excel.
- Demonstrated ability to manage multiple high-priority projects simultaneously while maintaining accuracy, attention to detail, and data security, including experience handling personally identifiable information (PII).
- Experience supervising or managing staff.

Preferred
- Experience supporting data systems and analytics in K-12 educational settings, particularly related to language assessment or multilingual learners.
- Familiarity with research methods and statistical analysis in large-scale assessment or test development contexts.
- Experience presenting technical information to non-technical interest holders, including training or documentation for analysts or system users.
- Knowledge of data governance, privacy standards, and compliance requirements related to educational data (e.g., FERPA).
- Experience contributing to or supporting validation studies or research reports involving complex datasets.

Full Time: 100%

It is anticipated this position will be remote and requires work be performed at an offsite, non-campus work location.

Ongoing/Renewable

Minimum $96,000 ANNUAL (12 months)
Depending on Qualifications
This position offers a comprehensive benefits package, including generous paid time off, competitively priced health/dental/vision/life insurance, tax-advantaged savings accounts, and participation in the nationally recognized Wisconsin Retirement System (WRS) pension fund. For a summary of benefits, please visit: https://hr.wisc.edu/benefits/ https://www.wisconsin.edu/ohrwd/benefits/download/fasl.pdf.

What is WIDA? For over 20 years, WIDA has provided a trusted, comprehensive approach to supporting, teaching, and assessing multilingual learners. We are an educational services organization that advances language development and academic achievement for multilingual children in early childhood and grades K-12. In short, we provide educators around the world with high-quality language standards, assessments, professional learning, and research. We are proud to be a part of the Wisconsin Center for Education Research (WCER) within UW-Madison's nationally ranked School of Education. Visit https://wida.wisc.edu/about/careers and watch our Introduction to WIDA video to see why WIDA is an incredible place to work!

WIDA operates in a Windows-based environment, and a Dell PC laptop will be issued for use in this role. Software and virtual connection tools that are critical to our work dictate that WIDA staff work on a PC.

Please click on the "Apply Now" button to start the application process. As part of the application process, you will be required to submit:
- A cover letter describing how your experience and qualifications meet the requirements of this position.
- A current resume or CV.
- A list of at least three professional references, including contact information.

A successful applicant will be responsible for ensuring eligibility for employment in the United States on or before the effective date of the appointment.

Kelly Krahenbuhl
humanresources@wida.us
Relay Access (WTRS): 7-1-1. See RELAY_SERVICE for further information.

Database Administrator III(IT026)

A17-SCHOOL OF EDUCATION/WCER

Academic Staff-Renewable

315966-AS