Data Reporting Analyst

Type of Appointment:Full-Time, Long Term Temporary (1-year appointment)Job Classification:Administrative Analyst/Specialist Non ExemptAnticipated Hiring Range:$4,799-$5,093 per monthWork Schedule:Monday - Friday 8:00am - 5:00pmOther:Priority consideration will be given to internal applicantsTHE 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 IntegrityAssist 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 ReadinessPerforms 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 GuidesAssist 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.TechnologyExplores 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 assignedQUALIFICATIONS: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 WorkThe 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 CheckCal 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 ***** RequirementsApplicants 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 RangeThis 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 theCSU 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 VerificationCal 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 the I-9 Acceptable Documents website .University Driving RequirementPositions 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 SafetyIn compliance with state and federal crime awareness and campus security legislation, including the Jeanne Clery Campus Safety Act, California Education Code section *****, 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 ReportandCal Poly Pomona's Annual Fire Safety Report .Pay Transparency NondiscriminationAs 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 AccommodationWe 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 ******. For more information, go toEmployment Notices .Equal Employment OpportunityConsistent 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 ****, Title IX of the Education Amendments of ****, 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 NoticesFor other important employment notices, we invite you to visit Cal Poly Pomona's Employment Notices web page.