Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Bi Specialist

COFOMO

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 onthe 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 maintainan 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 AzureDevOps 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).#J-18808-Ljbffr
Vacancy posted more than 2 months ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Bi Specialist. Be the first to apply!