Junior Data Analyst - Reporting

Verified Job On Employer Career Site

Job Summary:

California State Polytechnic University-Pomona is seeking a Data Reporting Analyst to enhance the private support and knowledge of the university. The role involves designing reports, conducting data analysis, and providing training to users while ensuring data integrity and promoting effective data use.

Responsibilities:

• Design, create and implement a suite of reports from the donor management database, including Tableau, and respond and provide reports to user data requests.

• Produce weekly, monthly, quarterly, and other necessary reports from the database for distribution.

• Build and execute queries, reports, data visualizations for fundraising and engagement strategy.

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

• Create forecasting reports, engagement scoring, predictive modeling tools/reports.

• Identify strengths and weaknesses of alternative solutions, make conclusions and recommendations for approach.

• Responsible for promoting appropriate data use through planning, policy and protocols. Ensure data and system integrity.

• Identify, analyze, and perform data cleanup as needed.

• Responsible for data assessment, mapping, migration, implementations, testing, and validation of current, related, and future systems.

• Provides operations support to the department by greeting guests, receiving deliveries, and processing mail as needed.

• Assist users with Raiser's Edge questions and conduct trainings.

• Identify, create, implement techniques, which will improve productivity for the user community.

• Develop training materials and perform training for user community.

• Coordinate with the data governance group on proposed changes to operational and/or data structure/fields.

• Assist users with questions and requests for changes to reports, dashboards, exports, etc.

• Maintain and update related policies and procedures documentation.

• Stays abreast of current emerging technologies in philanthropy, fundraising, higher education, data and prospect analysis, predictive modeling, engagement scoring, and business intelligence.

Qualifications:

Required:

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

• Driver License, Valid and in State Required

• Two (2) years of related experience

• Working knowledge of, and ability to apply standard theories, principles, practices, and techniques applicable to the program and/or administrative specialty to develop conclusions and make recommendations; thorough knowledge of policies, procedures, and outside regulations pertaining to the applicable program and/or administrative specialty; working knowledge of operational and fiscal analysis and techniques; ability to take initiative and plan, organize, coordinate, and perform work in various situations where numerous and diverse demands are involved.

• Skill in research, development and evaluation of policies and programs, including skill in the collection, evaluation, and interpretation of data to develop sound conclusions and make appropriate recommendations; expertise in investigating and analyzing problems with a broad administrative impact and implications; ability to anticipate problems and address them proactively; demonstrated ability to effectively interpret, organize, and present information and ideas in written or presentation form; ability to train others on new skills and procedures and provide lead work direction.

Preferred:

• Microsoft Office Suite with advanced knowledge in Excel, Excel macros, pivot tables, graphical reporting such as Tableau.

• Development of data analysis and reporting

• Experience using Raiser's Edge, Tableau, PowerBI, NXT, Crystal Reports

• Experience in forecasting, predictive modeling

• Knowledge of current trends in database management, reporting and best practices, using CASE (Council for Advancement and Support of Education), AASP (Association of Advancement Services Professionals), and IRS rules and regulations

Company:

The official LinkedIn account of Cal Poly Pomona, the #1 polytechnic university for diversity and economic mobility. Here, you #BecomeByDoing. Founded in 1938, the company is headquartered in Pomona, CA, US, with a team of 1001-5000 employees. The company is currently Late Stage.