Data Architect/Modeller

  • Job Category:

    IT Architecture

  • Industry:

    Government I&IT

  • Location:

    Toronto , Ontario

  • Advertised:


  • Position Type:


  • Job Term:

    155 working days

  • Rate:

    $100 Per Hour

  • Job ID:



Requirements: What you'll need


Skills, Knowledge, Experience, and Qualifications



·       Analyzes government information pertinent to business architecture, consults with appropriate government contacts on specific business architecture elements and conducts focus group workshops.

·       Develops and maintains business capabilities of the enterprise in line with the corporate strategy as well as contributing to the business strategy and plans.

·       Develops/revises business architecture artefacts as part of the Enterprise Information Architecture (EIA) Federated Framework and ensures that these are vertically integrated. Models business at enterprise and/or core business levels.

·       Design of capability models and related architectural solutions of business tasks, mapping capability functionality to the internal and external resources,

·       Developing business transformation plans jointly with senior business management,

·       Handling business solutions to the delivery and operational business functions of the company

·       Developing and maintaining architectural governance and controls over implementation

·       For each step of the business transformation plan, business architects contribute in development of a blueprint of the enterprise in order to promote a common understanding of the organization and alignment of strategic objectives with tactical demands


Please note this role is part of a Hybrid Work Arrangement and resource(s) will be required to work at a minimum of 2-3 days per week at 5700 Yonge St.


Evaluation Criteria:


Design Documentation and Analysis Skills (45 points)

  • Demonstrated experience in creating both Functional Design Documents (FDD) & Detailed Design Documents (DDD). –
  • Experience in Fit-Gap analysis, system use case reviews, requirements reviews, coding exercises and reviews.
  • Experience in the development and maintaining a plan to address contract deliverables, through the identification of significant milestones and expected results with weekly status reporting.
  • Work with the Client & Developer(s) assigned to refine/confirm Business Requirements
  • Participate in defect fixing, testing support and development activities for Informatica/ETL tool. Assist with defect fixing and testing support for Cognos reports.
  • Analyze and document solution complexity and interdependencies


BI Data Modelling and Technical Skills (45 points)

  • Understanding of Data Modelling for Business Intelligence including:

a. Expert Knowledge of data warehouse design methodologies, data vault and dimensional modeling in particular

b. Understanding of Extract/Transform/Load processes to transform data for reporting/BI purposes

c. Ability to define schema for reporting databases

d. Experience with advanced modeling tools,

  • Knowledge of BI tools for metadata modeling and report design

a) Cognos 10/11

b) PowerBI

  • Extensive knowledge and experience in MS SQL Server Technology, Azure SQL Database or Synapse, Azure Data Lake
  • Experience using Oracle database server and tools (12c, 19c), PL/SQL for development of Business Intelligence applications. Demonstrated skills in writing SQL stored procedures and packages for datamarts and reporting.
  • Demonstrated experience in performance tuning of Business Intelligence applications, including data model and schema optimization


Knowledge Transfer (10 points)

  • The Architect / Modeler must have previous work experience in conducting Knowledge Transfer and training sessions, ensuring the resources will receive the required knowledge to support the system. The resource must develop learning activities using review-watch-do methodology & demonstrate the ability to prepare and present.
  • Development of documentation and materials as part of a review and knowledge transfer to other members
  • Development of specific activities as part of a review (hand over to ministry staff)and building block approach which, build on knowledge transfer and skills development from the previous stage to the next
  • Development and facilitation of classroom based or virtual instructor demo led sessions for Developers
  • Monitor identified milestones and submission of status reports to ensure Knowledge Transfer is fully completed


Must Haves:


·       7 plus Extensive knowledge and experience in MS SQL Server Technology.

·       3 plus years of Azure SQL Database or Synapse, Azure Data Lake





Please apply for this opportunity by sending your resume directly to


We thank all candidates for their interest but advise that only candidates selected for interviews will be contacted directly. Rest assured that your resume will be kept on our database and will be considered for all future opportunities. 


For more information, please visit us at:


For a full list of our job postings:

***This opportunity is located in Toronto; preference will be given to local candidates. Wirehead does not offer a relocation package. 

We encourage you continue to refer to our Job Listing page as new opportunities become available and updated on a regular basis. Thank you again for your interest in Wirehead!



Request a Sales Call

  • Name
  • Phone
  • Email
  • Message

Ready to talk now?
416-504-5866 ext. 224