Salary: $139,552.19 - $176,890.48 Annually
Location : Chinook Building 401 5th Avenue Seattle, WA
Job Type: Career Service (Exec)
Job Number: 2026BM27152
Department: DES - Executive Services
Division: Business Resource Center
Opening Date: 06/29/2026
Closing Date: 7/20/2026 11:59 PM Pacific
FLSA: Exempt
Bargaining Unit: C19 : PROTEC17-Information Tech
Full- or Part-Time: Full Time

Summary
King County Business Resource Center (BRC) is seeking an ERP Software Developer - Principal to support and enhance enterprise Oracle Business Intelligence (BI) platforms, including OAS, OBIA, and ODI. This role provides hands-on development, system support, and optimization of ETL processes, data warehouse components, and BI reporting solutions that enable critical Finance, HR, and Procurement analytics.

Operating in a collaborative, fast-paced environment, the Technical Developer focuses on building and maintaining scalable data solutions, ensuring performance, data quality, and adherence to enterprise standards. This role works closely with analysts and technical teams to translate requirements into reliable BI solutions, support system stability, and contribute to continuous improvement of the county's analytics capabilities.
Job Duties
To be considered for this opportunity, you must at a minimum demonstrate the knowledge, skill, and ability to:

• Maintain, monitor, and optimize enterprise Business Intelligence and data integration platforms, including Oracle Analytics Server (OAS), Oracle Business Intelligence Applications (OBIA), and Oracle Data Integrator (ODI).
• Perform system administration and support for BI and ETL environments on Linux platforms, including performance tuning, troubleshooting, and configuration.
• Design, develop, and support ETL processes using ODI in alignment with enterprise data architecture standards and best practices.
• Develop and maintain Oracle Analytics dashboards, reports, and BI Publisher outputs to meet business needs.
• Perform database analysis, SQL optimization, and load testing to ensure performance, scalability, and reliability.
• Build and maintain Oracle BI Repository (RPD) / semantic models aligned with dimensional modeling principles.
• Support data warehouse development, including defining facts and dimensions and ensuring consistency across subject areas.
• Execute source control, code migration, and deployment processes following established standards.
• Conduct data profiling, validation, and quality assurance to ensure accuracy and integrity of enterprise data. '
• Collaborate with business analysts and stakeholders to translate business requirements into scalable technical solutions.

Experience, Qualifications, Knowledge, Skills
We are looking for candidates who:

• Have significant hands-on experience developing and supporting BI solutions using OBIA, OAS, and ODI.
• Demonstrate strong expertise in data warehouse concepts, including dimensional modeling and data architecture principles.
• Have advanced experience developing ETL processes using Oracle Data Integrator (ODI).
• Bring deep experience working with large Oracle data sources, including Oracle E-Business Suite (EBS) and PeopleSoft HCM.
• Have experience supporting enterprise data warehouses of approximately 1TB or larger and optimizing performance for large datasets.
• Demonstrate expertise in Oracle SQL and PL/SQL for query development and performance tuning.
• Have experience developing enterprise reporting solutions using BI Publisher, OAS, and/or Oracle Reports in a Linux environment.
• Possess hands-on experience developing and supporting OBIA modules such as HR, Financials, Procurement & Spend, and Project Analytics.
• Show strong problem-solving skills with the ability to troubleshoot complex data and system issues.
• Communicate effectively with technical and business stakeholders and collaborate across cross-functional teams.
• Familiarity with tools such as Power BI, Python, Oracle APEX, or Oracle Cloud Infrastructure (OCI) is a plus.

WORK SCHEDULE: This position is Exempt from the provisions of the Fair Labor Standards Act and therefore is not overtime eligible. Employees are paid on a bi-weekly schedule, every other Thursday.

UNION REPRESENTATION: This position is represented by Protec17: Information Technology.

WORK LOCATION: The BRC BI Insights 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 Chinook Building 401 5th Avenue 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.

King County has a robust collection of to support working remotely. The individual selected for this opportunity will join an innovative and progressive team that is redefining how we work as we transition to the 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 and remain available and responsive during scheduled work hours.

SUPPLEMENTAL INFORMATION:

• The successful candidate will be required to pass a thorough background and reference check.

Are you ready to APPLY?

The recruitment for this position is open to all candidates. A completed King County Application is required. We highly recommend that you also provide a resume and cover letter. If you have any questions, please contact Brittney Marzest, Senior Talent Advisor by e-mail at [email protected]

This recruitment is an effort to fill our immediate vacancies as well as create a hire list that will be used for any positions that become vacant within the next 6 months, including additional Term Limited Temporary (TLT), Short-term Temporary (STT) and Career Service (CS) positions.

Supplemental Information
01

Are you applying to this position as an eligible Priority Placement Program Participant who is a current or previous King County Employee impacted by layoff? ANDIs this position the same or lower percentage of full-time when compared to the position held at the point of the notification of layoff? ANDDo you possess the skills and abilities to qualify for this position?

• Yes, I was given a layoff notice from my Career Service role at King County and I am within two years of the effective date of my layoff. Additionally, the position I was laid off from was the same or a higher percentage of FT