Power BI Analyst

COFOMO; Montreal (administrative region); Hybrid; CAD 70,000 - 90,000; Full time

Job summary

COFOMO, a Montreal-based consulting firm with 30+ years of expertise, seeks a Power BI Analyst to develop and maintain dashboards, collaborate with stakeholders, and advance the Power BI environment.

You will extract and model data from multiple sources, design visualizations, manage Power BI Service, and train users, leveraging SQL/PLSQL, DAX, M, and agile practices.

Qualifications

• Minimum 3 years of experience in data analysis.
• 3+ years experience with SQL or PL/SQL.
• Proficient with Power BI for reporting and data access management.
• Experience designing functional dashboards.
• Knowledge of DAX and M language for queries.
• Familiarity with Agile methodologies; Jira and Confluence.
• Ability to produce paginated reports.
• Data modeling using dimensional approaches (star and snowflake).

Responsibilities

• Develop and maintain Power BI reports and dashboards.
• Collaborate with stakeholders to evolve the Power BI environment.
• Extract, cleanse, and structure data from multiple sources.
• Design attractive, functional visualizations.
• Administer Power BI Service workspaces and apps.
• Train users and support adoption.
• Document data models and reporting solutions.
• Ensure accuracy and relevance of Power BI content.

Skills

Power BI

SQL/PLSQL

Dashboard design

DAX & M language

Query optimization

Agile/Jira/Confluence

Paginated reports

Dimensional modeling

Tools

Toad Data Point

Qlik Sense

QlikView

Tableau

Job description

# Power BI AnalystMontrealHybridCloud and InfrastructureApplyWith 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 descriptionHere is a brief overview of the tasks and responsibilities that will fall to you:* Develop and maintain reports and dashboards that meet business needs;* Contribute to the implementation and evolution of the Power BI environment in collaboration with stakeholders and in accordance with the established architecture framework;* Extract, cleanse, analyze and structure data from different sources to feed data counters;* Design visualizations that are attractive, functional, and in line with organizational best practices;* Administer workspaces and distribution apps in Power BI Service;* Maintain up-to-date access to reports, dashboards and workspaces;* Collaborate with the various teams to collect and understand their information needs;* Ensure the accuracy, relevance, and consistency of the information presented in Power BI;* Document reports, data models and solutions developed according to established standards;* Train and support users in the use of Power BI Service;* Popularize technical concepts to non-specialized stakeholders.The profile sought is as follows:* Have a minimum of three (3) years of experience in data analysis;* Have been proficient in SQL or PL/SQL programming for at least three (3) years;* Use at least one data visualization or analysis tool from Toad Data Point, Qlik Sense, QlikView, and Tableau;* Have been designing functional dashboards for at least three (3) years presenting the indicators in a clear and concise manner;* Demonstrate a minimum of three (3) years of experience with Power BI in reporting and data access management;* Develop, debug, and optimize complex queries using DAX and the M language;* Apply query optimization mechanisms, including query folding;* Produce paginated reports as part of at least one mandate;* Model data using a dimensional approach, including star and spoke diagrams;* Know agile methodologies as well as Jira and Confluence tools.Apply