This job posting has expired.

Here are some similar positions.

Developer, Business Intelligence

December 6 2020
Industries Real Estate
Categories Information Technology, Consultation, Business analyst, IT Business Analyst, Data Business Analyst, Data analyst, BI, Mining, AI
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 view to generate long-term performance. Ivanhoé Cambridge is committed to creating living spaces that foster the well-being of people and communities, while reducing its environmental footprint.

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 industrial and logistics, office, residential and retail sectors. Ivanhoé Cambridge held close to C$64 billion in real estate assets as at December 31, 2019 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 Technologies

Position type : Salaried

Specific accountabilities

In this role, you will be responsible for developing data management and business intelligence solutions. You must have a detailed knowledge of the enterprise data management platform and understand client expectations, analyze needs and impacts, and translate specifications into concrete results. You will also recommend an implementation strategy, ensure the validity of selected solutions and oversee rollout.

You must be able to identify opportunities for improvement in system features and provide recommendations related to client needs and the Company's technological priorities. You will handle both projects and change requests, working with various IT teams and the client.

Specific duties include the following:

  • Work in collaboration with the solution designer and DM analyst to develop enterprise data management and business intelligence solutions in line with set budgets and delivery schedules. Support them in their daily operations;
  • Act as a subject matter expert to guide business units in self-service mode;
  • Facilitate the Power BI training offered to business units and contribute to content creation;
  • Develop data exploration and dashboard solutions with Power BI in accordance with data visualization and storytelling best practices;
  • Generate paginated reports for the business units using Microsoft SSRS or Power BI Report Builder;
  • Develop analytical data models using Power BI;
  • Create data marts in Transact-SQL;
  • Help advance the expertise centre by keeping abreast of new developments and concepts on platforms such as Power BI and by regularly sharing this knowledge;
  • Contribute to the development of the data warehouse;
  • Contribute to solution architecture and detailed architecture designs;
  • Identify and recommend opportunities for system improvement;
  • Participate in troubleshooting and problem-solving; propose solutions, action plans and evaluate alternative solutions;
  • Act as an analyst as needed.

Key requirements

  • Bachelor's degree in IT or a relevant combination of education and experience;
  • Minimum eight (8) years of relevant experience in developing business intelligence solutions
  • Minimum five (5) years of experience as a BI developer with an excellent command of BI and data integration solutions:

  • In-depth knowledge of the Power BI platform:

  • Data sources and preparation (Power Query and M scripting);

  • DAX modelling and metrics;
  • Visualization reports;
  • Opportunities for collaboration through the Power BI platform;
  • Tools for preparing self-service data (dataflows, Azure Data Lake Storage Gen2);
  • Advantages of Power BI Premium;
  • Proficiency in developing paginated reports in Microsoft SSRS or Report Builder;
  • Skill with Microsoft T-SQL development;
  • Thorough knowledge of data mart modelling;
  • Familiarity with documentation, use cases, data dictionaries and user interfaces;

  • Experience using, integrating, and developing the Microsoft Power Platform (Power Automate, Power BI and Power Apps) is preferred;

  • Experience developing enterprise data warehouse solutions;
  • Knowledge of Microsoft SQL 2019, an asset;
  • Knowledge of real estate management, an asset;
  • Thorough knowledge of industry best practices, especially those associated with modelling standards and data standardization;
  • Self-motivated team player who stays up to date on news and trends in technology and has a strong collaborative mindset, the ability to analyze and process information, excellent attention to detail and a methodical approach;
  • Excellent interpersonal and oral/written communication skills;
  • Flexibility and versatility in performing assigned duties;
  • Ability to set priorities and work in a fast-paced environment;
  • Solid experience in an environment focused on teamwork and collaboration;
  • Tolerance for 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. network