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;
This position will analyze, develop and maintain all data elements in the data warehouse, including defining, implementing, and editing code based on data reporting needs.
The data and reporting analyst will also provide functional support and configuration for financial and gift processing reporting, including setup/update of configuration values, system testing; month end, calendar and fiscal year-end financial closing reporting activities as it relates to institutional reporting requirements.
This position will also work interface with university budget and finance teams and the Foundation Finance team to develop business system analysis to ensure effective use and utilization of systems' and tools for the donor data, accounting and finance areas for analysis, management, reporting, compliance and decision-making.
Analysis and Design - 55% Work with area leader to implement identify business and/or system solutions addressing specific needs of a business area or process.
Work with university partners to define data and report requirements to be considered during report design.
Interpret, analyze and make recommendations regarding data accuracy needs and processes.
Design and write computer programs using programing software to generate reports, custom reports, labels, and data files.
Write business process audit queries and manage the monitoring of integrity check and audits of the warehouse.
Distribute and oversee clean up projects for incorrect data found in audits and integrity checks.
Define and evaluate logic flow parameters for all computing requests.
Design and test data enhancements and quality control automation procedures to fine-tune data depending on customer needs.
Enforce data warehousing standards to meet requirements and business needs.
Report Writing and Development - 30% Perform Ddata and report development using Microsoft Business Intelligence Suite components (BIDS, SSDT report studios, Event Studio, Framework Manager, t-sql and ETL data validation and automation tools.
Maintain professional and technical knowledge by reviewing professional publications, attending educational training workshops, and participating in staff development as recommended and approved by the supervisor.
Utilize data repositories and reporting tools to organize, analyze and report information based on user requirements. Maintain and adjust coding to ensure user reporting needs are met.
Design, develop and test standard and ad-hoc financial and gift accounting reports.
Query databases to extract information to develop reports and use ETL processes as necessary. Provide functional support for gift accounting and financial processing and reporting. Work with finance to staff to identify data issues in reports. Adjust report coding to correct data issues in reports.
Work with development teams to design and update gift accounting and financial data models for report and audit requirements and compliance.
Work with WSUF IT data team to support extract, transform, load process flows and mappings to/from data warehouse, marts and/or data lakes.
Perform system testing of reporting and other key data processes during updates and upgrades.
Work with MS Excel to conduct data validation for reports. and Work with MS Business Data Intelligence Studio and/or SQL Server Data Tools to design, build, modify and create reports.
Project Management - 10%
Apply principles of project management throughout tasks.
Create, manage, steward institutional data dictionary as needed.
Liaison with WSUF IT and Advancement records and university partner business systems analyst to ensure effective use, standardization and utilization of systems and tools for department.
Identify opportunities to enhance existing and develop new processes and tools.
Ensure projects are prioritize to meet department goals and project time is managed properly to meet project short term and long term goals.
Perform and assist in monthly and calendar/fiscal year-end gift accounting and financial close activities related to reporting.
Lead report conversion projects, report consolidation and report enhancements depending on Foundation needs.
Train university partners on reports and reporting solutions and other query/reporting tools as needed.
Possess project management, organizational, and planning skills are required with a keen attention to detail.
Other Duties as Assigned - 5%
Required Qualifications: Positions require a Bachelors 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.
Founded in 1890 in Pullman, Washington State University (WSU) is Washington’s land-grant university with an overarching mission of improving the quality of life for all citizens – locally, nationally, and globally. WSU is committed to innovation and excellence in research and scholarship. WSU has a current enrollment of over 30,000 undergraduate, graduate, and professional students and approximately 6,000 faculty and staff at its five campuses (Pullman, Spokane, Tri-Cities, Vancouver, and Everett), as well as its numerous other locations across the State of Washington and online through its Global Campus. With a new President (Dr. Kirk Schulz began as the University’s 11th president in June 2016) and a new Vice President of Finance and Administration (Stacy Pearson started in March 2017); the University community is energized and excited.
U.S. News & World Report's 2016 "America's Best Colleges" rankings place WSU in the top 75 public national universities. WSU was one of only three Northwest universities to be placed in the top two tiers, along with the University of Washington and the University of Oregon. WSU is ranked as a "highest research activity" institution by the Carne...gie Foundation and is in the top 12 percent of research universities as reported by the National Science Foundation. Also, WSU was recognized by the Carnegie Foundation for the Advancement of Teaching for its engagement activities with its Community Engagement Classification.
WSU employs approximately 6,000 faculty and professional staff and the University deeply values diversity among its faculty, students, and staff. WSU students represent diverse social, economic, and ethnic backgrounds: approximately 10 percent of WSU students hail from outside the state of Washington, and approximately 6.8 percent are international students. WSU annually awards more than $280 million in scholarships and financial aid to approximately 17,000 undergraduate students.