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