S

Stantec

Global design and engineering consulting services

Oracle BI/Data Warehouse Developer - Enterprise Dashboard and Reporting Solutions

Full-Time
No salary listed
Senior, Expert
Bachelor's
Edmonton, AB, Canada
In Person
Data & AnalyticsBusiness Intelligence

About the job

Requirements
  • Strong understanding of data warehousing concepts, dimensional modeling, and enterprise data structures supporting business intelligence and reporting.
  • Advanced SQL skills and hands-on experience with Oracle relational databases.
  • Experience with BI and analytics tools, preferably Oracle Analytics Server, Oracle Analytics Cloud, or Oracle BI Publisher.
  • Experience diagnosing and resolving reporting, metadata, dashboard, and data issues.
  • Ability to translate business requirements into effective technical solutions and understand how data enables business outcomes.
  • Knowledge of Oracle E-Business Suite modules, including Projects, Human Resources Management System, General Ledger, Fixed Assets, Accounts Payable, Accounts Receivable, and Purchasing, and their data structures or integrations.
  • At least 8 years of application or data solution development experience, ideally in enterprise environments.
  • A bachelor's degree or equivalent experience in Computer Science, Information Systems, Engineering, or a related field.
Responsibilities
  • Design, develop, and maintain reports, dashboards, analyses, and business intelligence catalog objects using Oracle Analytics Server and Oracle Analytics Cloud.
  • Translate business requirements into reporting and visualization solutions.
  • Perform impact assessments and provide effort estimates for reporting enhancements.
  • Perform unit and integrated testing of business intelligence solutions.
  • Document business intelligence reporting solutions, metadata models, technical specifications, and reporting standards.
  • Support production reporting applications and troubleshoot reporting, metadata, dashboard, data, and access issues.
  • Develop ad hoc reports using Oracle BI Publisher.
  • Develop and maintain business intelligence reporting standards, dashboard standards, and Oracle BI Repository metadata best practices.
  • Provide subject matter expertise and support the creation of architectural and technical deliverables.
  • Design, develop, and implement data warehouse and business intelligence reporting solutions using Oracle Analytics Server, Oracle Analytics Cloud, Oracle BI Repository metadata modeling, 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, planning sessions, and iterative development cycles.
  • Ensure alignment with enterprise architecture and integration patterns.
  • Support business intelligence solution configuration, dashboard optimization, and report performance improvements.
  • Develop SQL queries, reporting logic, logical business models, presentation-layer objects, dashboards, analyses, and reporting solutions.
  • Ensure data quality through testing and validation of analytical subject areas.
  • Use dimensional and relational data models to develop reporting and analytics solutions.
  • Create summarization, aggregation, and reporting logic for high-volume datasets.
  • Engage with cross-functional teams, including Finance, Human Resources, and Projects, to enhance understanding of business intelligence subject areas.
  • Manage stakeholder expectations regarding business intelligence subject areas and help stakeholders use the presentation layer effectively.
  • Enforce data governance policies, comply with data privacy regulations, and implement application roles or LDAP groups to control dashboard access.
  • Support application roles, LDAP groups, and row-level security so users access only authorized information.
  • Analyze and improve dashboard, report, and metadata performance.
  • Identify opportunities to improve or extend frameworks and standards.
  • Support programming policies, procedures, and quality assurance best practices related to business intelligence.
  • Provide regular updates and communications on development and operational support activities, including status updates and priorities.
Desired Qualifications
  • Experience with Oracle Analytics Server, Oracle Analytics Cloud, or Oracle BI Publisher.
  • Knowledge of Oracle E-Business Suite modules and their data structures or integrations.
  • Experience working in Agile environments and contributing to iterative development cycles.

About the company

Stantec is a global design and consulting firm that delivers professional services in multiple sectors, including buildings, energy and resources, environmental services, infrastructure, and water. It helps municipalities, governments, and private clients plan, design, engineer, and manage projects by offering planning, architecture, engineering, environmental, and project management services for a fee. The company differentiates itself through its global reach and multi-disciplinary teams that provide integrated solutions across many sectors, enabling end-to-end project delivery. Its goal is to help clients design and implement infrastructure, facilities, and environmental solutions that meet their objectives, operate efficiently, and serve communities over the long term.

Company Size

10,001+

Company Stage

IPO

Headquarters

Edmonton, Canada

Founded

1954

Get referred to Stantec

See people who can refer or advise you

Simplify Jobs

Simplify's Take

What believers are saying

  • October 2, 2026 SFPUC awarded Stantec a seven-year environmental services contract.
  • September 18, 2026 Kari Shively took over North American Water, a C$970 million business.
  • Second-quarter 2026 revenue grew 13.4%, and adjusted EBITDA margin expanded to 18.7%.

