Senior ERP Application Analyst - Instructional Support Facility

FLSA: Exempt

SALARY SCHEDULE: Professional Technical | Link to https://www.cherrycreekschools.org/Page/2906

PAY GRADE: Range 9

BENEFITS: Our employee benefits package includes medical insurance, dental insurance, vision insurance, health savings accounts, flexible spending accounts, life insurance, accidental death and dismemberment, long-term disability, critical illness insurance, and accident insurance. Visit our website for full details.

SUPERVISOR: Business Information Systems Manager

ANNUAL DAYS: 230

DAILY HOURS: 8.0

ANNUAL HOURS: 1,840

LAST UPDATED: 06/15/2022

SUMMARY: Provide functional and technical expertise and production support, including application troubleshooting, development, and maintenance of workflow, security, and integrations. Coordinate projects and facilitation of improvements, enhancements, quarterly regression testing, and instance management for the enterprise Oracle ERP system.

DUTIES AND RESPONSIBILITIES: The following tasks describe the basic functions of the job and represent the type of work performed. They do not constitute an exhaustive list of the duties and responsibilities performed on the job. The following frequencies and percentage of time spent are approximations only.

• Mentor junior level analyst. [Daily, 15%]
• Participate in production support, from troubleshooting and identification through resolution. [Daily, 15%]
• Facilitate and monitor production operational processes performed by the IS team. Including running reports, scheduled processes, uploads, and issue resolution, monitor scheduled integrations and processes.[Daily, 10%]
• Develop and maintain scheduled, and ad hoc reports and queries in support of ongoing organizational needs. [Daily, 10%]
• Develop, maintain, and oversee security rules and roles. Including auto provisioning, deprovisioning, and AOR assignment. [Daily, 10%]
• Develop and maintain Oracle BPM and HCM workflows. [Daily, 10%]
• Monitor scheduled integrations and processes. [Daily, 5%]
• Responsible for instance management. Including scheduling and coordinating P2T and T2T clones and performing post cloning tasks. [Daily, 5%]
• Coordinate regression testing related to quarterly Oracle patching. Including communicating schedules, coordinating tasks and reviewing new available enhancements. [Daily, 5%]
• Work with Senior Analysts to develop internally or work with third party vendors to deploy business solutions. Integrate complex systems in multi-platform and multi-vendor environments to include transactional data collection systems, data warehouse/decision support systems, and other critical district systems. [Daily, 5%]
• Develop and maintain documentation of processes and procedures. [Daily, 5%]
• Perform other related duties as assigned or requested. [Daily, 5%]
  
  

Minimum Qualifications

• Bachelor’s degree in Information Technology or related field or equivalent training.
• Three (3) years of experience in Information Systems/Technology or related field.
• Intermediate knowledge of ERPs (Enterprise Resource Systems) and SaaS (Software as a Service) environments.
• Intermediate knowledge and experience with PL/SQL, reporting packages, databases, programming, scripting, and query writing.
• Intermediate verbal and written communication skills in English, interpersonal relations, and organizational skills.
• Ability to work independently and collaboratively with others.
• Ability to successfully communicate and maintain positive and effective relationships with all levels within an organization and facilitate understanding of processes and issues from a business perspective.
• Criminal background check and fingerprinting required for hire.
  
  

Required Certificates, Licenses, And Registrations

All certifications, licenses, and registrations must be valid and unexpired.

• N/A
  
  

Preferred Qualifications

• Experience with Oracle Cloud Fusion ERP, HCM, and EPM.
• Experience with Oracle Transactional Business Intelligence (OTBI).
• Experience with Oracle HCM Extracts and Data Loader.
• Experience with Oracle Integration Cloud (OIC) and using SOAP and REST API’s.
• Experience with Oracle Visual Builder.
• Experience with Oracle EPM Automate and EDMCS.
• Experience with Microsoft SQL Server Reporting Services (SSRS).
• Experience working directly with people from diverse racial, ethnic, and socioeconomic backgrounds.
• Racially conscious and culturally competent with the skill, will, capacity, and knowledge to commit to a culture of continuous improvement.
  
  

Physical And Mental Demands & Work Environment

• Light physical effort.
• Lifting up to ten (10) pounds.
• Sedentary work.
• Eye/hand coordination (e.g., typing, ten key).
• Visual concentration.
• Concentrated reading/writing/mathematics.
• Normal office environment.
• Occasional after-hours support required.