Remote Data Architect: MS BI & Healthcare Analytics

S.i. Systems; Regina; Remote; CAD 90,000 - 110,000; Full time

Job summary

A leading technology consulting firm in Canada is looking for an experienced Data Architect with strong expertise in the MS BI Stack (SSRS, SSAS, SSIS, SSMS). This remote role involves developing and delivering crucial MIS reports for a healthcare client, focusing on data architecture, transformation, and analytics. The ideal candidate will have relevant experience, particularly in managing data warehouse projects, and possess excellent analytical skills. The position is for a duration of 4 months with likely extensions.

Qualifications

• 5+ years of experience with MS BI Stack (SSRS, SSAS, SSIS, SSMS).
• 5+ years of DBA experience.
• Strong understanding of data architecture and transformation strategies.
• Excellent knowledge of SQL and data warehouse management.

Responsibilities

• Develop and optimize database models for healthcare data.
• Implement project data-related needs and maintain data integrity.
• Collaborate on programming and automate reporting solutions.
• Migrate data and design comprehensive data models.

Skills

Experience with MS BI Stack (SSRS, SSAS, SSIS, SSMS)

DBA experience

Data warehouse management

Data backup and recovery

ETL and Data design

Data security

SQL proficiency

Analytical skills

Education

Bachelor's degree or Community College diploma in computer technology

Tools

SQL Server

Oracle

Python

R

Job description

A leading technology consulting firm in Canada is looking for an experienced Data Architect with strong expertise in the MS BI Stack (SSRS, SSAS, SSIS, SSMS). This remote role involves developing and delivering crucial MIS reports for a healthcare client, focusing on data architecture, transformation, and analytics. The ideal candidate will have relevant experience, particularly in managing data warehouse projects, and possess excellent analytical skills. The position is for a duration of 4 months with likely extensions.