Data Architect – Power BI and Azure

Data Architect – Power BI and Azure

THE OPPORTUNITY

Total Systems Solutions Consulting Inc. is seeking a Data Architect – Power BI and Azure to work for our public sector client at the Interior Health Authority in British Columbia. The position is part-time, requiring 12 hours per week, with availability Monday to Friday from 8:00 am to 4:00 pm in the Pacific Time Zone. Occasional office visits will be reimbursed by the Interior Health Authority (receipts must be provided).

The consultant is expected to start in January 2025, with a contract length of 3 months.

Project Context

Interior Health (IH) requires senior consulting resources to assist and support the transition of data from the current SAP reporting environment to the Microsoft Power BI and Azure platform. The Azure architecture has been developed, and the infrastructure for Dev, UAT, and PROD environments has been implemented. DevOps is used for task management and deployment.

Service Required

IH requires assistance and support from senior Data Architect consultants (2) to work alongside the IH Data Platforms team to provide consultation and development in the following areas:

• Analyze the requirements for identified data elements
• Build Dimension Model
• Identify existing source queries/transformation for the data required
• Document requirements/solutions in the data modeling tool (dbSchema)
• Update tasks in DevOps

All tasks and deliverables will be at the direction of IH. Work is expected to start in January 2025, with the contract ending no later than March 31, 2025. However, hours will be front-loaded, and we are looking for a minimum of 12 hours plus per week, depending on sprint planning and readiness of areas to be modeled.

Consultant Qualifications

• Microsoft Silver or Gold Partner
• Demonstrated experience building and delivering large data and analytics projects using Microsoft Azure Analytics stack
• Microsoft Power BI Certification (or equivalent)
• Experience and knowledge migrating from SAP Universes to Azure
• Proven excellent communication skills (verbal & written)
• Healthcare experience
• DevOps experience

Job Types: Part-time, Fixed-term contract
Contract length: 3 months
Pay: Up to $120.00 per hour
Expected hours: 15 per week

Flexible language requirement:
French not required

Schedule:
Monday to Friday

Application question(s):
Where on your resume have you worked in the Healthcare industry building and delivering large data and analytics projects using Power BI and Microsoft Azure?

Experience:

• Power BI - Azure Data Architecture: 5 years (required)
• Microsoft Azure Analytics stack: 3 years (required)
• SAP Universes to Azure: 5 years (required)
• Healthcare: 5 years (required)
• DevOps: 3 years (required)

Work Location: In person

Application deadline: 2025-01-02