Master Oracle Systems Analyst City of Knoxville Knoxville, TN Job Details Full-time $80,306 - $128,490 a year 3 days ago Benefits 457(b) Paid holidays Health insurance Dental insurance Flexible spending account Tuition reimbursement Paid time off Pension plan Employee assistance program Vision insurance Flexible schedule Retirement plan Qualifications Computer Science SQL Bachelor's degree Business Administration Query management Business Oracle Cloud Oracle Enterprise Resource Planning (ERP) Full Job Description

MASTER ORACLE SYSTEMS ANALYST

City of Knoxville, Tennessee https://www.knoxvilletn.

gov/jobs Job type:

Full-Time Deadline:

October 2nd, 2026

PAY RANGE:

$80,306- $128,490

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.

Minimum Qualifications:

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:

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 This position is eligible for hybrid work.

City of Knoxville Employee 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 For more benefits information, visit this link: https://www.knoxvilletn.gov/government/city_departments_offices/employee_benefits

Job Type:

Full-time Pay:

$80,306.00 - $128,490.00 per year

Benefits:

Dental insurance Employee assistance program Flexible schedule Flexible spending account Health insurance Paid time off Retirement plan Tuition reimbursement Vision insurance Ability to

Commute:

Knoxville, TN 37902 (Preferred) Ability to

Relocate:

Knoxville, TN 37902: Relocate before starting work (Preferred)

Work Location:

In person