Oracle Projects / Grants (Functional Analyst III)

Oracle Projects/Grants Functional Analyst

The King County Finance and Business Operations Department, Financial Systems and Services Team is seeking a highly skilled Oracle Projects/Grants Functional Analyst to play a pivotal role ensuring the accuracy, functionality, and efficiency of our Oracle EBS environment. 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 systems values and the opening and closing of periods for the Oracle EBS financial modules, including General Ledger, Projects/Grants, Accounts Receivable and Assets. Our team prepares reference materials, provides County agencies with training and system research, and provides support for Special Districts, including journal entries, reporting, and research.

Scope of Job Duties

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

Minimum Qualifications

• 3-5 years of experience with Oracle EBS Projects/Grants, 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.
• Identify improvement opportunities in support of financial systems. Utilize Lean/Six Sigma methodologies to effect positive change for Oracle EBS system users.
• 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

• 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

Position Information

• Work Site Details: 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. Please reach out for additional details at the contact below.
• Location Requirement: Employees must reside in Washington state and within a reasonable distance to their King County worksite to respond to workplace reporting requirements.
• Work Schedule: This position is non exempt from the provisions of the Fair Labor Standards Act and therefore 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. Multi-day vacation restrictions are in effect and Saturday work is required from mid-February to mid-April annually to support production of the financial statements
• Union Representation: This position is not represented.

King County has a robust collection of tools and resources to support working remotely. The individual selected for this opportunity will join an innovative and progressive team that is redefining how we work in our department's hybrid environment. Employees will be provided with a county-issued laptop and must maintain a home workspace with an internet connection where they can reliably perform work. Employees will need to be available and responsive during scheduled work hours and follow FBOD's hybrid/remote guidelines that include on-camera participation during virtual video meetings.

The Application/Selection Process: The recruitment for this position is open to all qualified candidates. A completed King County Application is required. Applicants from this recruitment may be used to fill future opportunities in this job classification including Term-Limited Temporary, Special Duty Assignment, Short-Term-Temporary and Career Service vacancies. We highly recommend that you provide a resume. A cover letter addressing how you meet the minimum qualifications and why you are interested in this position is encouraged as well.

The selection process consists of different phases: screening interview, virtual interview, and if successful, pre-hire reference checking. For some positions, additional phases may also include skill testing, writing samples or additional interviews. Candidates will be updated on the status of their application via the email address used to apply.

Each phase is set for a specific day. Different times will be available for those days only. Please reach out to the contact below to confirm dates. Rescheduling interviews may not be possible and may remove you from consideration if unavailable.

Note: Online applications are preferred. However, if you cannot apply online, go to for other options.

If you have any questions or concerns while applying, please contact: Michael Castro, Recruiter Email: View email address on click.appcast.io

Supplemental Information

Forbes named King County as one of Washington State's best employers.

Together, with leadership and our employees, we're changing the way government delivers service and winning national recognition as a model of excellence. Are you ready to make a difference? Come join the team dedicated to serving one of the nation's best places to live, work and play. Guided by our "True North", we are making King County a welcoming community where every person can thrive. We value diversity, inclusion and belonging in our workplace and workforce. To reach this goal we are committed to workforce equity. Equitable recruiting, support, and retention is how we will obtain the highest quality workforce in our region; a workforce that shares and will help advance our guiding principles - we are one team; we solve problems; we focus on the customer; we drive for results; we are racially just; we respect all people; we lead the way; and we are responsible stewards. We encourage people of all backgrounds and identities to apply, including Native American and people of color, immigrants, refugees, women, LGBTQ+, people living with disabilities, and veterans.

King County is an Equal Employment Opportunity (EEO) 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.

To Apply

If you are interested in pursuing this position, please follow the application instructions carefully. If you need this announcement in an alternate language or format, would like to request accommodation or assistance in the application or assessment process or if you have questions please contact the recruiter listed on this job announcement.