Business Intelligence Analyst

June 11 2019
Industries Real Estate
Categories Information Technology, Analyst, Consultation - Business analyst, Project management
Montreal, QC

Ivanhoé Cambridge develops and invests in high-quality real estate properties, projects and companies that are shaping the urban fabric in dynamic cities around the world. It does so responsibly, with a long-term view to generate optimal, risk-adjusted returns. Ivanhoé Cambridge is committed to creating living spaces that foster the well-being of people and communities, while reducing its environmental footprint.

Vertically integrated in Canada, Ivanhoé Cambridge invests internationally alongside strategic partners and major real estate funds that are leaders in their markets. Through subsidiaries and partnerships, the Company holds interests in more than 1,000 buildings, primarily in the residential, office, retail, industrial and logistics sectors. Ivanhoé Cambridge held more than C$65 billion in assets at December 31st, 2018 and is a real estate subsidiary of the Caisse de dépôt et placement du Québec (, one of Canada's leading institutional fund managers. For more information:

Department : Information Technology

Position type : Salaried

Specific accountabilities

In 2016, the IT Department adopted an ambitious data management strategy with the goal of supporting Ivanhoé Cambridge's growth and guiding the Company toward data-driven success. A new information management platform using a publications/subscriptions approach was therefore born in order to:

  • Streamline and automate the flow of information within the organization;
  • Standardize data;
  • Provide consolidated and complete access to all company data;
  • Improve data quality and consistency.

In this dynamic context, the incumbent is responsible for drawing up functional specifications for data integration.

He or she must have advanced knowledge of business intelligence systems, be able to understand the client's business environment, analyze its needs and their impacts, and translate this into detailed, results-oriented specifications. In so doing, he or she collaborates with a business analyst, a solutions developer and a data architect.

The incumbent must work together with a number of IT teams and clients and simultaneously coordinate several different projects and change requests.

  • Analyze client requirements in collaboration with the business analyst;
  • Draft systems analysis documents:

  • ETL maps;

  • Functional design;
  • Workflow design (BPM);
  • Operationalization documents;
  • Help ensure high-quality deliverables by undertaking validation and quality assurance activities;
  • Guide and train the applications' superusers;
  • Contribute to solution architecture and detailed solution design;
  • Identify and recommend ways to improve the system;
  • Help resolve incidents and problems; propose solutions and action plans; evaluate alternative solutions;
  • Provide support and context to the development and quality assurance teams.

Key requirements

  • Bachelor's degree in information technology or a related field;
  • Master's degree or specialization in business intelligence, an asset;
  • Minimum five years of relevant experience in developing business solutions;
  • Minimum three years of experience as a system solutions analyst and in-depth knowledge of solutions related to business intelligence and data integration:

  • Familiarity with Microsoft SSIS;

  • Working knowledge of relational model concepts;
  • ETL documents, use case, data dictionary, user interface;

  • Proficiency in Power BI, an asset;

  • Experience in SQL development;
  • Familiarity with real estate management and/or finance, an asset;
  • Team player with a proven commitment to collaboration; self-directed, detail-oriented and methodical; excellent analytical and processing skills;
  • Strong interpersonal and oral/written communication skills;
  • Adaptability and versatility;
  • Ability to prioritize and accomplish tasks in a fast-paced environment;
  • Significant experience in a collaborative, teamwork-based setting;
  • Tolerance to stress;
  • Fluency in written and spoken French and English.


You have everything to gain!

When you join the Ivanhoé Cambridge team, you are eligible for employment benefits and a pension plan that are among the best in the industry. Our many health and wellness programs encourage you to balance your work and personal lives and fulfil your desire for social involvement, while maintaining a healthy lifestyle. At Ivanhoé Cambridge, you will have many opportunities to develop your skills and thrive professionally, in Canada or elsewhere in the world. Our initiatives aimed at creating an exceptional working environment that inspires our employees to give the best of themselves elevated Ivanhoé Cambridge into the ranks of 100 Top Employers in Canada.

Apply now! network