Find work in Canada.

500,675 jobs across our Canadian network. How we count

Jobs in Canada

Email me new jobs Save this search

Added 1 month ago
B
IT Major Incident Manager
Bombardier
Dorval, QC
- Internship
You have a Bachelor Degree in Engineering, Computer Science, or relevant technical discipline.
Added 1 month ago
S
Refinery Operator - Breslau
Safety-Kleen
Breslau, ON
- $37 to $44 CAD / hour
- Full-time
High School + specialized training or 1 year college: science/ engineering/ related technical field.
Added 1 month ago
VB
Stobie Open Pit - Heavy Duty Equipment Technician
Vale Base Metals
Sudbury, ON · Greater Sudbury, ON
- Full-time
Inspect, diagnose, adjust, repair, assemble, replace and test internal combustion, electric mobile equipment, and electric/hydraulic production equipment and related systems.
Added 1 month ago
A-
Red Seal Millwright
AGI - Ag Growth International
Winnipeg, MB
- Full-time
…agricultural commodities including seed, fertilizer, grain and feed systems and an expanding platform for food processing…
Added 2 months ago
S
Mechanical Technical Director
Stantec
Montreal, QC
- Full-time
Over 15 years of experience in mechanical engineering, including institutional projects in the fields of plumbing, ventilation, and other complex mechanical systems;
Added 2 months ago
S
Mechanical Technical Director
Stantec
Laval, QC
- Full-time
Over 15 years of experience in mechanical engineering, including institutional projects in the fields of plumbing, ventilation, and other complex mechanical systems;
Added 2 months ago
S
Mechanical Technical Director
Stantec
Longueuil, QC
- Full-time
Over 15 years of experience in mechanical engineering, including institutional projects in the fields of plumbing, ventilation, and other complex mechanical systems;
Added 2 months ago
IC
Contractor Management Specialist- EN
IAMGOLD Corporation
Gogama, ON
- Contract
Document Control & Systems Management: Ability to manage structured workflows, maintain accurate records, and ensure audit readines
Added 2 months ago
S
Principal Mechanical Engineer, Health Sector
Stantec
Toronto, ON
- Full-time
Technical understanding of Mechanical Engineering for health facilities, with direct design experience in HVAC, Plumbing, Medical Gas and/or Fire Suppression systems.
Added 2 months ago
S
Physical Security Engineer
Stantec
Ottawa, ON
- Full-time
…increasing responsibilities and/or be responsible for leading engineering activities related to the implementation of security systems for large-scale projects serving private, municipal,…
Added 2 months ago
S
Senior Instrumentation & Controls Engineer- Water
Stantec
Ottawa, ON
- Full-time
…private-sector clients. Primary duties will include control systems engineering, process control strategy planning, automation designs, construction support services, and planning studies…
Added 1 month ago
C
Staff Software Engineer, Fullstack
Cloudjobs
Toronto, ON
- Full-time
…moves, through every transformation, to the context teams and AI systems rely on. Fivetran helps organizations automate data movement across the systems, clouds, engines, and tools they…
Added 1 month ago
SH
Locksmith (Re-post)
Scarborough Health Network
Toronto, ON · Scarborough, ON
- Full-time
…maintains, repairs and opens manual and automated locks, locking systems and security devices, computerized access control systems, door openers and hardware. The locksmith also cuts keys…
Added 1 month ago
Manager, Development Engineering (Water and Wastewater)
Region of Waterloo
Kitchener, ON
Department: Development and Distribution Engineering
Added 1 month ago
Machine Learning Engineer
ALS
Montreal, QC · CAN - QC - Montreal (Rue Saint-Nicolas)
Added 2 months ago
S
Senior Instrumentation & Controls Engineer- Water
Stantec
Burnaby, BC
- Full-time
…private-sector clients. Primary duties will include control systems engineering, process control strategy planning, automation designs, construction support services, and planning studies…
Added 2 months ago
S
Senior Geotechnical Engineer (Mining)
Stantec
Montreal, QC
- Full-time
Build the foundation for a successful career in geotechnical engineering with a great team. When we say we’re full-service, we mean it. You’ll find us in the office, on site, and in the…
Added 1 month ago
Solution Delivery Manager
Rogers Communications
Toronto, ON
Work closely with cross-functional teams including product development, engineering, marketing, and sales to understand customer needs and identify opportunities for digital solutions that…
Added 1 month ago
SE
Senior Software Engineer
Soma Energy
Remote, Canada
- Full-time
- Remote
…that would double our footprint over the next six months. The systems that got us here now have to carry twice the load. We need engineers to build what carries us to the next…
Added 2 months ago
S
Senior Instrumentation & Controls Engineer- Water
Stantec
Winnipeg, MB
- Full-time
…private-sector clients. Primary duties will include control systems engineering, process control strategy planning, automation designs, construction support services, and planning studies…
Added 2 months ago
S
Oracle BI/Data Warehouse Developer
Stantec
Edmonton, AB
- Full-time
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…
Added 1 month ago
CW
Supply Chain Manager
Colas Western Canada Inc.
St. Albert, AB
- Full-time
Digital Procurement, Systems & Coupa Leadership
Added 1 month ago
J
Staff Data Engineer
Jobber
Edmonton, AB
- Full-time
…technologies, addressing technical debt, and investing in the future of engineering at Jobber. This is a highly strategic and hands-on position where you’ll combine deep technical expertise…
Added 1 month ago
J
Staff Data Engineer
Jobber
Kitchener, ON
- Full-time
…technologies, addressing technical debt, and investing in the future of engineering at Jobber. This is a highly strategic and hands-on position where you’ll combine deep technical expertise…
Added 1 month ago
J
Staff Data Engineer
Jobber
Vancouver, BC
- Full-time
…technologies, addressing technical debt, and investing in the future of engineering at Jobber. This is a highly strategic and hands-on position where you’ll combine deep technical expertise…

