<< Back to Search

Data and Reporting Analyst

Job description

Employee Type:

AP-Administrative Professional

University Title:

Business Data Analyst

Working Title:

Data and Reporting Analyst


University Development


Advancement Services

Department Link:

WSU Foundation

Position Number:


Hiring Unit :

Information Technology and Data Services

Work Location:


Zip Code:


This position is in a Bargaining Unit:


Summary of Duties:

The Data and Reporting Analyst is responsible for the development, implementation, operation, maintenance, documentation, and support of donor, financial and institutional data collection, management, analysis and reporting; utilizing Microsoft Business Intelligence Suite, SQL Server Data Tools, MS PowerBI, MS Access, MS Visio, MS Excel, and PowerPivot and other query, reporting and data modeling tools.This position is responsible for systems analysis, code review, design evaluation and implementations in support of business processes and fundraising objectives. This position will develop Extract, Transform and Load (ETL) processes that build Data Warehouses allowing reports, analytics and applications to function at scale.

Additional Information:

University Overview
Founded as the people’s university in 1890, Washington State University fulfills that commitment by transforming lives through education, research, and community outreach. In 2015, the University celebrated 125 years of delivering life-changing knowledge and discoveries to citizens across the state, region, nation, and around the world. The state’s only land-grant institution and one of two public research universities, WSU provides a world-class education to nearly 30,000 students through its multi-campus, statewide locations and online. The University strives to ensure that higher education is accessible at an affordable cost—a decades-long WSU commitment to the state’s citizens. The University offers more than 200 undergraduate fields of study and 127 graduate and professional degree programs. Many academic programs win recognition nationally for excellence. WSU is one of just 108 public and private universities in the United States—out of more than 4,500—singled out for its “very high research activity” by the Carnegie Foundation for the Advancement of Teaching. The University’s research agenda is focused on addressing challenges in health, sustainability, smart systems, national security, and opportunity and equity. WSU is a major driver of Washington’s economy, partnering with many of the state’s leading industries, including agribusiness, aerospace, health care, software, and construction. The University is responsible for nearly 20,600 jobs statewide and generates an overall economic impact of more than $3.3 billion annually. The institution’s operating budget expenditures total nearly $2 billion annually.
The City
Pullman is one of the biggest little cities you’ll ever visit. Full of cosmopolitan amenities and down-home charm, this eastern Washington gem nestled in the Palouse, is also home to the flagship campus for Washington State University. The city has repeatedly been recognized as one of Washington’s safest cities, one of America’s safest college towns, and one of the best college-town neighborhoods for adults. Whether you’re looking to go to school or relocating to the area, Pullman offers a diverse community committed to inclusion, sustainability, and a high quality of life. Pullman is a dynamic hub for higher education, research, and culture. Pullman is part of the Knowledge Corridor that connects WSU to the University of Idaho in Moscow eight miles to the east and Spokane, Washington’s second-largest city, 75 miles to the north. Just a short drive away excellent outdoor recreation opportunities are abundant as well including golfing, skiing, hiking, and boating.
Benefits Package
Competitive benefits available, more details at hrs.wsu.edu/benefits.

Appointment Status:


Job Appointment (FTE%):


Position Term in Months:


Monthly Salary:

Commensurate with qualifications and experience.

Required Qualifications:

Positions require a Bachelor’s degree in a related field AND three (3) years of professional experience in business data analysis or related; OR a combination of education and experience totaling seven (7) years from which comparable knowledge and ability are acquired.

Additional Requirements:

Ability to work in SQL Server environments using SQL Server Management Studio(SSMS) tools, especially T-SQL, query analyze to create, debug, and troubleshoot stored procedures.

Experience working with Microsoft SQL Server (2012 R2 or higher) or any other relational database management system administration.

Exceptional time management skills, including the ability to adapt quickly to shifting priorities and prioritize multiple competing tasks in a fast-paced environment.

Excellent organization, teamwork, problem-solving, and communication (verbal and written) skills.

Demonstrated ability to provide effective customer service to people at all levels of the organization.

Ability to work and sustain attention with distractions and/or interruptions.

Possess project management, organizational, and planning skills are required with a keen attention to detail.

Preferred Qualifications:

A degree in Management Information Systems, Accounting, Finance, Computer Science or related filed is strongly preferred.

Experience using modern operating systems.

Advanced proficiency with Microsoft Office suite with an emphasis on Excel (PowerPivot), Access and Visio.

Experience implementing or working with Ellucian Advance or other higher education database management systems.

Knowledge of Business Intelligence principles.

Demonstrated working knowledge of SQL Server and Reporting Services.

Demonstrated working knowledge of SQL Server Integration Services.

Demonstrated working knowledge of SQL Server Analysis Services.

Demonstrated knowledge of process, ethics and policies of professional fundraising.

Will this position require a background check?:

This position has been designated by the department to require a background check

Open Date:


Close Date:


Open Until Filled :


Special Instructions to Applicants:

Screening of applications will begin on December 3, 2020, and will continue until the position has been filled.
Applicants must attach the following documents to their online application: 1) resume and 2) cover letter. Application materials should clearly communicate how the applicant meets all required qualifications and additional requirements. Applicants are required to include contact information for at least three (3) professional references in the application.

EEO Statement :

WASHINGTON STATE UNIVERSITY IS AN EQUAL OPPORTUNITY/AFFIRMATIVE ACTION EDUCATOR AND EMPLOYER. Members of ethnic minorities, women, special disabled veterans, veterans of the Vietnam-era, recently separated veterans, and other protected veterans, persons of disability and/or persons age 40 and over are encouraged to apply.

WSU employs only U.S. citizens and lawfully authorized non-U.S. citizens. All new employees must show employment eligibility verification as required by the U.S. Citizenship and Immigration Services.

WSU is committed to providing access and reasonable accommodation in its services, programs, activities, education and employment for individuals with disabilities. To request disability accommodation in the application process, contact Human Resource Services: 509-335-4521(v), Washington State TDD Relay Service: Voice Callers: 1-800-833-6384; TDD Callers: 1-800-833-6388, 509-335-1259(f), or [email protected]

Posting Number:





Diversity Profile: University


Learn more on Inside Higher Ed's College Page for University

Arrow pointing right
Job No:
Posted: 11/21/2020
Application Due: 12/13/2020
Work Type: