Data Warehouse Consultant

Yoush Consulting; Toronto; On-site; CAD 50,000 - 75,000; Full time

Job summary

A consulting firm is looking for a Data Warehouse Consultant in Toronto on a 6-month contract. This role involves designing data warehouses and requires expertise in T-SQL scripting and Power BI. Strong communication skills and experience in financial data are essential. Candidates with prior experience in SQL Server and Azure data platforms will have an advantage. This opportunity allows for significant professional growth in the financial services sector.

Qualifications

• Expert experience in data warehouse design and dimensional data modelling.
• Strong communication skills and experience with financial data.
• Intermediate experience with Azure data platform.

Skills

Dimensional data modelling

Data warehouse design

T-SQL scripting

Report design

DAX Scripting

Power BI

Tools

SQL Server

Azure data platform

D365 Dataverse

Job description

Welcome to Yoush Consulting. Are you anindependent IT Consultant or wish to become one?

Are you looking to partner with anorganization that presents you to consultingopportunities and supports you as a partner?

Data Warehouse Consultant (6 month contract to start)

Our client in the Financial Services industry is looking for talented individuals to help them in increasing their capacity in response to growing demand. In addition to the technical skills, good communication and experience in dealing with sales and financial data are considered great assets.

Experience with the Star financial productfor AR and Sage for GL would be a big bonus.

Requirements

Expert Experience with

• Dimensional data modelling and data warehouse design
• T-SQL scripting
• Unit testing and data validation
• Report design and implementation
• DAX Scripting, DAX Studio
• M-Query
• Power BI

Intermediate level experience with

• SQL Server administration
• D365 Dataverse and reporting
• Azure data platform(BloB storage, DataLake, synapse, SQL managed instance)