Back to jobs

Oracle BI/Data Warehouse Developer

Pay
Pay not listed
Work setting
Hybrid — work setting source
Work setup in the employer’s posting: Hybrid
From the employer’s posting
Employment
Full-time — employment source
Employment type in the employer’s posting: Full time
From the employer’s posting

What you’ll work on

Full posting
  • Design and maintain reports, dashboards, and BI catalog objects in OAS and OAC

  • Model RPD layers (Physical, BMM, Presentation) for BI subject areas

  • Write SQL and reporting logic for business reporting requirements

  • Perform unit and integrated testing of BI solutions

  • Troubleshoot reporting, metadata, and access issues in production

From the employer’s posting
Design, develop, and maintain reports, dashboards, analyses, and BI catalog objects using Oracle Analytics Server (OAS) and Oracle Analytics Cloud (OAC).
Oracle BI Repository (RPD) metadata modeling, including Physical, Business Model & Mapping (BMM), and Presentation Layers
Develop SQL queries, reporting logic, and BI solutions to support business reporting requirements.
Perform unit testing and integrated testing of BI solutions.
Support production reporting applications and troubleshoot reporting, metadata, and access issues.
Education & alternatives
• 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.
Apply at Hdhl

Posting record

Report an error

Actively hiringFirst seen by us 2 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20262 days ago
Recorded sightings
4
Last seen by us
Nov 21, 2026
Employer says posted
Feb 20, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 2

Early. Similar jobs usually come down between day 5 and day 43.

From 15,993 similar postings that came down. Coming down is not always a hire.

Hdhl is hiring

10 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • Oracle
Where the posting names them
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
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.
• 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.
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.
• 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.
• 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.
• 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.

Your next step

Complete your application on hdhl.fa.us6.oraclecloud.com. The employer’s form will show what is required.

Applying through Oracle Recruiting

  • Applying starts by asking for your email address.
  • Each employer sets which files it accepts, so read the note beside the upload field.

Already applied? Track this application

Job description

View original posting ↗

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.

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Edmonton, AB, Canada

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.