Oracle Financial Systems Functional Analyst (III)

King County Finance and Business Operations Department, Financial Systems and Services Team is seeking a highly skilled Oracle Projects/Grants Functional Analyst to ensure the accuracy, functionality, and efficiency of our Oracle EBS environment.

About the role

In this position, you will lead the definition and refinement of business requirements, enhance project accounting processes, troubleshoot complex functional issues across integrated modules, and drive continuous improvement using Lean and Six Sigma methodologies. You will also support system testing, documentation, data analysis, and user education, making this an ideal opportunity for a detail-oriented problem solver who excels at translating technical functionality into clear processes and empowering others through effective training.

The Financial Systems and Services Team supports the County's Oracle EBS financial system, including monitoring and processing system interfaces and imports, maintaining system values, and opening and closing periods for Oracle EBS financial modules such as General Ledger, Projects/Grants, Accounts Receivable, and Assets. The team prepares reference materials, provides training and system research for County agencies, and supports Special Districts with journal entries, reporting, and research.

Responsibilities

• Oversee daily functional performance of Oracle Projects module.
• Troubleshoot issues related to expenditure processing, cost distribution, billing events, revenue generation, and integrations with AP, AR, GL, PO, and PeopleSoft.
• Serve as the functional escalation point for complex project accounting issues and document resolutions for knowledge sharing.
• Configure Oracle Projects components such as project templates, burden schedules, and expenditure types.
• Define, refine, and document business requirements related to Oracle Projects modules, including project setup, costing, billing, revenue recognition, agreements, and funding.
• Develop and execute test scripts for patches, upgrades, and enhancements. Validate custom reports, interfaces, and extensions to ensure accuracy of project costing and billing data.
• Analyze, monitor, and test system functionality and perform system analysis and data queries.
• Identify improvement opportunities in support of financial systems. Utilize Lean/Six Sigma methodologies to effect positive change for Oracle EBS system users.
• Document and revise standard procedures and flow charts for processes within the Oracle EBS financial modules.
• Assist in the design, development, and delivery of educational curriculum for Projects/Grants modules, Oracle EBS General Ledger, and Accounts Receivable modules and related business processes.
• Evaluate current project accounting processes and recommend improvements aligned with Oracle best practices.

Requirements

• 3-5 years of experience with Oracle EBS General Ledger and Accounts Receivable. Understanding system interfaces between these modules and how entries are created.
• Experience troubleshooting system issues and resolving issues in project costing, billing, revenue, and integrations.
• Analytical and critical thinking skills, as well as skills in gathering, manipulating, validating, and using data from multiple sources with a variety of tools.
• Experience developing technical and operational written procedures.
• Strong communication, interpersonal, writing, and customer service skills.
• Intermediate level of technology proficiency using MS Office Productivity tools in your daily work.
• Ability to manage your time and adapt to changing priorities, work on multiple priorities and projects simultaneously, meet quick deadlines, and produce timely and quality work products.
• Ability to work with people from diverse backgrounds.

Preferred Qualifications

• Experience with the Oracle Projects module including billing/revenue generation, expenditure processing, and system integrations.
• Project management experience with system enhancements or changes.
• Financial Accounting knowledge.
• Data Analytics & SQL Report Development experience.
• Experience with LEAN processes and principles.
• Experience with SharePoint, MS Teams, and other collaborative online tools.

Schedule

This position is non-exempt from the provisions of the Fair Labor Standards Act and is overtime eligible. Employees are paid on a bi-weekly schedule, every other Thursday, comprising a 40-hour workweek; normally 8:00 a.m. - 5:00 p.m. Monday through Friday.

The team works in a hybrid model, with days in the office as well as telecommuting. The ratio of remote to onsite work will be dependent on business needs and is subject to change. The primary onsite location is King Street Center, 201 S. Jackson, Seattle, Washington 98104.

Employees must reside in Washington state and within a reasonable distance to their King County worksite to respond to workplace reporting requirements.