Job Description
Job ID: 298049 Location: Kennesaw, Georgia Full/Part Time: Full Time Regular/Temporary: Regular About Us Are you ready to transform lives through academic excellence, innovative research, strong community partnerships and economic opportunity? Kennesaw State University is one of the 50 largest public institutions in the country. With growing enrollment and global reach, we continue to expand our institutional influence and prominence beyond the state of Georgia. We offer more than 190 undergraduate, graduate, and doctoral degrees to empower over 50,000 students to become thought leaders, lifelong learners, and informed global citizens. Our entrepreneurial spirit, high-impact research, and Division I athletics draw students from throughout the region and from more than 100 countries across the globe. Our university's vibrant culture, career opportunities, rich benefits, and values of respect, integrity, collaboration, inclusivity, and accountability make us an employer of choice. We are part of the University System of Georgia. We are searching for talented people to join Kennesaw State University in our vision. Come Take Flight at KSU! Location (Primary Location for Job Responsibilities) Our Kennesaw campus is located at 1000 Chastain Road NW, Kennesaw, GA 30144. Our Marietta campus is located at 1100 South Marietta Parkway, Marietta, GA 30060. Department Information Department Specific Tasks And Responsibilities Develops queries, exports, reports and data deliverables using Blackbaud RENXT or current CRM, Power BI, MS Access, SQL, and MS Office tools Assist with data integrity across all advancement and affiliated systems, including Raiser's Edge NXT, Fundraiser Performance Manager, Salesforce Marketing Cloud, Give Smart, Give Campus and other software programs or spreadsheets Analyze and transform data to conform in order to run global uploads of data to our donor and alumni database from other software programs or spreadsheets Provides administrative maintenance and support for online giving pages, online transactions, and crowdfunding solutions Assists in the development of dashboards, analytics, reports, and visualizations to provide actionable insights on fundraising progress, forecasting, alumni engagement success, and respective analyses related to these areas (using Power BI, Power Query, Power Pivot and Data Analysis Expressions (DAX)) Serves as the primary back up for gift entry processing, batch posting, producing acknowledgements and receipts DEPARTMENT SPECIFIC KNOWLEDGE, SKILLS, AND ABILITIES*: Experience with business intelligence and analysis tools such as Power BI, Power Query, and DAX Strong understanding of industry terms, definitions, and information processing as they pertain to fundraising, gift recording, prospect development, and alumni engagement especially in a higher-education environment Understanding of higher-educational foundation operational needs, especially those associated with charitable donations, gift processing, fiscal reconciliation, fund balances, and revenue forecasting Good understanding of CRMs, data frameworks, and platforms which support non-profits Ability to understand and retain regulations and guidelines as they pertain to charitable giving Ability to maintain high attention to detail, capacity for retaining a large set of instructions and procedural steps Job Summary Leads and guides the business data analyst team, data analysis and reporting for all assigned departments. Coordinates with departments and other University stakeholders to gather data, analyze trends, develop graphs and generate operational and financial reports, including but not limited to daily sales reports, report interpretation and trend analysis. Coordinates proactive problem identification and resolution through data collection, upgrade reports and interpretation. Collaborates with others to create, analyze and interpret reports to make data driven recommendations to leadership for quantitative business decisions. Responsibilities KEY RESPONSIBILITIES*: Compiles standard and ad hoc reports per established guidelines and frequency Provides reports, analysis and data interpretation for all assigned departments Provides leadership and development to data analysts Identifies areas of opportunity and presents findings and recommendations to leadership and stakeholders Provides productivity, labor and occupancy analysis reports Develops and maintains reports to measure activity, sales and/or service utiliz