Senior Business Analyst, Finance

Job Title Reporting Solutions Developer Location Kennesaw, Georgia 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. 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. 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. Kennesaw State University