ERP Data Analyst - Instructional Support Facility

FLSA: Exempt

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

PAY GRADE: Range 8

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: Data Services Manager

SUMMARY: Provide data analysis and reporting, functional expertise, production support for the enterprise Oracle ERP system. Support stakeholders by translating business needs into IS solutions.

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.

• Develop and maintain scheduled, and ad hoc reports and queries in support of ongoing organizational needs. [Daily, 40%]
• Facilitate and monitor production operational processes performed by the IS team.  Including running reports, scheduled processes, uploads, and issue resolution. [Daily, 30%]
• Participate in production support, from troubleshooting and identification through resolution. [Daily, 10%]
• Work with team members to develop internal processes 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, 10%]
• 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.
• Information technology experience.
• Basic 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, query writing and ETL principles.
• 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.
• Ability to exercise good judgment, problem solving ability, and resourcefulness in the absence of formalized guidelines.
• Ability to work efficiently under conditions of multiple deadlines and changing priorities.
• 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 epmautomate 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.