Oracle Bi/Data Warehouse Developer
Stantec
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 OpportunityWe 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 ResponsibilitiesReport 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#J-18808-Ljbffr
Your OpportunityWe 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 ResponsibilitiesReport 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#J-18808-Ljbffr
Vacancy posted 1 hour ago
Similar jobs that could be interesting for youBased on the Oracle Bi/Data Warehouse Developer in Winnipeg, MB vacancy
- Databricks and Power BI integration anchor this Software Developer opportunity for Toronto professionals available on-site five days each week.As... ..., you will connect Power BI with Databricks SQL Warehouses and Lakehouse data sources. You will also build ETL transformations,...Business intelligence
- Data modeling and ETL expertise anchor this Senior Business Intelligence... ...role. Apply SQL Server, Oracle, R Shiny, and analytical skills... ...processes.Key Responsibilities: Develop ETL programs for daily and... ...valuesDocument interfaces between BI solutions and external applicationsDevelop...Business intelligenceOracle
- Lead Oracle PL/SQL development using advanced SQL, query optimization, and data integration for a long-term opportunity. Apply deep database... ....This Senior Oracle PL/SQL Developer role requires 10+ years of... ...performanceDesign data warehouses and support ETL developmentTranslate...OracleLong term contract
- Job Title : Senior Data Warehouse/BI Architect Location : Burnaby, BC Work Setting : Hybrid, Monday to Friday. This role requires working... .... In this role, you will be responsible for architecting and developing enterprise data models, data governance frameworks, ETL/...Business intelligenceFull timeInternshipWork at officeMonday to friday1 day per week
- BI Developer & Data Engineer (Contract) Location: Montréal, QC (Hybrid, 3 days on-site, 2 days remote) Language: Strong written and verbal communication skills required. Duration: 6-month full-time contract, with possibility of extension Background Check Requirement...Business intelligenceFull timeContract workRemote work
- Elevate business intelligence solutions with Global Data as a Senior BI Developer. Drive analytics strategy and implementation for Fortune 500 companies in a hybrid work environment. As a Senior BI Developer, you will lead enterprise-level BI projects, collaborating closely...Business intelligence
- ...Job Title: BI Developer & Data Analyst Contractor Period 6 months with possibility for extension Work Location: Lachine CAN H8T 3H1 Job Description: We are seeking for 2 experienced BI Developer & Data Engineer Contractor to design and implement scalable analytics...Business intelligenceLong term contractFull timeFor contractorsWorldwide
- ...reputable analytics firm, is seeking an experienced Senior Data Warehouse Developer to join their growing business intelligence team in Kimberley... ..., Talend) and data warehousing platforms (e.g., SQL Server, Oracle, Snowflake, Redshift). Experience with cloud data warehousing...Business intelligenceOracleWork at officeRemote work
- Build data warehouse and BI solutions at Novo Nordisk using T-SQL and Power BI. Shape reporting capabilities that support business decisions.As a Senior Application Developer, you will adapt data warehouses, ETL processes, and reporting platforms for evolving analytical requirements...Business intelligence
- Job Title: Senior Data Warehouse DeveloperReports to: Data Warehouse Technical LeadAbout us... ...well‑governed Snowflake marts consumed by BI and analytics, apply SDC Type 2 to... ...closely with project managers, QA, and other developers; provide support to business users and...Business intelligenceWorldwide
- Astra-North Infoteck Inc. seeks a senior data engineer to design and develop scalable ETL/ELT processes, and to optimize loading and transformation for... .... You will collaborate with stakeholders to model data warehouses and build dashboards using Tableau. The role requires strong...Business intelligence
- Precision Technologies is seeking an experienced Power BI Developer with a strong BI and data warehousing background in Canada. You will design scalable data solutions, develop ETL processes, and transform complex data into actionable insights. Proficiency in DAX, SQL, Snowflake...Business intelligence
- Fidelity Canada is seeking a Team Manager, Data Warehouse to lead a dedicated DW team responsible for data warehouse, data engineering applications... ...resources, and advance technical standards while mentoring developers to deliver high-quality, scalable data solutions across...Business intelligence
- ...US, Canada, Mexico & India. SAT is an Oracle Gold Partner, SAP Services Partner & IBM... ...Application specialist Level 2 will develop, implement, support, document, and provide... ...database, OBIEE tools, dimensional data modeling, data warehouse design, ETL design and development...Business intelligenceOracle
- ...bookseller in Toronto is seeking an experienced Business Intelligence Developer to enhance their reporting suite using Google BigQuery and... ...Candidates should possess a Bachelor's degree and over 5 years of BI development experience. The company promotes a casual working environment...Business intelligenceCasual work
- ...for a Business Intelligence Developer to join our Tour Operations... ..., you will deliver innovative data and analytics solutions that... ...efficiency. You will build Power BI reports and semantic models,... ...models using appropriate data warehouse principles. Use Python and...Business intelligence
- About Global Data and BI Global Data and BI is hiring on a rolling basis for Business Intelligence... ...into the client's operations. As a BI Developer, you will lead both the technical... ...end BI platforms that integrate with data warehouses (Snowflake, Databricks) and cloud ecosystems...Business intelligenceRemote work
- ...versions of Teradata6+ years of Enterprise Data Warehouse ETL development.6+ years of experience with proficiency in SQL with Teradata Oracle and/or Databases.Expert at documenting... ...written and verbal communication skills.Develops statements of problems and requirements....
- ...a high-growth team as a Business Intelligence Developer. Design and implement cutting-edge BI solutions leveraging your data warehousing and SQL expertise for impactful reporting... ...and dashboards • Use ETL tools to create data warehouse solutions • Optimize and maintain existing ETL...Business intelligenceOracle
- ...Shape CATC’s Azure SQL data warehouse using advanced SQL, relational modelling, and dbt. This permanent, full... ...pipelines for performance and reliability Develop ETL/ELT processes from multiple source systems Support Power BI developers and business analysts with...Business intelligencePermanent employmentFull time
- ...Join the Enterprise Business Intelligence team as a BI Developer focused primarily on data engineering within our Azure Databricks platform. This role... ...qualifying when it includes production pipelines, lakehouse or warehouse development, Spark or notebook-based engineering,...Business intelligenceVisa sponsorshipWork visa
$115k - $125k per year
...Consulting, Digital, Cloud & DevOps, Data, and Software Engineering,... ...initiatives in our FinLabs we develop solutions for modernization, from... ...seeking an experienced Power BI Developer with a strong background... ...Experience with Snowflake data warehouse or other cloud data platforms....Business intelligenceLong term contractFlexible hours- We are hiring a Senior Oracle PL/SQL Developer for a long-term opportunity. 10+ years of experience... ...SQL, Query Optimization, Database Design, Data Modeling, and OLTP/OLAP applications . Hands-on experience in Data Warehouse Design & Development, Database Performance...OracleLong term contract
- BI Developer or Business Intelligence DeveloperContract7 time INC 500 / 5000, 7 time BBJ "Pacesetter", 5 time SIA-fastest growingTalentBurst... ...participate in the evaluation of business requirements for data warehouse and reporting solutions. Using your skills and experience as...Business intelligenceOracleContract workManual labor
- Job SummaryAs a BI Developer, you will play an active role in the design, development, and implementation of innovative BI solutions using the... ...You will work closely with IT teams, business stakeholders, and data experts to develop business intelligence reports that support...Business intelligence
$95k - $105k per year
...Remote Department: Finance Position: Oracle Cloud Developer The world of payment processing is... ...extracts, and extensions, prepare test data and execute the technical test cycles, investigate... ...reporting and extract objects using BI Publisher and OTBI, including the...Business intelligenceOracleLocal areaRemote workFlexible hoursShift work- A healthcare technology company in Burnaby is seeking a Senior Data Warehouse/BI Architect to lead the design and development of enterprise data models and ETL pipelines. The ideal candidate will have over 15 years of experience in data architecture and a strong background...Business intelligence
- ...validating business requirements, optimizing analytical solutions, and delivering impactful reports and dashboards. Candidates should have over 5 years of experience with Oracle analytics tools like OBIEE and OAC, and strong skills in data integration and reporting. #J-18808-LjbffrBusiness intelligenceOracle
- # BI & Data AnalystMontreal, QC (Hybrid)Full-timeAt Flex Travel Solutions, we foster an environment... ...organization.Responsibilities:* Design, develop, and maintain interactive dashboards and... ...team to ensure data pipelines and warehouse structures meet analytical needs.* Conduct...Business intelligenceWork at office
- A technology solutions provider in Toronto is seeking a Senior Software Developer with over 10 years of experience, particularly in SQL and Azure technologies. The role involves code development, reporting solutions, and entails a hybrid working arrangement. Candidates should...Business intelligence
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Oracle Bi/Data Warehouse Developer. Be the first to apply!
Related searches

