Data Reporting Analyst

Cal Poly Pomona•Pomona, CA

1d•$4,799 - $5,093•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 and data visualizations from the donor database, and ensuring data integrity. The analyst will also contribute to campaign readiness by conducting database assessments, creating data hygiene protocols, and collaborating on dashboard development. Additionally, the position will provide customer service and business process guidance to users of the Raiser's Edge system and explore emerging technologies in philanthropy and data analysis.

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.
Under general supervision of the HEERA manager and with technical guidance from other Administrative Analyst/Specialist staff, 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.
Performs technical, analytical, and data governance responsibilities to establish and support divisional campaign readiness.
Conducts database assessments and creates data hygiene and intake protocols to support record accuracy and data integrity.
Collaborates on campaign schema design, field mappings, and migration testing across relational databases and warehouse environments.
Authors, tests, and deploys queries.
Works 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.
Facilitates data validation for wealth screenings and external integrations, while establishing reporting documentation and definitions for divisional stakeholders.
Guides 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.
In collaboration with other Administrative Analyst/Specialist staff, 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.
Explores and provides analysis of emerging technologies in philanthropy, fundraising, higher education, data and prospect analysis, predictive modeling, engagement scoring, and business intelligence.
Other duties as assigned