Data Warehouse Analyst

The Data Warehouse Analyst position is located within the Assessment department and will report to the Data Warehouse Manager. This position works with researchers and other stakeholders to understand their data requirements and use SQL Server to create and maintain processes and queries to meet these requirements. This position will also be responsible for loading data from outside vendors, ensuring data quality, and maintaining appropriate access. The candidate should have extensive experience and familiarity with SQL or comparable database/data warehouse applications and experience with some type of data analytic software, e.g., SAS or R.

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 UW5087, 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.

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.

• Work with developers to develop and maintain data visualization tools

• Use data from assessment vendors to validate vendor assessment setup, administration, and scoring procedures

• Identifies and resolves basic and routine data issues and upholds database-use guidelines

• Installs, configures, maintains, backs up, restores, and performance-tunes databases

• Implements varied security measures to safeguard digital information according to established policies and procedures

• Monitors and analyzes database audit tables and logs and provides varied data warehousing support and data extraction

• Facilitates unit staff training opportunities in the effective utilization of databases

• Develops components of data architectures and database management policies and standards

• Serves as a point of contact on database systems and procedures for existing projects and facilitates planning

School of Education / WIDA

Minimum: $65,500.00 annually

Commensurate with qualifications and experience. 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.

• Proven experience in writing, testing, debugging, and tuning complex SQL queries.

• Proficiency in SQL Database design, including normalization and change management.

• Broad knowledge of reporting tools such as Excel, SSRS, PowerBI, or others.

• Ability to work with users of varying skill sets and areas of focus.

• Ability to work both independently and collaboratively with hybrid teams.

• Proficiency in advanced SQL functionality such as stored procedures, error handling, and transactions.

• Experience with statistical or software packages and programming languages such as: SAS, R, SPSS, Excel, etc.

Bachelor's Degree Required

Please go to the "Apply Now" area and select your current UW Employment Status. Upload a copy of your current resume and a cover letter describing how your experience and qualifications meet the requirements of this position.

Franchesca Beswick

humanresources@wida.wisc.edu

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

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 Divisional 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.