Senior Business Data Analyst

Senior Business Data Analyst Apply for this job

Position Number:

7141964

Location:

Kennesaw, GA

Position Type:

Business•

Information Systems and Technology 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 USG Core Values The University System of Georgia is comprised of our 25 institutions of higher education and learning as well as the System Office. Our USG Statement of Core Values are Integrity, Excellence, Accountability, and Respect. These values serve as the foundation for all that we do as an organization, and each USG community member is responsible for demonstrating and upholding these standards. More details on the USG Statement of Core Values and Code of Conduct are available in USG Board Policy 8.2.18.1.2 and can be found on-line at https://www.usg.edu/policymanual/section8/C224/#p8.2.18_personnel_conduct. Additionally, USG supports Freedom of Expression as stated in Board Policy 6.5 Freedom of Expression and Academic Freedom found on-line at https://www.usg.edu/policymanual/section6/C2653. Equal Employment Opportunity Kennesaw State University is an Equal Employment Opportunity Employer. The University is committed to maintaining a fair and respectful environment for living, work and study. To that end, and in accordance with federal and state law, Board of Regents policy, and University policy, the University prohibits harassment of or discrimination against any person because of race, color, sex (including sexual harassment, pregnancy, and medical conditions related to pregnancy), sexual orientation, gender identity, gender expression, ethnicity or national origin, religion, age, genetic information, disability, or veteran or military status by any member of the KSU Community on campus, in connection with a University program or activity, or in a manner that creates a hostile environment for members of the KSU community. For additional information on this policy, or to file a complaint under the provisions of this policy, students, employees, applicants for employment or admission or other third parties should contact the Office of Institutional Equity at English Building, Suite 225, eeo@kennesaw.edu. Other Information This is not a supervisory position. This position does not have any financial responsibilities. This position will not be required to drive. This role is not considered a position of trust. This position does not require a purchasing card (P-Card). This position may travel 1%

• 24% of the time Background Check Standard Enhanced Education Per the University System of Georgia background check policy, all final candidates will be required to consent to a criminal background investigation.

Final candidates may be asked to disclose criminal record history during the initial screening process and prior to a conditional offer of employment. Applicants for positions of trust with screening results which confirm a disqualifying criminal history will be immediately disqualified from employment eligibility. All applicants are required to include professional references as part of their application process. Some positions may require additional job-based screenings such as motor vehicle report, credit check, pre-employment drug screening and/or verification of academic credentials.

https:

//www.usg.edu/hr/assets/hr/hrap_manual/HRAP_Background_Investigation_Employment.pdf