The University of South Carolina (UofSC) needs to support major gift development efforts by providing data and performing analysis of donors, prospects, and alumni. This role will translate reporting objectives into technical specifications and develop solutions using BI tools to support fundraising efforts.
Requirements
- Design and development experience using Tableau; Qlik; Power BI; Microsoft Business intelligence; SQL Server Integration Services (SSIS); SQL Server Analysis Services (SSAS); and/or SQL Server Reporting Services (SSRS)
- Some knowledge of technical and analytical skills with the ability to process, interpret and analyze constituent data using their broad knowledge base of various database data types
- Previous experience with Enterprise CRM software and a familiarity with Blackbaud CRM or other higher education and/or nonprofit donor system
Responsibilities
- translate reporting objectives and business requirements into technical specifications, report design and code
- utilize Tableau, QlikView, and/or Microsoft Power BI and various other applications to document, design, develop, test and implement analysis, dashboards, extracts and other solutions
- leverages ad-hoc query and other built in system functionalities to design, maintain and support Standard queries, Recognition Programs, Giving Societies, Acknowledgement Letters, Direct Marketing Efforts, Mailings, Email Campaigns and other possibilities available with the Blackbaud CRM constituent relationship management system
- Uses Batch Import functions to enhance system by assisting with large data entry efforts, data quality projects, standardization, and/or other and conducts data exchange processes to include data updates from multiple sources
- perform testing and validation of data sets and identifies variances and elements which will require routine review
- use Tableau, QlikView, and/or Microsoft Power BI and various other applications to document, design, develop, test and implement analysis, dashboards, extracts and other solutions in accordance with project plans, business requirements and specifications
- Collaborate with the Senior Director and other Analysts to review and develop interactive and detailed charts and reports to communicate insights regarding prospects and fundraising initiatives, as well as fundraiser performance and progress reports utilizing the CRM database, as well as a variety of other data sources, software, tools and platforms
Other
- Under general supervision, reporting to the Senior Director of Analytics & Client Solutions (Senior Director), the Junior Data Analyst supports the success of major gift development efforts at the University of South Carolina (UofSC) by providing data and performing analysis of annual, major and planned gift donors, prospects and alumni.
- Works closely with the Senior Director and team members to understand the needs of the organization, utilize system functionalities and perform continuous data quality improvements that allow for the implementation of sophisticated BI and performance management solutions that supports the fundraising efforts individually, at Campus, Colleges, Unit level and within the University system.
- Provides assistance as needed to those participating in efforts to investigate, identify, and fulfill internal and external reporting needs.
- The ability to develop and maintain collegial working relationships and successfully work both independently and collaboratively as part of a team.
- Good attention to detail and outstanding verbal, written and interpersonal communication skills.
- Good time management and organizational skills with the ability to manage multiple ongoing tasks despite interruption.
- The flexibility to manage a large volume of work by organizing and prioritizing tasks to meet shifting priorities and deadlines.
- A proven ability to exercise professionalism and discretion in working with confidential information.
- Ability to adhere to industry guidelines, methodologies and code of ethics statements as defined by the Association for Professional Researchers in Advancement (APRA), the Association of Fundraising Professionals (AFP), the Council for Advancement and Support of Education (CASE), and other professional organizations and associations.
- Some knowledge in an area such as Advancement Services, Prospect Analysis, Business Analysis, Alumni Development, or Higher Education Fundraising Operations.
- The ability to translate operational and technical needs into complete and deliverable solutions to ensure client acceptance.
