Master Oracle Systems Analyst

POSTING TYPE: Entry-Level & Promotional

Current City Employees may apply, but must have completed initial Civil Service probationary period and must have received a satisfactory performance rating on their last evaluation to receive promotional preference.

ENTRY LEVEL SALARY: $80,306
PAY GRADE RANGE: $80,306 - $126,490 (Pay grade 321)

CIVIL SERVICE EXAM: Training & Experience Questionnaire

ESSENTIAL FUNCTIONS

Develops a close working relationship with HR, Payroll, Finance, and other functional business owners to independently address problems or requests for enhancements to Oracle Cloud ERP/HCM processes.

Performs extensive functional and technical analysis to gain a thorough understanding of Oracle Fusion ERP/HCM business process flows, configuration setups, value sets, and underlying data structures.

Communicates problems and/or solutions to Systems Analysts and Oracle technical/functional teams.

Keeps abreast of Oracle's quarterly release updates, evaluating new ERP/HCM features for adoption.

Configures and maintains role-based security, data security, and approval workflows within Oracle Fusion ERP/HCM.

Supports data loads, integrations, and conversions using File-Based Data Import (FBDI), HCM Data Loader (HDL), HCM Extracts, and REST/SOAP web services.

Identifies root causes of problems and develops solutions; implements changes through configuration, fast formulas, or coordinates resolution through Oracle Support service requests.

Builds and maintains custom reports, dashboards, and data extracts using OTBI, BI Publisher, and SQL queries against Oracle Fusion ERP/HCM tables (including job, position, assignment, and legislative/extra information tables) to fulfill user and compliance reporting needs.

Independently identifies Oracle Cloud ERP/HCM configuration, integration, or data problems; determines whether issues stem from system setup, data, or user execution.

Based on knowledge of business needs, develops validation rules, approval workflows, and alerts to aid in user operations and data quality.

Serves as project manager or team lead on Oracle Cloud ERP/HCM implementation, upgrade, and enhancement projects and design and configuration.

Independently configures, maintains, and enhances complex Oracle Fusion Cloud ERP and/or HCM modules (such as Financials, Procurement, Core HR, Absence Management, Compensation, Talent Management, or Payroll Interface).

Designs and leads complex Oracle Fusion ERP/HCM configuration projects spanning multiple modules; develops test scripts and leads functional and technical testing (unit, system integration, and user acceptance testing) for new functionality, patches, and quarterly releases.

Writes functional documentation, configuration workbooks, and end-user instructions and/or manuals.

MARGINAL FUNCTIONS

Performs related work as required.

KNOWLEDGE, SKILLS AND ABILITIES

Knowledge of Oracle Fusion Cloud ERP and/or HCM functional setup, configuration, and business processes.

Knowledge of the techniques of systems analysis as applied to Oracle Cloud ERP/HCM environments and the techniques for integrating users' needs into Oracle Cloud ERP/HCM business processes.

Knowledge of relational database structures and SQL, including querying Oracle Fusion ERP/HCM tables.

Knowledge of Oracle Cloud reporting tools, including OTBI and BI Publisher.

Knowledge of the techniques of testing programs, including functional, integration, and regression testing.

Skill in applying configuration and reporting techniques to defined functional and technical standards, and critiquing major Oracle Cloud ERP/HCM designs and configurations.

Ability to explain technical, abstract concepts to functional users and management.

Ability to learn new Oracle Cloud modules, tools, and techniques as releases evolve.

Ability to plan, monitor, and control system implementation across multiple Oracle Cloud ERP/HCM modules.

Ability to evaluate situations, make decisions, and establish and maintain effective working relationships with others.

PHYSICAL REQUIREMENTS

This position consists of primarily sedentary work, requiring the incumbent to exert up to 10 pounds of force occasionally, or a lower amount of force frequently, in order to lift/carry, push/pull or otherwise move objects. A description of the specific physical requirements associated with this position is maintained on file in the Human Resources office for review upon request.

MENTAL REQUIREMENTS

This position uses logic and/or scientific thinking to define problems, collect information, establish facts, draw valid conclusions, devise and implement policies and regulations, and to manage and coordinate multiple programs or projects. A description of the specific mental requirements associated with this position is maintained on file in the Human Resources office for review upon request.

MINIMUM REQUIREMENTS

Requires at least a Bachelor’s degree in finance, accounting, business administration, information systems, computer science, or a directly related field from a CHEA accredited college or university.

AND either

Five (5) years of progressively responsible experience as an Oracle Fusion Cloud ERP (Financials) functional or technical analyst, applications programmer, or systems analyst, including experience in SQL-based reporting and database querying. Experience with Oracle Fusion Cloud HCM is a plus.

OR

Nine (9) years of progressively responsible work experience in Oracle Fusion Cloud ERP (Financials) systems analysis, configuration, implementation, or support of a major complex computer system. Experience with Oracle Fusion Cloud HCM is a plus.

PREFERRED QUALIFICATIONS

The hiring authority may give preference to applicants with experience in the following:

• OTBI and BI Publisher reporting; writing and troubleshooting SQL queries against Oracle Fusion ERP/HCM data structures, including legislative and extra information tables.
• File-Based Data Import (FBDI) and, as a plus, HCM Data Loader (HDL) and HCM Extracts.
• Oracle Cloud security console and role-based security.
• Prior Oracle EBS Financials or PeopleSoft Financials experience.
• Oracle Cloud certifications.

HYBRID WORK ELIGIBILITY

This position is eligible for hybrid work.

Note: Background checks will be conducted.

Drug testing may be required.