Junior Data Analyst

Department: DEV Advancement Services

Part/Full Time: Full Time

Advertised Job Summary

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

Preferred Qualifications

• 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.
• Previous experience with Enterprise CRM software and a familiarity with Blackbaud CRM or other higher education and/or nonprofit donor system.
• 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).

Knowledge/Skills/Abilities

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