Remote Data Architect: MS BI & Healthcare Analytics

S.i. Systems; Ottawa; Remote; CAD 90,000 - 120,000; Full time

Job summary

A healthcare technology consulting firm is seeking a seasoned Data Architect to develop and deliver crucial MIS reports and case costing data extracts. The ideal candidate should have over 5 years of experience with MS BI Stack, data management, and project management skills. This role will work remotely and is crucial for a significant healthcare project, focusing on data architecture in a healthcare environment.

Qualifications

• 5+ years of experience with MS BI Stack (SSRS, SSAS, SSIS, SSMS).
• 5+ years of DBA experience.
• Excellent knowledge of data backup, security, and integrity.
• Strong understanding of Data Security.
• Ability to work with MS SQL, Oracle, and NoSQL environments.

Responsibilities

• Develop and optimize database models for electronic medical records.
• Design and implement project data-related needs.
• Programmatically automate reports using SQL, SAS, SSRS, SSIS.
• Conduct analysis and design data models for migration.
• Participate in archival and migration strategies.

Skills

MS BI Stack expertise (SSRS, SSAS, SSIS, SSMS)

Database management

Data analysis

SQL proficiency

ETL and data model design

Oracle knowledge

Analytical skills

Project management

Education

Bachelor's degree or Community College diploma related to computer technology

Tools

SQL Server

Python

R

Job description

A healthcare technology consulting firm is seeking a seasoned Data Architect to develop and deliver crucial MIS reports and case costing data extracts. The ideal candidate should have over 5 years of experience with MS BI Stack, data management, and project management skills. This role will work remotely and is crucial for a significant healthcare project, focusing on data architecture in a healthcare environment.