Oracle BI/Data Warehouse Developer

Salary: £63,000 - 103,000 per year

Requirements:

• Strong understanding of data warehousing concepts, dimensional modeling, and enterprise data structures that support business intelligence and reporting.
• Advanced SQL skills and hands-on experience with Oracle relational databases.
• Experience working with BI and analytics tools, with a preference for Oracle Analytics Server (OAS), Oracle Analytics Cloud (OAC), or Oracle BI Publisher.
• Analytical mindset with strong problem-solving abilities and experience diagnosing and resolving reporting, metadata, dashboard, and data issues.
• Attention to detail and a commitment to data quality, ensuring reliable, trusted insights for stakeholders.
• Ability to translate business requirements into effective technical solutions, with a strong understanding of how data enables business outcomes.
• Knowledge of Oracle E-Business Suite (EBS) modules—including Projects, HRMS, GL, FA, AP, AR, PO—and their data structures or integrations is considered an asset.
• Strong communication and collaboration skills, with the ability to work effectively with business users, technical teams, and leadership.
• Experience working in Agile environments and contributing to iterative development cycles is preferred.
• 8+ years of application or data solution development experience, ideally in enterprise environments.
• Bachelors degree or equivalent experience in Computer Science, Information Systems, Engineering, or a related field.

Responsibilities:

• 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.
• 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), Oracle Analytics Cloud (OAC), Oracle BI Repository (RPD) metadata modeling, BI dashboards, analyses, catalog objects, subject areas, and enterprise data warehouse subject areas.
• Assess and document the impact of enhancements and customizations.
• Participate in code reviews and planning sessions.
• Ensure alignment with enterprise architecture and integration patterns.
• Support BI solution configuration, dashboard optimization, and report performance improvements.
• Develop SQL queries, reporting logic, and BI solutions to support business reporting requirements.
• Develop and maintain Oracle BI Repository (RPD) metadata models, logical business models, Presentation Layer objects, dashboards, analyses, and reporting solutions.
• Ensure data quality through thorough testing and validation of new or updated analytical subject areas.
• Utilize dimensional and relational data models to develop effective reporting and analytics solutions.
• Create summarization, aggregation, and reporting logic for high-volume datasets.
• Engage with cross-functional work teams, including Finance, HR, Projects, and other groups, to enhance understanding of BI subject areas.
• Analyze and troubleshoot tool, data, and access issues by collaborating with the Support Management team.
• Manage stakeholder expectations about what can and cannot be incorporated into BI subject areas and help stakeholders make effective use of the presentation layer.
• Enforce data governance policies, ensuring compliance with data privacy regulations and implementing application roles or LDAP groups to control access to the dashboards.
• Support implementation of application roles, LDAP groups, and row-level security to ensure users access only authorized information.
• Develop standards and best practices for BI reporting solutions, dashboards, RPD metadata, and analytical content.
• Document BI reporting solutions, metadata models, and reporting standards to support maintainability and knowledge sharing.
• Analyze and improve dashboard, report, and metadata performance to provide an optimal user experience.
• Identify opportunities to improve or extend frameworks and standards.
• Participate in code reviews.
• Support programming policies, procedures, and quality assurance best practices as they relate to business intelligence.

Technologies:

• Business Intelligence
• Cloud
• Data Warehouse
• Support
• LDAP
• Marketing
• Oracle
• SQL
• Security
• DevOps

More:

We are Stantec, and our business teams include finance, procurement, human resources, information technology, marketing, corporate development, HSSE, real estate, legal, and practice services. We foster a caring culture where everyone can thrive, and through teamwork and collaboration we are building a stronger, more resilient Stantec every day. This role is part of our Enterprise Dashboard and Reporting Solutions (EDRS) team and is based in Canada, AB, Edmonton. It is a regular full-time position with full-time schedule and no travel. We offer a benefits package for regular full-time and part-time employees working at least 20 hours per week, including health, dental, and vision plans, wellness programs, retirement savings, stock purchase options, insurance, disability coverage, travel benefits, tuition reimbursement, professional membership fee coverage, and paid time off.

last updated 36 week of 2026