WIDA Data Warehouse Manager

Job Summary:

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.

Responsibilities:

Designs, develops, builds, and maintains one or multiple database systems and environments or assists with an entire application to ensure data security and integrity. Develops related policy and procedure, develops and facilitates training, and serves as a subject matter expert for related project planning.

• 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

Institutional Statement on Diversity:

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

Education:

Required
Bachelor's Degree

Qualifications:

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.

Work Type:

Full Time: 100%

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

Appointment Type, Duration:

Ongoing/Renewable

Salary:

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. 

Additional Information:

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.

How to Apply:

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.

Contact:

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

---

---

Official Title:

Database Administrator III(IT026)

Department(s):

A17-SCHOOL OF EDUCATION/WCER

Employment Class:

Academic Staff-Renewable

Job Number:

315966-AS

 

The University of Wisconsin-Madison is an Equal Opportunity Employer.

Qualified applicants will receive consideration for employment without regard to, including but not limited to, race, color, religion, sex, sexual orientation, national origin, age, pregnancy, disability, or status as a protected veteran and other bases as defined by federal regulations and UW System policies. We promote excellence by acknowledging skills and expertise from all backgrounds and encourage all qualified individuals to apply. For more information regarding applicant and employee rights and to view federal and state required postings, click here

To request a disability or pregnancy-related accommodation for any step in the hiring process (e.g., application, interview, pre-employment testing, etc.), please contact the Division Disability Representative (DDR) in the division you are applying to. Please make your request as soon as possible to help the university respond most effectively to you.

Employment may require a criminal background check. It may also require you and your references to answer questions regarding sexual violence and sexual harassment.

The University of Wisconsin System will not reveal the identities of applicants who request confidentiality in writing, except that the identity of the successful candidate will be released. See Wis. Stat. sec. 19.36(7).

The Annual Security and Fire Safety Report contains current campus safety and disciplinary policies, crime statistics for the previous 3 calendar years, and on-campus student housing fire safety policies and fire statistics for the previous 3 calendar years. UW-Madison will provide a paper copy upon request; please contact the University of Wisconsin Police Department.