Power BI with SQL

TEEMA; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading company in Toronto is seeking a Power BI Developer with SQL expertise. The role involves developing operational reports, building automated dashboards, and utilizing the Microsoft BI Stack. Candidates must have significant experience in data preparation and banking.

Qualifications

• Over 5 years of experience with Microsoft BI Stack.
• 3-4 years of experience with self-service tools like Power BI or Tableau.

Responsibilities

• Develop operational reports and dashboards using Power BI.
• Understand business requirements for reporting applications.

Skills

Data Preparation

Data Warehousing

Business Intelligence

SQL

Power BI

TSQL

MDX

DAX

Education

BSc in Computer Science

MSc in Information Systems

Tools

Power BI

SSRS

SSAS

SSIS

Tableau

Job description

Job Title: Power BI with SQL

Job ID: 79835

Location: Toronto, Ontario

What you will be doing:

1. Develop operational reports
2. Build automated reports and dashboards using Power BI and other reporting tools
3. Understand business requirements to define functional specifications for reporting applications
4. Utilize tools and systems on MS SQL Server BI Stack, including SSRS, TSQL, Power Query, MDX, Power BI, and DAX
5. Transform data into reporting and analytics solutions efficiently
6. Create functional reports
7. Possess knowledge of database fundamentals such as multidimensional database design and relational database design

What you must have:

1. BSc or MSc in Computer Science or Information Systems, with relevant work experience
2. Over 5 years of experience in data preparation, data gateway, and data warehousing projects
3. Over 5 years of experience with the Microsoft Business Intelligence Stack (Power BI, SSAS, SSRS, SSIS)
4. 3-4 years of experience with self-service tools like Power BI or Tableau
5. Banking experience is mandatory

For more information about TEEMA and to explore other career opportunities, please visit our website at www.teemagroup.com