20 Nov
|
COFOMO
|
Montreal
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 workplace; * 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).
📌 Bi Specialist (Montreal)
🏢 COFOMO
📍 Montreal