This job posting has expired.

Here are some similar positions.

Developer, Business Intelligence

June 22 2020
Industries Real Estate
Categories Information Technology, Programming, Development, Database Dev. & Admin., Data Centre, Warehousing, Cloud, 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 Technology

Position type : Salaried

Specific accountabilities

The incumbent is responsible for developing data management and business intelligence solutions. He or she must have a detailed knowledge of the enterprise data management platform and must understand client expectations, analyze needs and impacts, and translate specifications into concrete results. The incumbent also recommends an implementation strategy, ensures the validity of selected solutions and oversees rollout.

The incumbent must be able to identify opportunities for improvement in system features and provide recommendations related to client needs and the Company's technological priorities. He or she handles 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;
  • Serve as a dedicated point of contact and lead for:

  • Implementing and monitoring data visualization methodologies and best practices;

  • Overseeing the strategy for developing, deploying and organizing workspaces and Power BI applications delivered by the team;
  • Guiding, reviewing and validating the work of other team members;
  • Organizing and developing content for the Power BI training offered to business units;
  • 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;
  • Identify and recommend opportunities for using artificial intelligence in analytical solutions;
  • 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 years of relevant experience in developing business intelligence solutions
  • Minimum five 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;
  • Experience developing solutions for data science with R, Python, MATLAB or SAS (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