Data Reporting Analyst

Job Details • Pomona, CA

11h • $4,799 - $5,093

About The Position

The Data Reporting Analyst works in the Division of University Advancement at Cal Poly Pomona, which develops relationships with alumni, friends, parents, corporations, and foundations to encourage involvement and private support for the university. The position supports advancement operations through reporting, analysis, data integrity, campaign readiness, user support, business process documentation, and technology analysis. Under the telework policy, the employee may be required to be physically present on scheduled remote days based on campus, division, department, or HEERA Manager needs.

This is a full-time, long-term temporary appointment for one year. The work schedule is Monday through Friday, 8:00 a.m. to 5:00 p.m. The position is classified as Administrative Analyst/Specialist Non Exempt and works under the general supervision of the HEERA Manager, with technical guidance from other Administrative Analyst/Specialist staff. The anticipated hiring range is $4,799–$5,093 per month; the classification salary range is $4,799–$6,992 per month.

Requirements

• Bachelor's degree, and/or equivalent training and administrative work experience involving study, analysis, and/or evaluation that leads to the development or improvement of administrative policies, procedures, practices, or programs.
• Working knowledge of general practices, programs, and/or an 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 affecting the applicable program, organizational unit, and/or administrative specialty.
• Knowledge of basic research and statistical analysis methods and procedures, and 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 a program or administrative specialty.
• Demonstrated ability to 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 database reports for distribution.
• Execute queries, reports, and data visualizations from the donor database to support fundraising and engagement strategies, and respond to user data requests.
• Use practical experience to improve query capabilities, dashboards, performance metrics, planning, strategy, and the timing of operational and fundraising activities.
• Assist with forecasting projections and analytical reports; assess alternative solutions and develop conclusions and recommendations for consideration.
• Support appropriate data use through established planning, policies, and protocols.
• Maintain data and system integrity; identify, analyze, and perform data cleanup as needed.
• Assist with data assessment, mapping, migration, implementation, testing, and validation for current, related, and future systems.
• Perform technical, analytical, and data governance work 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 tracking campaign needs, including revenue, gift pyramids, and pipeline activity.
• Facilitate data validation for wealth screenings and external integrations, and establish 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, and exports.
• Create and maintain business process guides and maps for internal and external use concerning data queries, reporting, data cleaning and integrity, and data structures and fields.
• Work with other Administrative Analyst/Specialist staff to understand and document data needs across University Advancement units, identify potential solutions, and assist with developing implementation timelines.
• Provide feedback to the lead regarding policy changes that may be required.
• Explore and analyze emerging technologies in philanthropy, fundraising, higher education, data and prospect analysis, predictive modeling, engagement scoring, and business intelligence.
• Perform other duties as assigned.

What This Job Offers

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