Data Reporting Analyst

CSU Careers • Pomona, CA

17h • Hybrid

About The Position

The Division of University Advancement is seeking a Data Reporting Analyst to support fundraising and engagement strategies. This role involves assisting with the production of various reports, executing queries from the donor database, and responding to user data requests. The analyst will utilize practical experience to enhance query capabilities, dashboards, and performance metrics, contributing to operational and fundraising planning. Additionally, the position supports data integrity by identifying and performing data cleanup, and assists with data assessment, mapping, migration, and validation for current and future systems. The role also plays a part in establishing and supporting divisional campaign readiness through technical, analytical, and data governance responsibilities, including database assessments, data hygiene protocols, and collaboration on campaign schema design and migration testing. Customer service is a key component, involving assisting users with database questions and report requests, and creating business process guides. The analyst will also explore emerging technologies in philanthropy and fundraising.

Requirements

• Bachelor's Degree - AND/OR the equivalent training and administrative work experience involving study, analysis, and/or evaluation leading to the development or improvement of administrative policies, procedures, practices, or programs.
• Working knowledge of general practices, program, and/or administrative specialty.
• Basic knowledge of and ability to apply fundamental concepts.
• Working knowledge of budget policies and procedures.
• Ability to learn, interpret, and apply a wide variety of policies and procedures relating to and impacting the applicable program, organizational unit, and/or administrative specialty.
• Knowledge of basic methods and procedures for research and statistical analysis and the ability to apply them.
• Ability to analyze data and make accurate projections using business mathematics and basic statistical techniques.
• Ability to organize and plan work and projects including handling multiple priorities.
• Ability to make independent decisions and exercise sound judgment.
• Ability to compile, write, and present reports related to program or administrative specialty.
• Demonstrated ability establish and maintain cooperative working relationships.

Nice To Haves

• Two years of experience working with online or web-based database applications and information sources.
• Experience with database reporting, data validation, data integrity, or related analytical functions.
• Experience working with advancement, fundraising, donor, or higher education data systems.

Responsibilities

• Assist with producing weekly, monthly, quarterly, and other necessary reports from the database for distribution.
• Assist with executing queries, reports, and data visualizations from the donor database for fundraising and engagement strategies and respond to user data requests.
• Utilize practical experience to formulate, interpret, and provide solutions to enhance query capabilities dashboards, performance metrics, planning, strategy, and timing of operational and fundraising activities.
• Assist with creating forecasting projections and analytical reports.
• Assist with identifying the strengths and weaknesses of alternative solutions and developing conclusions and recommendations for consideration.
• Support appropriate data use through established planning, policies, and protocols.
• Ensure data and system integrity.
• Identify, analyze, and perform data cleanup as needed.
• Assist with data assessment, mapping, migration, implementation, testing, and validation of current, related, and future systems.
• Perform technical, analytical, and data governance responsibilities to establish and support divisional campaign readiness.
• Conduct database assessments and create data hygiene and intake protocols to support record accuracy and data integrity.
• Collaborate on campaign schema design, field mappings, and migration testing across relational databases and warehouse environments.
• Author, test, and deploy queries.
• Work with the AVP of Advancement Operations, Lead Analyst, and VP Analytics team to develop and maintain dashboards that track campaign needs such as revenue, gift pyramids, and pipeline activity.
• Facilitate data validation for wealth screenings and external integrations, while establishing reporting documentation and definitions for divisional stakeholders.
• Assist users with Raiser's Edge questions and identify techniques that may improve productivity for the user community.
• Assist users with questions and requests for changes to reports, dashboards, exports, etc.
• Create and maintain business process guides/maps both for internal/external use related to data queries, reporting, data cleaning/integrity, and use of data structures/fields.
• Meet with units within University Advancement to understand and document data needs, identify potential solutions, and assist with developing implementation timelines.
• Provide feedback to lead on policy changes that may be required.
• Explore and provide analysis of emerging technologies in philanthropy, fundraising, higher education, data and prospect analysis, predictive modeling, engagement scoring, and business intelligence.
• Perform other duties as assigned.

Benefits

• The California State University (CSU) system provides access to a quality education.
• As an agency of the State of California, the CSU’s business operations almost exclusively reside within California.
• Conditional offer of employment pending satisfactory completion of a background check.
• Pay Transparency Nondiscrimination Provision.
• Reasonable accommodations provided for applicants and employees with disabilities.
• Equal opportunity in employment without unlawful discrimination or preferential treatment.
• Compliance with Title VI of the Civil Rights Act of 1964, Title IX of the Education Amendments of 1972, the Americans with Disabilities Act (ADA), Section 504 of the Rehabilitation Act, the California Equity in Higher Education Act, California’s Proposition 209, other applicable state and federal anti-discrimination laws, and CSU’s Nondiscrimination Policy.
• Priority referral of protected veterans for job openings.
• Employment Eligibility Verification.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level