ERP Software Developer-Principal

Overview King County Business Resource Center (BRC) is seeking an ERP Software Developer – Principal to support and enhance enterprise Oracle 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. Responsibilities Maintain, monitor, and optimize enterprise BI and data integration platforms, including Oracle Analytics Server (OAS), Oracle BI 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. Qualifications 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. 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 Details Work Schedule: This position is Exempt from the Fair Labor Standards Act and not overtime eligible. Employees are paid bi-weekly, every other Thursday. Union Representation: This position is represented by Protec17: Information Technology. Work Location: Hybrid model with days in the office and telecommuting. Primary onsite location: Chinook Building, 401 5th Avenue, Seattle, WA 98104. Employees must reside in Washington state and within a reasonable distance to respond to workplace reporting requirements. King County has a robust set of tools and resources to support working remotely. The selected candidate will join an innovative and progressive team transitioning to the department's hybrid environment. A County-issued laptop will be provided, and employees must maintain a home workspace with reliable internet access and be available during scheduled work hours. Supplemental Information The successful candidate will be required to pass a thorough background and reference check. Apply The recruitment for this position is open to all candidates. A completed King County Application is required. It is highly recommended that you provide a resume and cover letter. For questions, contact Brittney Marzest, Senior Talent Advisor, by email at View email address on click.appcast.io. This recruitment may be used to fill immediate vacancies and to create a hire list for the next 6 months, including TLTs, STTs, and CS positions. EEO Statement: King County is an Equal Employment Opportunity (EEO) employer. We encourage people of all backgrounds and identities to apply. Our EEO policy covers all employment actions and is designed to ensure workforce equity. #J-18808-Ljbffr King County