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

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