Apply now

Posted 166 months ago

Data Warehouse Architect

@ system canada technologies

Toronto, Ontario

On-siteContract
Apply now
SIGNALS

Overview

SystemCanada is hiring a contract Data Warehouse Architect for a very large corporate enterprise data warehouse (EDW) initiative. The role covers logical and physical database design, change releases across environments, and performance tuning, working with business analysts, ETL and Cognos teams.

Responsibilities:

  • Develop and maintain logical and physical database designs for an enterprise data warehouse
  • Package and release database changes across all environments
  • Tune database performance for queries and data movement
  • Work with business analyst, ETL and Cognos teams on requirements and data models

Requirements summary:

  • Experience with ERWin for data modeling
  • Experience with data warehouse design and performance tuning
  • Strong communication with functional and technical team members

Tools & skills

Source and dates

Employer career site / ATS feed · smartrecruiters

Employer posting date
2013-03-13
First seen by our source
2026-10-14
Source record updated
2026-10-14

These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.

Job details

DepartmentIT
Work settingOffice
PositionMostly sitting
Physical demandsphysical low · computer high
LanguagesEnglish

Summary and details written by AI from the posting; the employer’s posting is the authority.

system canada technologies

FieldValue
Open jobs on Jobsy399
Job description

Company Description

SCT resources have a broad range of skills in different technologies. The large skill-set has been made possible by a conscious focus on strengthening our skills base. Every person selected for our team brings something new, something that adds to our offerings. We learn continuously, both on the job and through formal training programs.

Job Description

Company: SystemCanada | www.systemcanada.com

World wide office: Canada - USA - Australia - UK - South Africa - New Zealand - Ireland - Japan

Job Description

  • Develop and maintain logical database designs across multiple projects for a very large corporate EDW initiative using ERWin
  • Be responsible for packing and release of all database changes across all environments
  • Work with all development teams on performance issues and tuning
  • Communicate frequently with both functional and technical team members to fully understand and validate requirements and resolve conflict
  • Work with the business analyst, ETL and Cognos Development teams to fully understand the requirements and design / support the logical and physical data models
  • Develop and maintain physical database design and implementation including tuning required for performance of query and data movement operations

Similar jobs

  • Systems Testing/QA Specialist - Senior, 7 months contract

    Toronto, ON

    Dimensional Tech Inc.

    10+ YOE• The focus would be on manual testing over automation testing; • 10+ years of experience in software testing in enterprise-level IT environments and large-scale systems; • Hands-on working experience in manual testing…

    Test automation

    Long-term & 3 openings! Project Manager/Leader - Senior, 1 yr contract + ext. 2 years

    Toronto, ON

    Dimensional Tech Inc.

    5+ YOE• At least 5 years of audio-visual and videoconferencing technology experience; • At least 5 years of project management experience; • Knowledge of best practices for audio-visual, communications and IT deployment

    Videoconferencing, Project management

    Replacement & Hybrid! Product Manager - Senior, 5 months contract

    Toronto, ON

    Dimensional Tech Inc.

    • Product Road Map Development (5 year+ of exp); • Azure DevOps (5 year+ of exp); • Cross-Functional Role

    DevOps

    Systems Testing/QA Specialist - Senior, 7 months contract

    Toronto, ON

    Dimensional Tech Inc.

    *The focus would be on manual testing over automation testing*; • 10+ years of experience in software testing in enterprise-level IT environments and large-scale systems; • Hands-on working experience in manual testing…

    Hybrid! ETL developer - Senior, 7 months contract

    Toronto, ON

    Dimensional Tech Inc.

    • Significant hands-on experience designing and developing scalable, production-grade data pipelines for AI/ML and Generative AI workloads, including data ingestion, transformation,…; • Advanced hands-on expertise in…

    Data engineering, ML, Python, SQL, Microsoft Azure, Machine learning

    Hybrid! Data Science Developer - Senior, 6 months contract

    Toronto, ON

    Dimensional Tech Inc.

    • Significant experience designing enterprise data architectures and conceptual, logical, and physical data models for AI/ML, Generative AI, analytics, and cloud workloads, including the…; • Deep technical expertise in…

    Data models, ML, Data engineering, Microsoft Azure, Machine learning

    Hybrid! Data Science Developer - Senior, 7 months contract

    Toronto, ON

    Dimensional Tech Inc.

    • Advanced hands-on expertise in Python, software engineering, LLMs, RAG, agentic AI, APIs, prompt engineering, model evaluation, and production AI development; • Strong hands-on experience with Microsoft Foundry/Azure…

    Python, Microsoft Azure, Machine learning, SQL, Microsoft Power Automate, Git

    Hybrid! Data Science Developer - Senior, 7 months contract

    Toronto, ON

    Dimensional Tech Inc.

    • Deep expertise in statistics, probability, predictive modelling and machine learning, including classification, regression, clustering, feature engineering, experimentation, model…; • Advanced hands-on proficiency in…

Locations & environments

Locations

All of CanadaRemote · Hybrid · On-site · Field

Pro tip: add remote jobs to widen your search.

Exclude locations

Workplace type

Company jobs in these results

These are this company’s jobs loaded in your current search. The company may have more openings.