Search Jobs

Data Warehouse Developer (MSSQL)

About the Company

Our client is a service organization in Ontario, and they are looking to hire a Data Warehouse Developer for a remote full-time position.

About the Opportunity

• This is a mostly remote full time position (office in GTA West end)
• This role will be dealing with company data warehouses (MSSQL), ETL and Bi
• There are various sources of data - MS Dynamics CRM, MS Dynamics GP, and their ecommerce website
• This role will be dealing with moving appropriate data to the Data Warehouse (some of it is already created, some will have to be built from scratch) on MSSQL,
• SSIS/SSAS is used to set up the data for visualization/reporting using SSRS and PowerBI
• This role will also talk to the business units sometimes to understand what data they need and in what format, in what timeframes, etc.

About You

• Experience building and maintaining Data Warehousing on MSSQL
• Experience with ETL - SSIS / SSAS
• Strong SQL / T-SQL / stored procedures, query tuning
• Experience with reporting - SSRS and/or PowerBI
• Good communication skills
• MS Dynamics (CRM or ERP) exposure is a plus
• PowerBI experience is a bonus

Salary Range

$95,000.00/year

How to Apply

Click the “Apply Now” button and follow the instructions to submit your resume. Please know that we only accept documents in MS Word or Rich Text formats.

When referencing this job, quote # 325195

You must currently reside within the Greater Toronto Area and be permitted to work in Canada to be considered for this opportunity. A recruiter will be in touch with you if your profile meets our client’s requirements for this role.