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.
Report Writing, ETL and Development - 55%
Work with business users to identify business and system solutions addressing specific needs of a business area or process.
Coordinate with business users to translate business requirements into coherent Business Intelligence reports.
Work with university partners to define data and report requirements to be considered during report design.
Design, develop and deliver reporting solutions to the customer base.
Develop new reports, update existing reports, and participate in the testing and deployment of those reports.
Document, process, and provide data for ad-hoc reporting requirements.
Work with MS Excel to conduct data validation for ad-hoc reports.
Query databases to extract information to develop reports and use ETL processes as necessary.
Work with a data programmer analyst to support ETL process flows and mappings to/from data warehouse, marts and/or data lakes.
Develop business and technical requirement documents as well as technical specifications.
Analysis and Design - 30%
Gathering business requirements from the business users as well as developing system specifications for projects, enhancements and bug/issues.
Interpret, analyze and make recommendations regarding data accuracy needs and processes.
Utilize data repositories and reporting tools to organize, analyze and report information based on user requirements.
Perform system testing of reporting and other key data processes during updates and upgrades.
Document all test procedures for systems and processes and coordinate with business data analysts and users to resolve all requirement issues and maintain quality for same.
Monitor all business requirements and validate all designs and schedule all ETL processes and prepare documents for all data flow diagrams.
Troubleshooting business systems and processes.
Project Management - 10%
Apply principles of project management throughout tasks.
Create, manage, steward institutional data dictionary as needed.
Liaison with WSUF IT and Data services, university partners and business system analysts to ensure effective use, standardization and utilization of systems and tools for department.
Identify opportunities to enhance existing and develop new processes and tools.
Train business users and university partners on reports and reporting solutions and other query/reporting tools as needed.
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.
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 Carnegie 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 i...ts 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.