Jobs · Information Technology · Tennessee

Master Oracle Systems Analyst

City of Knoxville · Knoxville, TN · 3 wk ago
On-siteInformation Technology$80k–$128k/yrFull-time

Responsibilities

  • 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.

Qualifications

Minimum Qualifications:

  • 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:

  • 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.

Benefits

  • Health plan
  • Dental plan
  • Vision plan
  • "The Center" - in-house health & wellness center
  • Pension plan
  • 457b deferred compensation plan
  • Employee Assistance Program (EAP)
  • 11 paid holidays
  • Annual & sick leave

Pay

$80,3

Similar jobs