BI Specialist

Cofomo

Montreal

Hybrid

CAD 90,000 - 130,000

Full time

4 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

COFOMO, a leading Canadian consulting firm in Montreal, seeks a BI Specialist hybrid role focused on data valorization, BI architecture, and governance. You will design, build, and optimize Power BI dashboards, integrate data sources, and maintain scalable analytics solutions using Fabric, Dataverse, and Azure tools.

Applicants should have strong skills in Power BI, DAX, Python, T-SQL, and data modeling, with experience in Agile environments and project operations tools.

Qualifications

  • Experience in BI with Power BI and data visualization.
  • Proficient in capture and translation of business needs into dashboards.
  • Knowledge of Azure DevOps, data pipelines, and data governance.
  • Experience with Dynamics 365 Project Operations or similar PM tools.

Responsibilities

  • Support the data valorization strategy by contributing to BI initiatives.
  • Develop and maintain Power BI reports and dashboards.
  • Design and document data sources, transformations, and governance rules.
  • Collaborate with stakeholders to translate business needs into technical specs.

Skills

Power BI
DAX
Python
T-SQL
Power Query
Azure DevOps
ETL/ELT
Data modeling
Data governance
Agile

Tools

Microsoft Fabric
Dataverse
Dynamics 365 Project Operations
Azure tools

Job description

87758# BI SpecialistMontrealHybridArchitecture and Technology GovernanceApplyWith over 30 years of recognized expertise, COFOMO is now a leading Canadian consulting firm specializing in digital and artificial intelligence. Supported by more than 3,000 experts, 10 Centers of Excellence, and 4 offices across the country, we are uniquely positioned to successfully guide our clients through their transformations. Both strategic and tactical, we help organizations across a wide range of industries thrive in today’s rapidly evolving world.## Our promiseHelp our clients succeed and maximize the impact of their transformation initiatives, turning them into powerful drivers of growth and innovation.## Job description**Here is a brief overview of the tasks and responsibilities you will be responsible for:*** Supporting the data valorization strategy by contributing to business intelligence initiatives and the development of robust, secure, and scalable analytical solutions;* Design business intelligence solutions aligned with operational, tactical, and strategic needs;* Collect, analyze, document, and validate business needs, indicators, target users, granularity, and acceptance criteria;* Translate business needs into technical specifications, slide rules, indicators, reports, and dashboards;* Advise stakeholders on the relevance, feasibility, and prioritization of business intelligence needs;* Map data sources, owners, flows, transformations, frequencies, dependencies, and quality levels;* Develop and maintain dimensional models, semantic models, data warehouses, and Microsoft Fabric solutions;* Promote the reuse of common templates, consistency of calculation rules, and traceability between sources, transformations, measurements, and visualizations;* Establish and maintain an official catalog of indicators including, in particular, definitions, objectives, formulas, sources, frequencies, granularities, rules, and thresholds;* Develop, publish, maintain, and evolve reports and dashboards with Power BI;* Create advanced DAX metrics and maintainable data transformations with Power Query (M), Python, and T-SQL;* Produce analyses enabling data drilling across different levels of governance, portfolio, program, and project;* Apply principles of ergonomics, accessibility, and data visualization to analytical solutions;* Perform analyses focusing in particular on governance, timelines, risks, resources, budgets, deployment, adoption, data quality, access, and delivered value;* Provide analytical tracking of features, user stories, anomalies, change requests, and product book items in Azure DevOps;* Integrate, transform, and reconcile data from multiple sources using ETL/ELT mechanisms, APIs, and interchange formats such as JSON;* Automate quality checks to detect missing, inconsistent, outdated, duplicate, or outdated data;* Collaborate with stakeholders to fix data issues at the source and measure the evolution of their quality;* Optimize templates, queries, transformations, measurements, aggregations, partitions, response times, and refresh policies, especially in Microsoft Fabric;* Implement access controls as well as line-level (RLS) and object (OLS) security;* Monitor refreshes and contribute to diagnosis as well as incident resolution related to business intelligence solutions;* Document work in Azure DevOps and structure features, user stories, tasks, anomalies, and technical debts;* Ensure traceability between needs, developments, testing, and production releases;* Participate in automating testing and deployments through DevOps/MLOps practices and continuous integration and deployment (CI/CD) pipelines;* Contribute to Agile activities, including planning, reviews, demonstrations, and retrospectives;* Document analytical architectures, models, calculation rules, transformations, sources, dependencies, security mechanisms, and operating procedures;* Produce operation, publication, diagnostic, and evolution guides as well as the data dictionary;* Supports users in interpreting and using data and carrying out knowledge transfer;* Develop analytical applications with Power Apps, Microsoft Power Platform, and relevant Azure tools;* Participate in the technical design and development of data pipelines, datasets, and analytical models;* Propose improvements to enhance the maturity of business intelligence, analytics, and data governance practices;* Conduct technological monitoring of analytical tools and best development practices; **The desired profile is as follows:*** Possess excellent oral and written communication skills in French;* Know the field of health and social services;* Have experience with Dynamics 365 Project Operations, Microsoft Dataverse, and integrated project and portfolio management solutions;* Have experience in a provincial, multi-stake, or multi-establishment environment;* Knowing PMI/PMBOK methodologies (an asset);* Have experience in Agile project management with Scrum, Scrumban, Kanban, DAD or SAFe, or in hybrid Agile and Waterfall approaches (an asset);* Mastering Azure DevOps (an important asset).
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Business Analyst
Senior Business Analyst

COFOMO • Montreal

Hybrid
CAD 90,000 - 120,000
Spécialiste en visualisation de données
Spécialiste en visualisation de données

COFOMO • Montreal

Hybrid
CAD 90,000 - 130,000
Data Valorization Analyst
Data Valorization Analyst

COFOMO • Montreal

Hybrid
CAD 70,000 - 95,000
Software Developer – Data Platform
Software Developer – Data Platform

COFOMO • Montreal

Hybrid
CAD 100,000 - 150,000
AI Business Analyst
AI Business Analyst

COFOMO • Montreal

Hybrid
CAD 90,000 - 120,000
Business and Systems Advisor
Business and Systems Advisor

COFOMO • Montreal

Hybrid
CAD 85,000 - 110,000
Power Platform Project Manager
Power Platform Project Manager

COFOMO • Montreal

Hybrid
CAD 90,000 - 120,000
Data Architect
Data Architect

COFOMO • Montreal

Hybrid
CAD 120,000 - 170,000
Infra Analyst - IT Specialist
Infra Analyst - IT Specialist

Cofomo • Montreal

Hybrid
CAD 70,000 - 110,000
Governance Advisor
Governance Advisor

Cofomo • Montreal

Hybrid
CAD 110,000 - 150,000