Data Warehouse Consultant
- Toronto, ON, Canada
Applications open in a new tab.
Job details
- Posting language
- English
- Posted
Original job description
Welcome to Yoush Consulting. Are you an independent IT Consultant or wish to become one?
Are you looking to partner with an organization that presents you to consulting opportunities 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 product for 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, Data
Lake, synapse, SQL managed instance)
More about this job
Responsibilities
The Data Warehouse Consultant at Yoush Consulting will design and build data models and reports for a financial services client. The role also covers testing data and supporting the client's growing reporting needs.
Requirements
Candidates need expert experience in dimensional modelling, T-SQL, DAX, M-Query and Power BI, plus intermediate skills in SQL Server administration and Azure data services. Good communication and experience with sales and financial data are considered assets.
Skills
- Dimensional data modelling
- Data warehouse design
- T-SQL scripting
- Unit testing
- Data validation
- Report design
- Report implementation
- DAX scripting
- DAX Studio
- M-Query
- Power BI
- SQL Server administration
- D365 Dataverse
- Dynamics 365 reporting
- Azure Blob Storage
- Azure Data Lake
- Azure Synapse
- Azure SQL Managed Instance
- Sage GL
- Star AR
- Financial data analysis
- Sales data analysis
- Stakeholder communication
Categories
- Consulting
- Finance & Accounting
- Data & Analytics
- Technology
Keywords
- Data Warehouse
- Data Warehousing
- Dimensional modelling
- T-SQL
- SQL Server
- DAX
- DAX Studio
- M-Query
- Power BI
- Power Query
- Azure
- Azure Synapse
- Azure Data Lake
- Azure Blob Storage
- SQL Managed Instance
- Dynamics 365
- D365 Dataverse
- Sage
- Star financial product
- Business Intelligence
Seniority
Senior
Tools
- Power BI
- SQL Server
- DAX Studio
- Azure Synapse
- Azure Data Lake
- Azure Blob Storage
- Azure SQL Managed Instance
- Sage
- Star
Languages
- English