Current employees: if you are currently employed at any of the universities of wisconsin, log in to workday to apply through the internal application process.
Job category:
Academic Staff
Employment type:
Regular
Job profile:
Database Administrator I
Job summary:
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.
Key job responsibilities:
-
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
Department:
School of Education / WIDA
Compensation:
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.
Required qualifications:
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.
Preferred qualifications:
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.
Education:
Bachelor's Degree Required
How to apply:
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.
Contact information:
Franchesca Beswick
humanresources@wida.wisc.edu
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.
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.
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.
Employment may require a criminal background check. It may also require your references to answer questions regarding misconduct, including 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.
