ERP Data Analyst - Instructional Support Facility

Cherry Creek School District; Aurora (CO); On-site; USD 55,000 - 85,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Flexible spending accounts

Job summary

Cherry Creek School District in Aurora, Colorado, seeks an IT professional to provide data analysis and reporting, along with support for the enterprise Oracle ERP system. The role involves collaborating with stakeholders to translate business needs into effective IS solutions.

Key responsibilities include developing reports, facilitating operational processes, and troubleshooting issues. Candidates should possess a Bachelor's degree in Information Technology and intermediate knowledge of PL/SQL.

Qualifications

• Bachelor’s degree in Information Technology or related field or equivalent training.
• Basic knowledge of ERPs and SaaS environments.
• Ability to work independently and collaboratively.

Responsibilities

• Develop and maintain reports and queries for organizational needs.
• Facilitate production operational processes performed by the IS team.
• Participate in troubleshooting and resolution support.

Skills

Data analysis

Oracle ERP

PL/SQL

Reporting packages

Interpersonal relations

Education

Bachelor's degree in Information Technology or related field

Tools

Oracle Cloud Fusion ERP

Oracle Transactional Business Intelligence

Microsoft SQL Server Reporting Services

Job description

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

LAST UPDATED

05/18/2022

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.