The University of South Carolina (UofSC) Division of Development needs a Junior Data Analyst to support major gift development efforts by providing data and performing analysis of donors, prospects, and alumni. This role will help translate reporting objectives into technical specifications and develop BI solutions 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.
- Some ability to identify and predict trends; communicate data results; provide in-depth and meaningful insight; and make appropriate recommendations based on results.
- Previous experience with Enterprise CRM software and a familiarity with Blackbaud CRM or other higher education and/or nonprofit donor system.
- 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.
- Ability to translate operational and technical needs into complete and deliverable solutions to ensure client acceptance.
- Some knowledge in an area such as Advancement Services, Prospect Analysis, Business Analysis, Alumni Development, or Higher Education Fundraising Operations.
Responsibilities
- Serves as a point of contact for assigned fundraising units to effectively 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 in accordance with project plans, business requirements and specifications.
- 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.
- 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.
- Assists in the 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.
- Performs testing and validation of data sets and identifies variances and elements which will require routine review.
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.
- Requires a bachelor’s degree in a job related field and 1 or more years of job related experience, which may be substituted by an equivalent combination of job related certification, training, education, and/or experience.
- 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.
