RQ10622 - Data Architect/Modeller - Senior

We're seeking RQ10622 - Data Architect/Modeller - Senior for the Ministry of Public and Business Service Delivery and Procurement. This hybrid role in Toronto designs enterprise data warehouses using dimensional/delta lake modeling, Azure Data Lake/Databricks SQL Warehouse, PowerBI metadata, and Oracle PL/SQL stored procedures across 248 business days (probable extension).

Position Details

Client:

Ministry of Public and Business Service Delivery and Procurement

Location:

Toronto, Ontario (Hybrid)

Start Date:

April 1, 2026

End Date:

March 31, 2027

Duration:

248 business days (probable extension)

Hours:

7.25 hours per day

Security Level:

CRJMC

Deadline:

Monday, February 23, 2026, 10:00 AM EST (ACTIVE)

Must Haves

7+ years data modeling/data warehouse design; 2+ years Azure Data Lake/Databricks SQL Warehouse

5+ years SQL (T-SQL/PL-SQL stored procedures/packages); MS SQL Server/Oracle

BI data warehousing (dimensional/delta lake); PowerDesigner/Visio modeling tools

Skill Weights

BI Data Modelling (40%):

Data warehouse design; ETL/ELT; schema definition; Azure Data Lake/Databricks/PowerBI; performance tuning

Design Documentation (30%):

FDD/DDD; Fit-Gap analysis; requirements reviews; solution complexity documentation

Quality Assurance (20%):

Test plans execution; database design refinement

Knowledge Transfer (10%):

Training sessions; review-watch-do methodology; status reporting

Assets

Curam IBM COTS (Social Assistance Management System)

ETL/ELT design; Enterprise Architecture frameworks (ArchiMate/TOGAF/Zachman)

How to Apply Submit

ALL

mandatory documents to

hrsmss@smsoftconsulting.com

by

Monday, February 23, 2026, 10:00 AM EST :

Updated Resume (Word format) (Mandatory)

References (Mandatory)

Expected hourly rate (Mandatory)

Visa Status (Mandatory)

LinkedIn ID (Mandatory)

Without mandatory documents, we cannot submit a candidate.

Additional Information

Hybrid schedule

CRJMC security clearance required

Azure DevOps; data dictionary maintenance; business process documentation

ACTIVE OPPORTUNITY

- Submit qualified Data Architects with Azure Databricks/PowerBI modeling experience immediately. Join WhatsApp for updates: https://chat.whatsapp.com/KCmWoqPlxWvAZmyXLcd8or.

#J-18808-Ljbffr