BI Specialist (Quebec City)

BI Specialist (Quebec City)

19 Nov
|
COFOMO
|
Quebec City

19 Nov

COFOMO

Quebec City

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 Secure, or in hybrid Agile and Waterfall approaches (an asset);* Mastering Azure DevOps (an important asset).
#J-18808-Ljbffr

📌 BI Specialist (Quebec City)
🏢 COFOMO
📍 Quebec City

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: bi specialist (quebec city) / quebec city

Subscribe to this job alert:

Get the latest job offers by email for: bi specialist (quebec city) / quebec city