Address
Form of workLocation: Kennesaw, Georgia
Regular/Temporary: Regular
Full/Part Time: Full-Time
Job ID: 270785
About Us
Are you ready to join a community leading in innovative teaching and learning? Kennesaw State University is one of the 50 largest public institutions in the country. With our growing enrollment and global reach, we are enjoying increased prominence among Georgia's colleges. We offer more than 150 undergraduate, graduate, and doctoral degrees to over 43,000 students. Our entrepreneurial spirit, high-impact research, and Division I athletics also draw students from throughout the region and from 92 countries across the globe. Our university's vibrant culture, career opportunities, mission and values and rich benefits make us an employer of choice. We are part of the University System of Georgia. Kennesaw State will exemplify the power and promise of a student-centered, research-driven university. Our institutional values are student-inspired, promise-fulfilling, true to ourselves, elevational, open and impact-generating. In addition, we support the University System of Georgia core values of accountability, excellence, integrity and respect. We are searching for talented people to join Kennesaw State University. Come to KSU and find your passion.
LocationOur Kennesaw campus is located at 1000 Chastain Road NW, Kennesaw, GA 30144.
Job SummaryDevelops 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.
ResponsibilitiesKEY 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 can be assessed 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
Educational Requirements
MINIMUM EDUCATION AND EXPERIENCE REQUIREMENTS:
Bachelor's Degree from an accredited institution of higher education in Computer Science, Business, Finance, Accounting, Information Systems, Engineering and five (5) years of experience in Business, Finance, Accounting, information Technology or Systems Analysis, to include one (1) year of SQL experience.
OR
Master's Degree from an accredited institution of higher education in Computer Science, Business, Finance, Accounting, Information Systems, Engineering, or related field and three (3) years of experience in Business, Finance, Accounting, Information Technology or Systems Analysis, to include one (1) year of SQL experience.
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 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
The salary rage for this position is between $65,400and $83,400. Offers will be based on candidate experience and budget availability.
Knowledge, Skills, & AbilitiesABILITIES
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
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 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.
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.
- 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
