Data Reporting Analyst

California State Polytechnic University-Pomona; Pomona (CA); On-site; USD 54,000 - 78,000; Full time

Job summary

California State Polytechnic University-Pomona seeks an Administrative Analyst/Specialist Non Exempt to support reporting, data governance, and campaign readiness within the Division of University Advancement. The role emphasizes data integrity, forecasting, and collaboration with the VP Analytics team to maintain dashboards and improve fundraising activities.

The position offers full-time hours, standard weekday schedule, and a focus on data-driven decision making within a major public

Qualifications

• Bachelor's degree or equivalent training and experience in analysis, policy development, or program administration.
• Knowledge of general administrative practices and budgeting policies.
• Ability to learn and apply a wide variety of policies impacting programs.
• Experience with data analysis, statistics, and interpreting data.
• Ability to build, write, and present reports.
• Ability to coordinate with multiple units and maintain cooperative relationships.
• Experience with database reporting, data validation, or related analytical functions.

Responsibilities

• Produce weekly, monthly, and quarterly reports from donor databases.
• Create queries, dashboards, and visualizations for fundraising and engagement strategies.
• Develop forecasting projections and analytical reports.
• Maintain data integrity and perform data cleanup as needed.
• Collaborate on campaign schemas, mappings, and migrations across relational databases.

Skills

Analytical skills

Data analysis

Data integrity

Education

Bachelor's degree or equivalent

Tools

Raiser's Edge

Job description

Type of Appointment

Full-Time, Long Term Temporary (1-year appointment)

Job Classification

Administrative Analyst/Specialist Non Exempt

Anticipated Hiring Range

$4,799-$5,093 per month

Work Schedule

Monday - Friday 8:00am - 5:00pm

Other

Priority consideration will be given to internal applicants

The Department

The Division of University Advancement is one of five central divisions of the university whose primary purpose is to enhance the private support and knowledge of the university. This is accomplished by initiating programs, events and activities that stimulate the involvement and interest of alumni, friends, parents, corporations and foundations to develop relationships that will foster and stimulate giving to the university. The office the Vice President of University Advancement oversees the offices of development, alumni and external relations, advancement operations, finance and administration, government and community relations and annual giving. The division manages and operates the Cal Poly Pomona Philanthropic Foundations which serves as the official entity to receive and manage all contributions to the University. Under the telework policy it is understood that your physical presence may be required on individual scheduled remote days based on the needs of the campus, division, department, or request of your HEERA Manager.

Duties And Responsibilities

Reporting, Analysis, Data Integrity

• 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.

Campaign Readiness

• 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.

Customer Service and Business Process Guides

• 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.
• 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.

Technology

• 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

Qualifications

• 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.

Preferred Qualifications

• 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.

Out of State Work

The California State University (CSU) system is a network of twenty-three public universities providing access to a quality education through the support of California taxpayers. Part of CSU’s mission is to prepare educated, responsible individuals to contribute to California’s schools, economy, culture, and future. As an agency of the State of California, the CSU’s business operations almost exclusively reside within California. The CSU Out-of-State Employment Policy prohibits hiring employees to perform CSU-related work outside California. For more information, Go to the California State University Out-of-State Employment Policy.

Background Check

Cal Poly Pomona will make a conditional offer of employment to final job candidates, pending the satisfactory completion of a background check (including a criminal records check). The conditional offer of employment may be rescinded if the background check reveals disqualifying information, and/or it is discovered that the candidate knowingly withheld or falsified information. In determining the suitability of the candidate for the position, Cal Poly Pomona will give an individualized assessment to any information that the applicant submits for consideration regarding the criminal conviction history such as the nature, gravity and recency of the conviction, the candidate’s conduct, performance or rehabilitation efforts since the conviction and the nature of the job applied for. For more information, go to the California State University Background Check Policy.

Education Code 89521 Requirements

Applicants will be required to disclose whether they have received a final administrative decision or final judicial decision determining that they have committed sexual harassment within the last 7 years only after a determination is made that they meet the minimum qualifications for the position, and before an offer of employment is extended. Applicants who reach the final stages of the application process must also sign a release form that authorizes the release of information by the applicant’s current and/or former employers to the CSU concerning any substantiated allegations of misconduct.

CSU Classification Salary Range

This position is part of the CSUEU bargaining unit 9. The CSU Classification Standards for this position are located on the CSU Classification Standards website . The CSU Salary Schedule is located on the CSU Salary Schedule website . The classification salary range for this position according to the respective skill level is: minimum $4,799 and maximum $6,992 per month. Please refer to the anticipated hiring range for the appropriate salary rate for this particular position.

Employment Eligibility Verification

Cal Poly Pomona hires only individuals lawfully authorized to work in the United States. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification form upon hire. For more information, go to the I-9 Acceptable Documents website.

University Driving Requirement

Positions that require driving for university business by using a personal or state vehicle must comply with the Authorized University Driver Policy. Driving records are monitored and evaluated by the Risk Management Department. The Risk Management Department evaluates a good driving report based on the following criteria. The driver must: 1. Have a valid California or other State Driver’s license. 2. Have no more than 3 motor vehicle violations or been the cause of 3 accidents in a 12-month period (or any combination of 3 thereof) 3. Not have more than 3 DMV Points, if their license is Class C or, 4. Not have more than 5 DMV Points, if their license is Class A, B, or C with endorsements. For more information, go to the Authorized University Driver Policy.

Security & Fire Safety

In compliance with state and federal crime awareness and campus security legislation, including the Jeanne Clery Campus Safety Act, California Education Code section 67380, and the Higher Education Opportunity Act (HEOA), Cal Poly Pomona’s Annual Security Report and Annual Fire Safety Report are available for viewing at Cal Poly Pomona’s Annual Security Report and Cal Poly Pomona’s Annual Fire Safety Report.

Pay Transparency Nondiscrimination

As a federal contractor, Cal Poly Pomona will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. For more information, see the Pay Transparency Nondiscrimination Provision poster.

Reasonable Accommodation

We provide reasonable accommodations to applicants and employees with disabilities. Applicants with questions about access or requiring a reasonable accommodation for any part of the application or hiring process should contact the ADA Coordinator by email at [e-mail] . For more information, go to Employment Notices.

Equal Employment Opportunity

Consistent with California law and federal civil rights laws, Cal Poly Pomona provides equal opportunity in employment without unlawful discrimination or preferential treatment based on race, sex, color, ethnicity, or national origin. Our commitment to equal opportunity means ensuring that every employee has access to the resources and support they need to thrive and succeed in a university environment and in their communities. Cal Poly Pomona complies 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 (Art. I, Section 31 of the California Constitution), other applicable state and federal anti-discrimination laws, and CSU’s Nondiscrimination Policy. We prohibit discriminatory preferential treatment, segregation based on race or any other protected status, and all forms of discrimination, harassment, and retaliation in all university programs, policies, and practices. As a federal contractor, Cal Poly Pomona complies with the Vietnam Era Veterans’ Readjustment Assistance Act (VEVRAA) and requests priority referral of protected veterans for our job openings.

Other Notices

For other important employment notices, we invite you to visit Cal Poly Pomona’s Employment Notices web page.