Oracle Projects / Grants (Functional Analyst III)

Summary The 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. The analyst 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. Responsibilities also include supporting system testing, documentation, data analysis, and user education to translate technical functionality into clear processes and empower users through effective training. Scope of Job Duties Oversee daily functional performance of Oracle Projects module and 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, validating custom reports, interfaces, and extensions to ensure accuracy of project costing and billing data. Analyze, monitor, and perform system tests and data queries. Identify improvement opportunities in support of financial systems and 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 designing, developing, and delivering 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. Minimum Qualifications 3–5 years of experience with Oracle EBS Projects/Grants, General Ledger, and Accounts Receivable, including understanding system interfaces between these modules and how entries are created. Experience troubleshooting system issues and resolving problems in project costing, billing, revenue, and integrations. Strong analytical and critical thinking skills and experience gathering, manipulating, validating, and using data from multiple sources with a variety of tools. Experience developing technical and operational written procedures. Excellent communication, interpersonal, writing, and customer service skills. Intermediate proficiency with MS Office Productivity tools. Ability to manage time and adapt to changing priorities, working on multiple projects simultaneously with quick turnaround. Ability to work with people from diverse backgrounds. Preferred Qualifications Project management experience with system enhancements or changes. Financial accounting knowledge. Data analytics and SQL report development experience. Experience with Lean processes and principles. Experience with SharePoint, MS Teams, and other collaborative online tools. Position Information Work Site Details: Hybrid model with days in office and telecommuting; primary onsite location is King Street Center, 201 S. Jackson, Seattle, WA 98104. Location Requirement: Employees must reside in Washington state and within a reasonable distance to the worksite. Work Schedule: Non-exempt, hourly, 40‑hour week, Monday‑Friday, 8:00 a.m.–5:00 p.m.; overtime eligible. Union Representation: Not represented. Benefits Medical, dental, and vision coverage options. Life and disability insurance. Retirement: pension plan via Washington State Department of Retirement Systems and a 457(b) deferred‑compensation plan. Transportation program and ORCA transit pass. 12 paid holidays each year plus two personal holidays. Generous vacation and paid sick leave. Paid parental, family, medical, and volunteer leaves. Flexible Spending Account. Wellness programs and employee assistance programs. Onsite activity centers and employee giving program. Flexible schedules and telecommuting options, depending on the position. Training and career development programs. Equal Employment Opportunity (EEO) Employer King County is an Equal Employment Opportunity Employer. No person is unlawfully excluded from employment opportunities based on race, color, religion, national origin, sex (including gender identity, sexual orientation and pregnancy), age, genetic information, disability, veteran status, or other protected class. Our EEO policy applies to all employment actions, including but not limited to recruitment, hiring, selection for training, promotion, transfer, demotion, layoff, termination, rates of pay or other forms of compensation. #J-18808-Ljbffr King County, WA