Stantec System

OBIEE Developer

CA-AB-Edmonton | US-AZ-Phoenix | US-CO-Broomfield
2 months ago(11/2/2017 9:14 AM)
Job ID
# of Openings Remaining
Experience (Years)
IT Services

Your Opportunity

Communities are fundamental. Whether around the corner or across the globe, they provide a foundation, a sense of place and of belonging. That's why at Stantec, we always design with community in mind. 

We care about the communities we serve—because they're our communities too. This allows us to assess what's needed and connect our expertise, to appreciate nuances and envision what's never been considered, to bring together diverse perspectives so we can collaborate toward a shared success.

We're designers, engineers, scientists, and project managers, innovating together at the intersection of community, creativity, and client relationships. Balancing these priorities results in projects that advance the quality of life in communities across the globe. 

Stantec trades on the TSX and the NYSE under the symbol STN. Visit us at or find us on social media.

We are looking for an OBIEE Developer to join our Business Intelligence Solutions Team to support the development and maintenance of our Oracle DW/BI application running on Exadata and Exalogic servers.

Your Duties

Problem Solving

  • Work with Business Analysts, BI Team, and other systems analysts to analyze business requirements; and translate them into Data Warehouse/Business Intelligence (DW/BI) solutions; 
  • Consult on BI capabilities and recommended solutions to address business needs; and
  • Extend the Data Warehouse with data from new sources, applying: data lineage analysis; PL/SQL schema DDL design; and OBIEE business model and content development.


  • Design, develop, and implementation of DW/BI solutions using: Oracle Data Warehouse Data Model, OBIEE RPD business models, and OBIEE dashboards;
  • Define, design, document and implement required customizations and extensions to existing models. Analyze impact on DW/BI application before making any changes to the system;
  • Understand project requirements, create functional and technical documentation;
  • Implement and provide support for user and group access permissions to maintain the security of the DW/BI application; and
  • Perform peer design and code review.


  • Effectively communicate highly technical information to functional, technical team members and management;
  • Communicate issues and solutions in a clear and concise manner; and
  • Keep clients, peers and managers informed on progress and the status of issues.

Dynamic Work Environment

  • Prepare time estimates for assigned projects and tasks;
  • Prioritize development and enhancement requests;
  • Given the tasks and scope of a project, successfully complete and document the project within the specified time frame and keep stakeholders informed of changes to plans; and
  • Ability to work with multiple projects simultaneously in a priority driven environment. 

Interpersonal Interaction

  • Interact with end user, peers, help desk, and management personnel to resolve issues;
  • Effective in interacting with users when designing, documenting, completing, and testing assignments; and
  • Maintain a positive attitude when dealing with others in a pressured environment. 

Your Capabilities and Credentials


  • 5+ years of database and application development experience using formal software development life cycle;
  • At least 2 years of experience in designing, developing and implementing an enterprise DW/BI system using OBIEE; and
  • The ideal candidate has demonstrated the ability to work with professionalism and confidentiality, and is able to work independently, multi-task and adapt to change in a very dynamic environment.


  • Experience with at least one OBIA Analytics module (Finance/Projects/HR);
  • Experience with OBIA architecture and pre-built data models;
  • Experience with ODI;
  • Proficient with Windows or Linux command line;
  • Knowledge of EBS application modules (Oracle Projects, HRMS, GL, FA, AP, AR, PO, etc.) and their integration into the overall Oracle suite;
  • Knowledge of ITIL v3 (IT Infrastructure Library); and
  • Experience with Exadata and/or Exalogic


Please note that this position will require after-hours and on-call work.

We are looking for team players that can work in a very dynamic and challenging environment.

Submit your Resume for this job

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Connect With Us! / Connectez avec nous!

Not ready to apply or not sure if we currently have an open position that would be your perfect fit? You can still connect with us so we can keep you updated on opportunities that match your skills and experience.

Vous n’êtes pas prêt(e) à envoyer votre candidature ou ne savez pas si nous avons actuellement un poste ouvert qui serait adapté à vos compétences? Vous pouvez toujours communiquer avec nous et nous vous informerons des possibilités qui correspondent à vos compétences et à votre expérience.

Staffing and Recruitment Agencies
Stantec appreciates the interest from the staffing industry, however, unsolicited resumes submitted to Stantec or any Stantec employee without a current and valid staffing agency contract in place with Stantec will not be eligible for any search fees. At this time, Stantec is not welcoming any additional inquiries for agency partnerships.

Agences de recrutement et de dotation
Stantec apprécie l’intérêt porté par les agences de dotation de personnel. Toutefois, tout curriculum vitae non-sollicité envoyé à Stantec ou à un employé de Stantec qui n’est pas lié à un contrat actuel et valide avec une agence ne pourra donner droit à des frais de recherche. En ce moment, Stantec n’est pas à la recherche de nouveaux partenariats avec des agences de dotation de personnel.