Senior Data Architect/Modeller

5 days ago

Toronto, Ontario, Canada Teckhorizon Inc Full time

About The Role
We are seeking a
Senior Data Architect / Data Modeller
to design, develop, and implement enterprise-level data architecture solutions in a complex, distributed environment. The successful candidate will play a key role in shaping data warehouse and analytics solutions that support business intelligence, reporting, and insights generation across the organization.

This is a
hands-on, onsite role
requiring strong technical expertise, stakeholder collaboration, and documentation skills.

Key Responsibilities

  • Design and implement enterprise data architecture for application development, BI, and analytics
  • Define data flow, database structures, storage strategies, and access methods
  • Design and maintain enterprise data models and data dictionaries
  • Translate complex business and technical requirements into executable development work packages
  • Collaborate with business stakeholders to understand reporting and analytics needs
  • Support ETL pipeline development, testing, defect resolution, and performance tuning
  • Optimize data models, schemas, and database performance
  • Coordinate with integration teams to identify future data and reporting requirements
  • Produce and maintain high-quality functional and detailed design documentation
  • Support Power BI reporting and analytics solutions
  • Lead knowledge transfer and training sessions for client and development teams

Must-Have Skills & Experience

  • 7+ years of experience in data modelling and data warehouse design
  • 2+ years hands-on experience with Azure Data Lake and Azure Databricks SQL Warehouse
  • 5+ years strong SQL experience (T-SQL preferred)
  • Expert knowledge of dimensional modeling and Delta Lake concepts

  • Proven experience building enterprise data warehouse solutions on the Microsoft Azure stack:

  • Azure Data Lake

  • Azure Databricks
  • Azure Data Factory (ADF)

  • Power BI

  • Experience with BI metadata modeling and report design (Power BI)

  • Strong experience with MS SQL Server technologies
  • Proficiency in writing and optimizing SQL stored procedures for reporting and datamarts
  • Experience with performance tuning and schema optimization
  • Hands-on experience with Azure DevOps

Nice-to-Have / Assets

  • Experience with IBM Curam COTS solutions (Social Assistance Management Systems)
  • Knowledge of ETL design concepts
  • Experience with Oracle databases and PL/SQL

  • Familiarity with enterprise architecture frameworks and tools:

  • TOGAF

  • ArchiMate

  • Zachman

  • Experience using data modeling tools such as SAP PowerDesigner or Visio

  • Data Architect/Modeller – Senior

    6 hours ago

    Toronto, Ontario, Canada 2iSolutions Inc. Full time

    We are seeking a Senior Data Architect/Modeller for a 1-year contract opportunity in Toronto, ON. This is an onsite role.Must haves:5+ years of experience working with federal/provincial/broader public-sector healthcare providers.7+years experiences in developing conceptual, logical and physical data models for structured, semi-structured, and unstructured...

  • Data Architect/Modeler – Senior

    7 days ago

    Toronto, Ontario, Canada Avanciers Inc. Full time

    Avanciers Incorporated is hiring a Data Architect/Modeler – Senior for one of our clients.Job Title: Data Architect/Modeler - SeniorJob Location:Toronto, ON - OnsiteEmployment Type:ContractDuration: 6 monthsThis is an active job and application deadline is January 30, 2026(This posting may close earlier if a suitable candidate is found)Job description:Data...

  • Data Architect/Modeller

    2 days ago

    Toronto, Ontario, Canada Russell Tobin Full time

    Senior Data Architect / Data ModellerLocation: Toronto, ON (Onsite)Pay Rate: CAD$90/Hr-CAD$100/HrOverviewSeeking a Senior Data Architect/Data Modeller to advance enterprise data management and metadata practices. The role supports the implementation of metadata management tools, improves data quality and interoperability, and aligns data architecture with...

  • RQ00466 - Data Architect/Modeller - Senior

    1 week ago

    Toronto, Ontario, Canada Source Code Full time

    RQ00466 - Data Architect/Modeller - Senior 3-month contract, possible extenison  Ontario Health Hybrid 3 days in office - 525 University Ave 1 submission - 1 opening Background Information: Ontario Health is seeking a senior data architect/modeller to help the advancement of its current data management practices. This project to support the utilization of...

  • Senior Data Architect

    6 hours ago

    Toronto, Ontario, Canada Galent Full time

    We have an immediate opening for aSenior Data Architectwith a leading IT Service Consulting company inToronto, Ontario, Canada .Senior Data ArchitectLocation : Toronto, CanadaPosition : FulltimeJD:Senior Data Architect – GCP Role OverviewWe are seeking a visionary and hands-on Senior Data Architect with 10+ years of experience to lead the design and...

  • RQ00503 - Senior Data Architect/Modeller

    8 hours ago

    Toronto, Ontario, Canada Amyantek Full time

    Please send your resume at if you are interested in this 30 days contract with Supply Ontario (Ontario Agency for Health Protection and Promotion) with a possibility of extension, If you are not interested, please feel free to pass it in your network for anyone looking for work.Job Title:RQ Senior Data Architect/ModellerWorking Status:RemoteLocation:661...

  • Senior Data Architect

    8 hours ago

    Toronto, Ontario, Canada StafinGo Full time

    Senior Data Architect / Data Modeller (Public Sector)Stafingois hiring aSenior Data Architect / Data Modellerto support apublic sector clientundergoing a major transformation of its enterprise data and metadata management capabilities. This is a senior-level consulting engagement suited for professionals with extensive experience in complex, regulated...

  • data architect/modeller

    5 days ago

    Toronto, Ontario, Canada SOFTLINE TECHNOLOGY Full time

    ResponsibilitiesDevelops and implements the data architecture for application development in a complex and distributed environment, including the determination of the flow and distribution of data, the location of databases, and data access methods.Experience RequirementsData Modeler Requirements:7+ years BI Data Architect experience in enterprise...

  • Data Architect/Modeller

    1 hour ago

    Toronto, Ontario, Canada Russell Tobin Full time

    **Job Title: BI Data Architect / Data ModelerLocation: Toronto, ON (Onsite)Duration: 5+ MonthsClient: Public SectorPay Rate: CAD 85-90/hr**Job Description ResponsibilitiesDesign and implement enterprise data architecture for BI and analytics.Develop and maintain data warehouse, data lake, and dimensional models.Translate business requirements into scalable...

  • Senior Data Architect

    1 hour ago

    Toronto, Ontario, Canada TechDoQuest Full time

    Min 10 years of experience neededRole OverviewWe are seeking a visionary and hands-on Senior Data Architect with 10+ years of experience to lead the design and implementation of scalable, secure, and high-performance data architectures across GCP, AWS, and Azure. This role is central to our cloud-first strategy, enabling advanced analytics, AI/ML, and...