What critics are saying

  • The July 7, 2025 DOJ settlement exposed procurement controls across Stantec's EPA-related business.
  • Clearwater's 2026 breach-of-contract case keeps design-liability risk alive around public infrastructure projects.
  • Persistent engineer shortages can choke delivery; losing senior water leaders would cripple C$970 million targets.

What makes Stantec unique

  • Stantec spans water, buildings, energy, and environmental services across 1954-founded global teams.
  • Its July 31, 2026 Niche acquisition deepens environmental permitting and compliance capabilities in Australia.
  • August 12, 2026 backlog hit C$9.2 billion, giving roughly 13 months visibility.

Help us improve and share your feedback! Did you find this helpful?

Benefits

  • Professional Development Budget
  • Flexible Work Hours

Company News

Yahoo Finance
Oct 18th, 2026
Three undervalued Canadian stocks: Groupe Dynamite, Stantec and Altius Minerals

Simply Wall St has named three Canadian stocks that its cash flow screen suggests trade below the value of their future cash flows. High interest rates are hurting heavily indebted firms, it says, and putting cash-generating companies in focus. Groupe Dynamite (TSX:GRGD), a women's fashion retailer, has a market cap of CA$6.69 billion. It earns about CA$1.49 billion in revenue and is expanding in the US and UK. Stantec (TSX:STN), an engineering and consulting firm, has a market cap of CA$11.01 billion. It earns about CA$7.0 billion in revenue and reports a $7.9 billion backlog. Altius Minerals, a royalty and streaming business, has a market cap of CA$3.32 billion. Its lithium royalty portfolio could benefit from rising battery demand.

Stantec
Oct 15th, 2026
Stantec ranks #7 on enr's 2026 Top 100 Green Design Firms.

Stantec ranks #7 on enr's 2026 Top 100 Green Design Firms. October 15, 2026 In Engineering News-Record, Jill Kurtz shares how building performance data and operational insights help advance sustainability goals, maximize value Stantec ranks #7 on Engineering News-Record's 2026 Top 100 Green Design Firms list, reflecting the firm's continued commitment to sustainable, high-performing buildings. Jill Kurtz, sustainable design leader for Stantec's Building practice, discusses how building performance data and operational insights can help owners advance their sustainability goals while maximizing long-term value. Compressed timelines, tight labor resources, rising costs of materials, and shifting federal policies can mean that sustainability efforts are increasingly based on economic factors, according to Jill. This focus makes it "even more important to ground decisions in building science, operational data, risk reduction, and business value rather than labels or certifications alone." "The future of green building," Jill explains, "will be defined not by what we intend a building to do but by what it actually delivers throughout its lifetime." * Jill is a sustainable design leader with more than 20 years of sustainability experience. She helps clients translate intention into meaningful and measurable impacts. Contact Jill

Informa TechTarget
Oct 12th, 2026
JE Dunn-Alberici JV breaks ground on $3.2B Texas shipyard.

JE Dunn-Alberici JV breaks ground on $3.2B Texas shipyard. The greenfield shipyard under construction for military contractor Saronic is the first in the U.S. since World War II, according to the JV. Published Oct. 12, 2026 The first greenfield shipyard to be built in the U.S. since World War II has broken ground. A joint venture of JE Dunn and Alberici began construction on the initial phases of military contractor Saronic's Port Alpha, an over $3.2 billion shipyard. There, the contractor will manufacture manned, autonomy-capable and autonomous ships, according to an Oct. 6 announcement from the JV. The shipyard, located at the Port of Brownsville in Texas, will spread across an initially 835-acre site, per the announcement. However, Saronic will have the option to expand the shipyard to nearly 4,400 acres, according to a Sept. 30 news release from the firm. The contract features three overlapping phases, according to the JV. The site preparation and infrastructure phases will include grading, ground improvement, drainage, access roads and utility infrastructure. Then, Phase 1 of shipyard development will begin with the initial assembly buildings, material-handling systems and supporting facilities. When complete, the site will encompass all manufacturing facilities, warehousing, permanent waterfront and vessel-launching infrastructure and employee support facilities. JE Dunn and Alberici, which are headquartered in Kansas City, Missouri and St. Louis, respectively, worked with design partners Stantec and KPFF via the progressive design-build delivery method, per the announcement. Together, the team will overlap design, procurement and construction across all three stages, to progress the site's manufacturing capability as the development takes shape. Scott Shelby, vice president at JE Dunn and program leader for the JV, told Construction Dive via email that the approach allows the team to develop and evaluate the design, scope and cost before agreeing to the final construction price. "That collaboration also helps us determine which portions of the work can advance while other requirements are being resolved," Shelby said. "For example, we can plan early structural and waterfront packages while coordinating later equipment installation and supporting infrastructure." This isn't the JV's first time working with Saronic. Alberici announced in 2025 that the team won a $300 million expansion of Saronic's shipyard in Franklin, Louisiana. The contractors topped out the facility in August.

