ERP Software Developer-Principal

About the role

The ERP Software Developer – Principal will 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.

Responsibilities

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

Requirements

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

Qualifications

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

Skills

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

Benefits

• 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: Protec17: Information Technology.

Pay

• Details on pay are not specified in the job posting.

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.
• Work schedule is flexible and may include days in the office and telecommuting.

Location

• The BRC BI Insights team works in a hybrid model, with days in the office as well as telecommuting.
• 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.

Supplemental Information

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

Application Instructions

To be considered for this opportunity, 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.