Senior Business Data Analyst

Job Details

Senior Business Data Analyst
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:

1. Develops queries, exports, reports and data deliverables using Blackbaud RENXT or current CRM, Power BI, MS Access, SQL, and MS Office tools
2. 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
3. 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
4. Provides administrative maintenance and support for online giving pages, online transactions, and crowdfunding solutions
5. 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))
6. 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*:

1. Compiles standard and ad hoc reports per established guidelines and frequency
2. Provides reports, analysis and data interpretation for all assigned departments
3. Provides leadership and development to data analysts
4. Identifies areas of opportunity and presents findings and recommendations to leadership and stakeholders
5. Provides productivity, labor and occupancy analysis reports
6. Develops and maintains reports to measure activity, sales and/or service utilization
7. Prepares annual reports required of association affiliations and/or oversight requirements
8. Compiles monthly operational review that includes trend analysis
9. Assists with assigned inventory reporting and analysis
10. Provides event reporting that assists with measuring performance and effectiveness
11. Collaborate with a variety of stakeholders across campus, including working closely with the Office of University Data Strategy to maintain alignment with overall university data strategy

Required Qualifications Educational Requirements Bachelor's degree from an accredited institution of higher education in related field Required Experience Three (3) years of related work experience Preferred Qualifications Additional Preferred Qualifications Certificate in Data Analytics Preferred Educational Qualifications An advanced degree from an accredited institution of higher education in a related field Knowledge, Skills, & Abilities ABILITIES Able to utilize multiple SQL based software modules Able to handle multiple tasks or projects at one time meeting assigned deadlines KNOWLEDGE Knowledge of SAS and/or other data management software SKILLS Excellent interpersonal, initiative, teamwork, problem solving, independent judgment, organization, communication (verbal and written), time management, project management and presentation skills Proficient with computer applications and programs associated with the position (i.e., Microsoft Office suite) Proficient with the use of Excel pivot tables and data manipulation Strong data visualization skills Strong attention to detail and follow up skills Strong customer service skills and phone and e-mail etiquette