Stantec
Oct 12th, 2026
Stantec recognized for excellence in acquisitive growth.

Stantec recognized for excellence in acquisitive growth. October 12, 2026 Strategic communications help strengthen Stantec's acquisition experience Stantec recently received the 2026 M&A Best Practices Award as part of Morrissey Goodale's Excellence in Acquisitive Growth Awards Series, honoring the firm's clear, consistent communication with employees, clients, and other key partners to help understand the acquisition and how it strengthens the organization. The award recognizes Stantec's communications practices following the close of acquisitions, including its coordinated, multi-channel and multi-stage approach designed to provide clear, consistent, and empathetic communications throughout the integration process. It underscores the important role communications plays in the firm's overall integration strategy and approach as newly acquired teams are welcomed into the organization. Through strategic acquisitions, Stantec has expanded its global capabilities by combining complementary expertise, geographic reach, and specialized services to serve clients across the infrastructure, buildings, water, energy, and environmental markets. Bjorn Morisbak, chief corporate development officer, and Kim Austin, vice president of Mergers & Acquisitions, accepted the award on Stantec's behalf at The M&A and Capitalization Symposium in Houston.

Navy League of the United States
Oct 8th, 2026
JE Dunn, Alberici break ground on historic $3.2B Port Alpha shipyard project.

JE Dunn, Alberici break ground on historic $3.2B Port Alpha shipyard project. BROWNSVILLE, Texas - JE Dunn Construction and Alberici Constructors, Inc. celebrated the official groundbreaking last week for the initial phases of Port Alpha, Saronic Technologies' $3.2 billion-plus shipyard development at the Port of Brownsville to manufacture autonomous, autonomy capable, and manned vessels. Vice President JD Vance attended the event alongside other national, state, and local representatives, including Texas Governor Greg Abbott. Representing one of the largest economic development projects in modern Texas history, the historic Port Alpha investment is expected to create up to 10,000 direct jobs at full buildout. "Port Alpha represents a defining investment in the future of maritime manufacturing," said Gordon Lansford, president and CEO of JE Dunn Construction. "JE Dunn is proud to help build the infrastructure and advanced manufacturing capacity that will shape this next chapter. Together with Alberici, Saronic, and our project partners, we are bringing the expertise and collaboration needed to turn this bold vision into a world-class shipyard." The groundbreaking marks the start of work to establish the manufacturing facilities and critical infrastructure necessary to launch autonomous vessel production at the initial 835-acre site. The initial work encompasses three overlapping stages: * Site preparation and infrastructure: JE Dunn and Alberici will prepare the initial development areas through grading, ground improvement, drainage, access roads, and utility infrastructure. This foundational work supports both ongoing construction and the first manufacturing operations, with built-in provisions for future expansion. * Phase 1 shipyard development: Starting with the initial assembly buildings alongside the utilities, material-handling systems, and supporting facilities, JE Dunn and Alberici will take on the full development of the first phase of Port Alpha. At completion, the site will encompass all manufacturing facilities, warehousing, permanent waterfront and vessel-launching infrastructure, and the employee support facilities needed for a fully integrated, operating shipyard. "This first-of-its-kind shipyard is an opportunity to bring our team's extensive marine experience and self-perform expertise to critical infrastructure," said Jose Garcia, president of Alberici Constructors, Inc. "Our experienced craft and specialized equipment allow us to directly execute critical scopes including excavation, dredging, marine concrete and waterfront construction while maintaining greater control over safety, quality and schedule." In collaboration with design partners Stantec and KPFF, the JE Dunn | Alberici joint venture has developed this progressive design-build approach to intricately coordinate facility design and construction with Saronic's highly advanced production equipment and operating requirements. By intentionally overlapping design, procurement, and construction across all three stages, the project team ensures manufacturing capability is brought into service progressively as the larger, multi-billion-dollar development takes shape. "The groundbreaking at Port Alpha is a massive leap forward in our mission to scale the next generation of American shipbuilding," said Doug Lambert, Co-founder and Chief Operating Officer at Saronic. "Expanding our existing partnership with JE Dunn and Alberici ensures we have the world-class expertise required to execute this development project. Their ability to seamlessly overlap design, procurement, and construction will allow us to bring our manufacturing capacity online with the urgency required to meet the demands of the American maritime industrial base." From JE Dunn, Oct. 7, 2026