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.
ABOUT THE BUSINESS RESOURCE CENTER
The BRC oversees King County’s business systems, which include applications, infrastructure, software, and vendor relationships. The team also supports business processes, system governance, and work prioritization to effectively serve county agencies.
BRC Director’s Office: This team provides guidance to the BRC and advises county leaders on strategies to enhance the county’s ERP business systems. They also manage the day-to-day operations of the BRC in support of continuous improvement and a cohesive team approach to govern, manage and support the county’s ERP systems.
BI Insights Team: This team specializes in developing and managing business intelligence analytics across King County’s Oracle ERP and other enterprise systems. The team collaborates closely with business partners and county departments to deliver meaningful analytics and operational reporting in support of county operations. The team is committed to expanding the use of analytics tools, improving data literacy, and enhancing ERP data governance across the county.
Financials and Procurement Team: This team specializes in Oracle EBS Financials and Procurement, Oracle Procurement Cloud and Supplier Cloud, and SAP Concur travel systems. The team collaborates with our business partners and county departments to deliver finance, procurement, travel expense and treasury services across all county business operations.
HR and Payroll System Team: This team specializes in PeopleSoft HR, payroll, and retirement systems, collaborating with our business partners and county departments to deliver HR, benefits, and payroll services across all county business operations.
Shared Services Team: This team specializes in training, change management, and help desk support, along with system security, administration, and licensing. There is also a highly skilled and technical team of DBAs who manage day-to-day running and performance of the systems in Oracle Cloud Infrastructure as well as coordination of system updates and patches.
What people have said about working in the Business Resource Center.
"The Business Resource Center provides an environment with highly diverse work groups and business partners, offering opportunities for professional growth and challenges, learning new skills and the latest technology and applications."
"Employee ideas and contributions are highly valued and supported by supervisors and managers, and employees are able to offer solutions to issues that can be brought before business partners and stakeholders."
"Employees have the freedom to manage their own workload, which is both challenging and rewarding. Work involves not only resolving issues and finding the root cause of problems but also interacting directly with business partners and experiencing the positive feedback of their appreciation."
"The job is constantly evolving, providing new professional challenges and opportunities for growth, and this comes with a supportive environment with others around you who are rooting for your success as much as their own."
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 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 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.
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.
