Job DescriptionThe Advancement Operations team has an exciting opening for a Reporting Services Analyst. This is a full-time permanent position.University Advancement seeks a Reporting Services Analyst to transform complex data into meaningful information that supports decision-making across the organization. This role serves as a key partner to multiple teams by providing accurate reporting, data analysis and insights that help guide organizational priorities.
The Reporting Services Analyst combines technical expertise with strong customer service to understand business needs, answer data questions, and assist with reports, dashboards and self-service solutions. By delivering trusted information and actionable insights, this position helps leaders make informed decisions about workforce planning, operations and resource management.
What You Will DoProgramming & Technical Implementation (80%)
- Develop, optimize, and maintain SQL queries and stored procedures to extract, manipulate and analyze data from multiple databases.
- Troubleshoot data issues and optimize database performance in collaboration with the Data Governance team.
- Define data standards, business rules and validation procedures to ensure accuracy and integrity across all reporting platforms.
- Assist in creating custom views, self-service reporting tools, dashboards and automated performance reports that empower users to independently access and interpret information.
- Analyze trends, patterns and key performance indicators to provide insights supporting strategic planning, workforce decisions, operational improvements and resource management.
- Translate ad hoc business inquiries into clean and accurate reports.
- Maintain data security and compliance standards to protect the confidentiality and integrity of sensitive information.
- Document report specifications, data dictionaries and relevant documentation for future reference.
Stakeholder Management (15%)
- Collaborate with technical and non-technical stakeholders across the organization to understand reporting requirements and translate them into actionable solutions supporting operational and strategic decision-making.
- Serve as a trusted reporting and analytics advisor to University Advancement teams on reporting strategy, data interpretation and solution development.
- Provide timely and high-quality frontline support to stakeholders on ad hoc requests and customer service needs.
Other Duties (5%)
- Stay current on industry best practices and emerging trends in reporting, data visualization and analytics.
- Participate in University Advancement and UW working groups, communities of practice, committees and events to support collaboration and continuous improvement.
Required QualificationsTo be considered for this opportunity, your application must demonstrate that you meet the minimum qualifications and additional qualifications listed below. Equivalent education and/or experience may substitute for minimum qualifications except when there are legal requirements, such as a license, certification, and/or registration.
Minimum QualificationsApplicants who do not meet these qualifications will not be forwarded to the Hiring Department.
Bachelor's degree AND two years of professional experience as a Reporting Analyst or similar role.
Preferred Qualifications- Strong SQL proficiency for data manipulation, extraction, analysis and designing database objects (tables, views, triggers, indices, stored procedures, user-defined functions).
- Experience with relational databases, Microsoft Dynamics CRM and/or HRIS systems.
- Familiarity with Python.
- Familiarity with Power BI and/or Tableau.
- Strong Microsoft Office and general PC computer skills.
- Demonstrated ability to interpret complex datasets and extract meaningful insights.
- Experience designing and developing financial and/or HR reports.
- Knowledge of taxonomy/ontology structures.
- Excellent communication and collaboration skills with cross-functional teams.
- Detail-oriented with strong accuracy in data analysis and reporting.
- Ability to work independently and manage multiple priorities in a fast-paced environment.
- Knowledge of data security and compliance standards.
Additional Application RequirementThis recruitment requires a cover letter. Applications that do not include a cover letter will not be forwarded to the hiring department.
Please address the following in your cover letter:
- Outline your qualifications and suitability for the position.
- Include your interest in the role and how your experience has prepared you to be successful as a Reporting Services Analyst.
What You Can Expect- Hybrid-work schedule with two days in the office and three days eligible for telework per week.
- Cubicle/open workspace environment that may result in higher noise levels and visual distractions.
#UWUAJOBS
Compensation, Benefits and Position DetailsPay Range Minimum:$90,468.00 annual
Pay Range Maximum:$95,220.00 annual
Other Compensation:Benefits:For information about benefits for this position, visit https://www.washington.edu/jobs/benefits-for-uw-staff/
Shift:First Shift (United States of America)
Temporary or Regular?This is a regular position
FTE (Full-Time Equivalent):100.00%
Union/Bargaining Unit:Not Applicable