The University of Maryland, Baltimore (UMB) Office of Philanthropy is seeking a full-time Philanthropy Data Analyst to join the Philanthropy Research and Prospect Management team. This role reports to the Director of Philanthropy Research and Prospect Management and is responsible for developing and reporting on key data analytics and metrics using Ellucian Advance and Blackbaud CRM.
This role will also be responsible for providing research, analysis, tools, and insights to support strategic decision-making within the Office of Philanthropy. Additionally, the Philanthropy Lead Data Analyst will develop and implement a system for the regular review and analysis of data related to giving trends, helping to build a robust pipeline of new and emerging prospects for the Office of Philanthropy’s core teams in Annual Giving, Major Giving, Principal Gifts, Gift Planning and Corporate and Foundation Relations.
The Philanthropy Data Analyst will actively collaborate with the Center for Information Technology Services (CITS) and database users across UMB to optimize CRM reports, enhancing the evaluation of office initiatives, philanthropic efforts, and fundraiser performance. Working closely with the Office of Philanthropy, as well as UMB schools and units, the analyst will extract, validate, and present donor and donor pipeline data to provide comprehensive insights into donor relations and fundraising activities, thereby strengthening leadership’s decision-making and analytical capabilities.
Benefits: Exempt Regular
UMB offers a comprehensive benefits package that prioritizes wellness, work/life balance, and professional development, along with additional exciting perks that employees can take advantage of. This position participates in a retirement program that must be selected and is effective on your date of hire. Exempt regular staff receive a generous PAID leave package that includes over 4 weeks of vacation accrued each year, 15 paid holidays, 3 personal leave, unlimited accrual of sick time, and comprehensive health insurance; professional learning and development programs; tuition remission for employees and their dependents at any University System of Maryland school; and flexible work schedules and teleworking options (if applicable per job).
UMB is a public university and constituent institution of the University System of Maryland. All employees are expected to work primarily physically within the State of Maryland.
Job Responsibilities:
Technical Leadership: Offer technical leadership in the analysis of data generated from various databases, ensuring accurate and insightful business intelligence for internal stakeholders.
Data Analysis and Reporting: Act as the lead analyst to generate, gather, analyze, and prepare data for comprehensive analysis and reporting. Design and implement reports, dashboards, and other data projects related to performance metrics for various internal audiences.
Management and Methodology: Analyze management-requested data, develop rules and methodologies for effective data management, and recommend improvements to existing reporting practices to enhance transparency and data-driven decision-making.
Data Systems and Integrity: Determine specifications for data collection and delivery and develop and maintain data systems necessary for business analysis and reporting. Ensure the integrity of data, including extraction, storage, manipulation, processing, and analysis.
Trend Analysis: Gather data from various systems, solve data issues using standard statistical methods, and interpret trends or patterns in complex financial data. Develop actionable recommendations based on these findings to support the Office of Philanthropy’s goals and broader business objectives.
Pipeline Support: Support pipeline growth and sustainable fundraising efforts through in-house and vendor data analysis, such as wealth screening tools. Provide strategic, ad-hoc analysis as requested to aid in decision-making.
CRM and Technology Liaison: Act as a liaison between the IT team and relevant departments, particularly the Office of Philanthropy, in the development of CRM-related reporting, evaluation, and implementation of technology tools.
Data Integrity and Auditing: Create processes for data integrity checks around reporting data and collaborate with partners to audit and resolve data-related issues. Develop and document business rules specific to CRM analytical processes.
Documentation and Communication: Maintain documentation of current and future reporting processes, ensuring standardization and clarity. Respond to data requests for analysis in a timely manner, keeping stakeholders informed of request status and any changes.
Ethical Compliance: Adhere to ethical and confidentiality guidelines, including UMB, HIPAA, and APRA standards, in all data handling and reporting activities.
Continuous Learning: Stay current with best practices, trends, and news in prospect development and data analysis to continuously improve data offerings, approaches, and deliverables.
Additional Duties: Perform other related duties as assigned, ensuring alignment with the department's overall strategy and goals.
Position is eligible for hybrid remote work.
Education: Bachelor’s degree in business, information technology, computers science, mathematics, statistics, finance, or a related field to data being analyzed.
Experience: Five (5) years of directly related experience with statistical or data analytics, business improvement, or quality assurances practices.
Preferred Experience: Experience in working with CRM systems, Blackbaud CRM and Ellucian Advance preferred. Prior experience working with OACS (Oracle Analytics Cloud Service), Power BI for Office 365, Tableau, SQL, Crystal Reports, SharePoint, EXCEL, Visual Basic for Applications (VBA), and PowerPivot.
Experience in prospect research, prospect management, or data analysis, ideally in a mission-driven, philanthropically supported non-profit.
Knowledge, Skills, and Abilities:
Working knowledge of relational database architectures.
Advanced proficiency in the Microsoft Office products suite, especially Excel (pivot tables, formulas, macros, VLOOKUP, etc.).
Excellent organization and analytical skills, responsiveness, and attention to detail.
Understanding of industry best practices and demonstrated ethical compliance as defined by APRA.
Ability to function effectively as a member of a team, ensuring close coordination and assimilation with other staff members.
Hiring Range: $95,000 - $103,000 (Commensurate with education and experience)
UMB is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law or policy. For assistance related to employment, please contact the Talent Recruitment department at HRJobs@umaryland.edu.
If you anticipate needing a reasonable accommodation for a disability under the Americans with Disabilities Act (ADA), during any part of the employment process, please submit a UMB Job Applicant Accommodation Request. You may also contact HRDiversity@umaryland.edu. Please note that only inquiries concerning an ADA request for reasonable accommodation will be responded to from this email address.
The University of Maryland, Baltimore prohibits sex discrimination in any education program or activity that it operates. Individuals may report concerns or questions to the Title IX Coordinator. For more information, follow this link UMB Notice of Non-Discrimination.
Education: Bachelor’s degree in business, information technology, computers science, mathematics, statistics, finance, or a related field to data being analyzed.
Experience: Five (5) years of directly related experience with statistical or data analytics, business improvement, or quality assurances practices.
Preferred Experience: Experience in working with CRM systems, Blackbaud CRM and Ellucian Advance preferred. Prior experience working with OACS (Oracle Analytics Cloud Service), Power BI for Office 365, Tableau, SQL, Crystal Reports, SharePoint, EXCEL, Visual Basic for Applications (VBA), and PowerPivot.
Experience in prospect research, prospect management, or data analysis, ideally in a mission-driven, philanthropically supported non-profit.
Knowledge, Skills, and Abilities:
Working knowledge of relational database architectures.
Advanced proficiency in the Microsoft Office products suite, especially Excel (pivot tables, formulas, macros, VLOOKUP, etc.).
Excellent organization and analytical skills, responsiveness, and attention to detail.
Understanding of industry best practices and demonstrated ethical compliance as defined by APRA.
Ability to function effectively as a member of a team, ensuring close coordination and assimilation with other staff members.
Hiring Range: $95,000 - $103,000 (Commensurate with education and experience)
UMB is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law or policy. For assistance related to employment, please contact the Talent Recruitment department at HRJobs@umaryland.edu.
If you anticipate needing a reasonable accommodation for a disability under the Americans with Disabilities Act (ADA), during any part of the employment process, please submit a UMB Job Applicant Accommodation Request. You may also contact HRDiversity@umaryland.edu. Please note that only inquiries concerning an ADA request for reasonable accommodation will be responded to from this email address.
The University of Maryland, Baltimore prohibits sex discrimination in any education program or activity that it operates. Individuals may report concerns or questions to the Title IX Coordinator. For more information, follow this link UMB Notice of Non-Discrimination.