Stantec

Oracle BI/Data Warehouse Developer

Edmonton, AB, Canada

Full-time

Apply About employer

Applications open in a new tab.

Job details

Job type: Full-time
Experience: 8+ years of application or data solution development experience, ideally in enterprise environments.
Working hours: 20 hours per week
Posting language: English
Posted: Aug 22, 2026

Original job description

At Stantec, we have some of the world’s leading professionals passionate about enabling our business to be its best. Our business teams include finance, procurement, human resources, information technology, marketing, corporate development, HSSE, real estate, legal, and practice services. We bring diverse backgrounds, skills, and expertise and create a caring culture where everyone can thrive. Through teamwork and collaboration, we’re building a stronger, more resilient Stantec every day.

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

Data Engineering

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.

Collaboration and Stakeholder Management

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.

Security and Data Governance

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.

Additional Duties

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.

Our Ideal Candidate

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 (considered as 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 (preferred).
8+ years of application or data solution development experience, ideally in enterprise environments.
Bachelor's degree or equivalent experience in Computer Science, Information Systems, Engineering, or a related field.

Pay Transparency: In compliance with pay transparency laws, pay ranges are provided for positions in locations where required. Please note, the final agreed upon compensation is based on individual education, qualifications, experience, and work location. At Stantec certain roles are bonus eligible. Actual compensation for part-time roles will be pro-rated based on the agreed number of working hours per week.

Benefits Summary: Regular full-time and part-time employees (working at least 20 hours per week) will have access to health, dental, and vision plans, a wellness program, health care spending account, wellness spending account, group registered retirement savings plan, employee stock purchase program, group tax-free savings account, life and accidental death & dismemberment (AD&D) insurance, short-term/long-term disability plans, emergency travel benefits, tuition reimbursement, professional membership fee coverage, and paid time off.

Temporary/casual employees will have access to group registered retirement savings plan, employee stock purchase program, and group tax-free savings account.

The benefits information listed above may not apply to union positions because benefits for such positions are governed by applicable collective bargaining agreements.

Primary Location: Canada | AB | Edmonton

Organization: 1374 IT Services-CA Corporate-Edmonton AB

Employee Status: Regular

Business Justification: Replacement

Travel: No

Schedule: Full time

Job Posting: 20/02/2026 07:02:52

Req ID: 1004267

Apply About employer

More about this job

Responsibilities

The developer will design, develop, and maintain Oracle BI solutions, including dashboards, reports, and RPD metadata models. They will also collaborate with business stakeholders to translate requirements into practical intelligence solutions while ensuring data quality and governance.

Requirements

Candidates must have 8+ years of experience in data solution development and advanced SQL skills with Oracle databases. A bachelor's degree in a related field is required, along with strong expertise in Oracle analytics tools and dimensional modeling.

Skills

Oracle Analytics Server
Oracle Analytics Cloud
Oracle BI Repository
SQL
Data warehousing
Dimensional modeling
BI Publisher
Metadata modeling
Dashboard development
Data engineering
Report development
Agile
Data governance
Oracle E-Business Suite
Troubleshooting
Business analysis

Benefits

Health insurance
Dental insurance
Vision insurance
Wellness program
Health care spending account
Wellness spending account
Employee stock purchase program
Group tax-free savings account
Life insurance
Accidental death & dismemberment insurance
Short-term disability plan
Long-term disability plan
Emergency travel benefits
Tuition reimbursement
Professional membership fee coverage
Paid time off

Visa sponsorship

Not detected in the job text

Keywords

Oracle Analytics Server
Oracle Analytics Cloud
Oracle BI Repository
SQL
Data Warehousing
Dimensional Modeling
BI Publisher
Metadata Modeling
Dashboard Development
Data Engineering
Report Development
Agile
Data Governance
Oracle E-Business Suite
Troubleshooting
Business Analysis
DevOps
Relational Databases
Enterprise Data Structures
Subject Areas
Catalog Objects
Unit Testing
Integrated Testing
Technical Specifications
Visualization Best Practices
Row-level Security
LDAP
Performance Optimization
Quality Assurance
Information Technology

Report this job