Senior Business Analyst, Finance

Kennesaw State University; Kennesaw (GA); On-site; USD 85,000 - 110,000; Full time

Job summary

Kennesaw State University seeks a Senior Business Analyst, Finance to design and implement reporting solutions supporting university stakeholders. The role develops dashboards, trains users, and ensures data integrity across financial systems.

Responsibilities include creating SQL scripts for the Oracle data warehouse, interfacing with clients, and leading data visualization initiatives using Tableau, SAS, and Power BI. Collaboration and problem solving are key in this role.

Qualifications

• Master's degree from an accredited institution in Business, Finance, Accounting, Information Systems or related field or equivalent combination of education/experience.
• Three (3) years' experience in Business, Finance, Accounting, IT or Systems Analysis.
• Certification in SQL, data analytics, or similar certification preferred.

Responsibilities

• Designs, builds, and maintains SQL scripts and procedures in an Oracle financial data warehouse.
• Interfaces with clients to define processes, reporting needs, and requirements.
• Develops reports, visualizations, and dashboards for stakeholders and business users.
• Executes test plans to ensure outcomes meet requirements.
• Delivers end-user training programs and training materials.
• Documents complex processes and implements improvements as applicable.
• Leads meetings with end users to clarify issues and gather requirements.
• Prioritizes and resolves problems based on business needs and impact.
• Presents data resolution findings with recommendations.
• Leads finance users on data visualization and reporting solutions to identify needs.
• Provides support for operational and technical processes and system changes.
• Acts as primary contact for USG to open tickets and facilitate resolutions.
• Ensures financial data integrity.

Skills

SQL

Data analytics

Communication

Project management

Teamwork

Training

Education

Master's degree in Business/Finance/Accounting/IS

Tools

Tableau

SAS

Power BI

Tableau Server

Oracle databases

SQL tooling

SAS Enterprise Guide

SharePoint

Job description

Senior Business Analyst, Finance

Job ID: 303301

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.

Job Summary

Develops reporting solutions to satisfy and support University stakeholders, supports financial applications, and delivers training on financial systems. Monitors and improves the quality of various technical and functional business processes, identifies, and resolves data issues. Responsibilities include collecting requirements, developing reports and dashboards, testing, implementation of new or upgrading software applications, leading process improvements, and training to support the objectives of the Institution.

Responsibilities

KEY RESPONSIBILITIES:

• 1. Designs, builds, implements, and maintains Oracle Structural Query Language (SQL) scripts and procedures in Oracle financial data warehouse
• 2. Interfaces with clients to define business processes, specifications, reporting needs, and functional requirements
• 3. Develop reports, visualizations, and dashboards that present data in a way that is assessable and easily navigated by stakeholders and business users
• 4. Devises and executes test plans to ensure that the outcome meets the specified requirements and expectations of business users
• 5. Delivers quality end-user training programs, reinforcing technology and operations infrastructure to ensure effective and efficient use of the systems to achieve campus goals
• 6. Performs training needs analysis, develops training programs and manuals, initiates, and oversees training systems
• 7. Documents complex system processes, functionality and implements improvements as applicable
• 8. Leads meetings with end users to clarify issues, gather requirements, and resolve requests
• 9. Prioritizes and executes problem resolution based on business need, timelines, and scale of impact
• 10. Presents data resolution findings to relevant stakeholders with recommendations to ensure business needs are met
• 11. Leads finance users on current and future data visualization and reporting solutions to identify customer needs
• 12. Provides support for operational and technical processes, and system changes and proactively searches for improvement opportunities
• 13. Primary support point of contact for USG to open tickets and facilitate resolutions
• 14. Approves content on the department and/or division webpage under direction of leadership
• 15. Maintains financial data integrity

Required Qualifications

Educational Requirements

Master's degree from an accredited institution of higher education in Business, Finance, Accounting, Information Systems or related field or an equivalent combination of education and/or experience.

Required Experience

Three (3) years previous experience in Business, Finance, Accounting, Information Technology or Systems Analysis.

Preferred Qualifications

Additional Preferred Qualifications

Certification in SQL, data analytics or similar relevant certification

Working knowledge of fund accounting, budget, and finance

Strong IT and Financial skills

Preferred Educational Qualifications

An advanced degree from an accredited institution of higher education in Business, Finance, Accounting, Information Systems or related field

Preferred Experience

Experience with reporting and/or query tools and coding in software, databases, and/or programs such as Tableau, SAS, SAS Enterprise Guide, Oracle Databases, and/or SQL (or gathering data from other related database systems)

Extensive experience in data analysis, dashboards, analytics and decision support systems

Knowledge, Skills, & Abilities

ABILITIES

• Able to apply a working knowledge of SQL in relational database environments (i.e., Oracle)
• Able to utilize multiple SQL based software modules
• Subject matter expert for the PeopleSoft eProcurement administrator responsibilities
• Subject matter expert in assisting team members with responses to electronic ticketing system
• Able to support and utilize enterprise financial systems
• Able to create and deliver end-user training programs, jobs aids and manuals
• Able to work as part of a team with a collaborative approach to problem solving
• Able to communicate complex financial and technical concepts to the end-users
• Able to work autonomously and with managers to ensure business requirements and needs are met
• Able to conduct research for special projects, respond timely to inquiries, and present written and oral briefings
• Able to handle multiple tasks or projects at one time meeting assigned deadlines

KNOWLEDGE

• Working knowledge of relational databases
• Working knowledge of data management software such as SAS
• Understanding of database concepts such as schemas and data relationships
• Working knowledge of Oracle PeopleSoft or ERP system principles, concepts, methodology and Advanced knowledge of and experience working in data visualization tools (i.e., SAS, Power BI, Tableau, etc.) and SharePoint
• Familiar with API concepts such as web services

SKILLS

• Excellent interpersonal, initiative, teamwork, problem solving, independent judgment, organization, communication (verbal and written), time management, project management and presentation skills
• Polished and professional demeanor
• Proficient with computer applications and programs associated with the position (i.e., Microsoft Office suite)
• Self-motivated with the ability to learn new concepts quickly
• 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, [e-mail].

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

• Credit Report
• 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