Power Bi (Data Services)

Role: Power BI (Data Services)

Location: Montreal, QC (Hybrid)

Type: Contract/ Full Time

:

· Understand business requirements to set functional and technical specifications

· Build automated reports and dashboards with the help of Power BI and other reporting tools

· Be experienced in tools and systems on MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, PowerBI, and DAX

· Be able to quickly shape data into reporting and analytics solutions

· Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more

Responsibilities

· To understand business requirements in the BI context and design data models to convert raw data to meaningful insights.

· To create dashboards and visual interactive reports using Power BI.

· To identify KPIs with clear objectives and monitor them consistently.

· To analyze data and present it through reports that can help in decision-making.

· To be able to convert business requirements into technical specifications and decide the timeline to accomplish tasks.

· To design, develop, and deploy Power BI scripts and perform efficient detailed analysis.

· To perform DAX queries and functions in Power BI.

· To create charts and document data with algorithms, parameters, models, and relations explanations.

· To conduct data warehouse development (if required).

· To perform SQL querying for best results.

· To use filters and graphs for a better understanding of the data.

· To define and design new systems by analyzing current ETL processes.

· To make technical changes to existing BI systems in order to enhance their working.