REQUIREMENTS:

• University degree in computer science, business intelligence, information architecture, information science, business administration or another related field
• 3-7 years of relevant business intelligence experience
• Professional experience in the financial or insurance industry, considered an asset
• Experience in developing and using relational and dimensional models
• Good knowledge of SQL (window functions, subqueries, conditional tables)
• Experience developing dashboards and performance indicators using PowerBI, Tableau, Looker
• Strong ability to convey complex information to different organisational levels and stakeholders with different levels of business intelligence maturity
• Knowledge of data pipeline development tools (e.g., Apache Airflow, Luigi, dbt, stitch) considered an asset
• Knowledge of programming languages in a data pipeline development context (e.g., Java, C#, Python) considered an asset
• Familiarity with certain cloud computing suites (AWS, Azure, GCP) considered an asset

The successful candidate will take part in various business intelligence and data engineering mandates, which could involve assessing current practices, as well as developing a business intelligence and data engineering strategy, roadmaps, dashboards and performance indicators, devising and validating data models, and analysing data to support timely decision-making.

The successful candidate will have a range of responsibilities, including:

• Taking part in client meetings and supporting the team in developing presentation materials in relation to project kick-off meetings, needs gathering and analysis, project management, presentation of results
• Developing and implementing dimensional and tabular data models aligned with clients’ business intelligence needs
• Advising on the implementation of indicators aligned with organisational or sectoral objectives to support performance management and decision-making
• Playing a role in developing and implementing roadmaps, dashboards, performance indicators, data modelling, business intelligence and data engineering systems architectures, data analyses supporting decision-making
• Assisting and supporting clients in implementing recommendations and managing projects in accordance with deadlines, budgets and client expectations
• Working on multiple client engagements of varying scope and complexity at the same time
• Delivering high-quality work on time that meets the Firm’s quality standards and client expectations
• Working with cross-functional teams with people of diverse backgrounds and skill sets