BI Developer
Stantec
Victoria, British Columbia
5d ago

Your Opportunity

We are looking for a on our Integrated Business Applications team.

Your Key Responsibilities

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 recommend solutions to address business needs

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

Technical

Design, develop, and implementation of DW / BI solutions using : Oracle Data Warehouse Data Model, OBIA (ODI), 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

Perform peer design and code review

Communication

Effectively communicate highly technical information to functional, technical team members and management

Communicate issues and solutions in a clear and concise manner

Keep clients, peers and managers informed on progress and the status of issues

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

Maintain a positive attitude when dealing with others in a pressured environment

Your Capabilities and Credentials

Database and application development experience using formal software development life cycle

Experience in designing, developing and implementing an enterprise DW / BI system using OBIEE.

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 ODI

Experience with OBIA architecture and pre-built data models

Experience with extracting Oracle HCM Cloud data and loading into on-premise OBIA.

Experience with at least one OBIA Analytics module (Finance, Projects, HR)

Knowledge of EBS application modules (Oracle Projects, HRMS, GL, FA, AP, AR, PO, etc.) and their integration into the overall Oracle suite is an ASSET

Education and Experience

Bachelor’s degree or equivalent in Applications Development or related field; Minimum of 7-8 years of experience.

  • this role can be located anywhere in North America
  • This description is not a comprehensive listing of activities, duties or responsibilities that may be required of the employee and other duties, responsibilities and activities may be assigned or may be changed at any time with or without notice.

    Stantec is a place where the best and brightest come to build on each other’s talents, do exciting work, and make an impact on the world around us.

    Join us and redefine your personal best.

    Apply
    Add to favourites
    Remove from favourites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form