Oracle BI/Data Warehouse Developer

Your Opportunity

We are seeking an Oracle BI/Data Warehouse Developer with strong experience across the Oracle analytics and reporting ecosystem. This role focuses on translating business needs into practical intelligence solutions through business analysis, SQL, dimensional data understanding, report development, dashboard support, Oracle BI Repository (RPD) modeling, and effective use of Oracle BI tools. As a core member of Stantec's Enterprise Dashboard and Reporting Solutions (EDRS) team, you will help deliver and maintain trusted analytics, reporting content, BI subject areas, and catalog objects that support enterprise decision-making. The successful candidate will work closely with business stakeholders and technical teams to improve reporting solutions, troubleshoot data and access issues, and ensure RPD metadata, presentation layers, and BI subject areas are reliable, usable, and aligned with business needs.

Key Responsibilities

Report Development and DevOps

•           Design, develop, and maintain reports, dashboards, analyses, and BI catalog objects using Oracle Analytics Server (OAS) and Oracle Analytics Cloud (OAC). 

•           Translate business requirements into intuitive reporting and visualization solutions. 

•           Perform impact assessments and provide effort estimates for reporting enhancements. 

•           Perform unit testing and integrated testing of BI solutions. 

•           Document BI reporting solutions and technical specifications. 

•           Support production reporting applications and troubleshoot reporting, metadata, and access issues. 

•           Promote reporting standards and visualization best practices. 

•           Develop ad hoc reports using Oracle reporting tools such as BI Publisher.

•           Develop and maintain BI reporting standards, dashboard standards, and Oracle BI metadata (RPD) best practices.

•           Provide regular updates and communications on development and operational support activities, including status updates and priorities.

Architecture

•           Provide subject matter expertise and support the creation of architectural and technical deliverables.

•           Design, develop, and implement data warehouse and BI report solutions leveraging: 

•           Oracle Analytics Server (OAS) and Oracle Analytics Cloud (OAC)

•           Oracle BI Repository (RPD) metadata modeling, including Physical, Business Model & Mapping (BMM), and Presentation Layers

•           BI dashboards, analyses, catalog objects, and subject areas