Share this Job

Title:  Business Intelligence Architect (Oracle BI)


Requisition ID: 34982

Join the Global Community of Scotiabankers to help customers become better off.

BI Architect


Purpose of Job

Develops, enhances, debugs, supports, maintains and tests finance applications that support business units or supporting functions.  Participates in the design, development and implementation of complex applications, often using new technologies. May provide technical direction and system architecture for individual initiatives. Serves as a fully seasoned/proficient technical resource. Will not have direct reports but may lead projects and direct activities of a team related to special initiatives or operations. May have responsibility for a project and project budget. May collaborate with external programmers to coordinate delivery of software application. Routine accountability is for technical knowledge and capabilities. Works under minimal supervision, with general guidance from more seasoned consultants. Typically requires 5-7 years of experience.


Key Job Accountabilities

  • Design and implement new data models and process for new reporting strategies
  • Enhance and Develop existing models for new report requirements
  • Provide support to operations team in data model and process issues


Functional Competencies

  • Report/Dashboard design and development
  • OBIEE repository development, report/dashboard development
  • Knowledge of Unix/Linux OS with basic commands
  • Good Oracle SQL skills (i.e. create/modify stored procedure/function/packages; performance tuning on SQL scripts)
  • Knowledge in designing and implementing dimensional star and snowflake models, data marts, and data warehouses
  • Good Knowledge of relational databases like Oracle
  • Good analytical skills to break down requirements, solve complex problems
  • Proven analytical and problem solving skills
  • Desire to lead and take ownership of the projects



  • Bachelor Degree in Computer Science
  • Certification in BI reporting
  • Certification in Data modeling

Location(s):  Canada : Ontario : Toronto

As Canada’s International Bank, we are a leader when it comes to inclusion. We are a diverse and global team, speaking more than 100 languages with backgrounds from more than 120 countries. We value the unique skills and experiences each individual brings to the bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. Candidates selected for an interview will be contacted directly.  If you require accommodation during the recruitment and selection process, please let us know. We will work with you to provide as seamless a recruitment experience as possible.



Job Segment: Architecture, Business Intelligence, Database, Oracle, Banking, Engineering, Technology, Finance

Find similar jobs: