"Alerted.org

*The University of Maryland, Baltimore (UMB) Office of Philanthropy*is seeking a full-time*Lead Philanthropy Data Analyst (Lead Business 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. *Position is eligible for hybrid remote work.* 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 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. This position is pivotal in advancing the university's philanthropic mission through data-driven insights and strategic analysis. *Benefits (Exempt Regular): * UMB offers acomprehensive benefits packagethat prioritizes wellness, work/life balance, and professional development, along withadditional exciting perksthat employees can take advantage of. This position participates in a retirement program (pension or optional retirement plan/ORP) 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, 16 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. * *Primary Duties:* * *Strategic Support:*Provide strategic and tactical support by analyzing and interpreting business and statistical data to develop creative solutions for business decision-making and planning, particularly in support of fundraising and philanthropy initiatives. * *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. *Education:*Bachelor's degree in business, information technology, computer 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 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 preferred. Experience in prospect research, prospect management, or data analysis, ideally in a mission-driven, philanthropically supported non-profit preferred. *Supervisory Experience:*N/A. *Certification/Licensure:*N/A. *Other:*Except for qualifications established by law, additional related experience and formal education in which one has gained the knowledge, skills, and abilities required for full performance of the work of the job class may be substituted for the education or experience requirement on a year-for-year basis with 30 undergraduate college credits being equivalent to one year of related experience. In instances where specific education and/or experience is required only directly related education and/or experience may be substituted. *Knowledge, Skills, and Abilities:* * Proficiency in extracting, cleaning, analyzing, and synthesizing findings from data sets. * 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: $98,000 - $103,000, Commensurate with education and experience * UMB is committed to cultivating a diverse and inclusive workforce and is proud to be an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, ancestry or national origin, sex, pregnancy or related conditions, sexual orientation, gender identity or expression, genetic information, physical or mental disability, marital status, protected veteran's status, or any other legally protected classification. 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 aUMB Job Applicant Accommodation Request. You may also [email protected]. 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. Read theUMB Notice of Non-Discriminationfor more information. **Job:** **Reg or CII Exempt Staff* **Organization:** **Philanthropy* **Title:** *Lead Philanthropy Data Analyst * **Location:** *null* **Requisition ID:** *250000DF*