25-053 Data Architect

1 week ago

Pickering, Ontario, Canada Morson Full time $176,800 - $208,000 per year

Job Description
Data Architect

Resume Due Date: Monday, April 14, :00PM EST)
Number of Vacancies: 1
Level: MP6
Hourly Rate: $85 - $100/hour
Duration: 12 Months
Hours of work: 35
Location: 889 Brock Road, Pickering (Hybrid – 4 days remote)

Job Overview

JOB FUNCTION

As a Data Architect you will be responsible for leading the Azure architecture. design and delivery of data models and data products which enable innovative, customer-centric digital experiences. You will be working as part of a cross-discipline agile team who helps each other solve problems across all business areas. You will be a thought leader and subject matter expert on data lake & data warehousing and modeling activities for the team and use your influence to ensure that the team produces best-in­ class data solutions that leverage repeatable, maintainable, and well-documented design patterns. You will employ best practice in development, security, accessibility and design to achieve the highest quality of service for our customers.

JOB DUTIES
  • Lead the architecture. design and oversee implementation of modular and scalable data ELT/ETL pipelines and data infrastructure on Azure and Databricks leveraging the wide range of data sources across the organization
  • Design curated common data models that offer an integrated, business-centric single source of truth for business intelligence, reporting, and downstream system use
  • Work closely with infrastructure and cyber teams to ensure data is secure in transit and at rest
  • Create, guide and enforce code templates for delivery of data pipelines and transformations for structured, semi-structured and unstructured data sets
  • Develop modeling guidelines that ensure model extensibility and reuse by employing industry standard disciplines for building facts, dimensions, bridge, aggregates, slowly changing dimensions and other dimensional and fact optimizations
  • Establish standards database system fields, including primary and natural key combinations that optimize join performance in a multi-domain. multiple subject area physical (structured zone) and semantic model (curated zone)
  • Ensure model extensibility by employing industry standard disciplines for building facts, dimensions, bridge, aggregates, slowly changing dimensions and other dimensional and fact optimizations
  • Transform data and map to more valuable and understandable semantic layer sets for consumption, transitioning from system­ centric language to business-centric language
  • Collaborate with business analysts, data scientists, data engineers, data analysts and solution architects to develop data pipelines to feed our data marketplace
  • Introduce new technologies to the environment through research and POCs. and prepare POC code designs that can be implemented and productionized by developers
  • Work with tools in the Microsoft Stack; Azure Data Factory, Azure Data Lake, Azure SQL Databases, Azure Data Warehouse, Azure Synapse Analytics Services, Azure Databricks, Microsoft Purview, and Power Bl
  • Work within the agile SCRUM work management framework in delivery of products and services, including contributing to feature & user story backlog item development, and utilizing related Kanban/SCRUM toolsets
  • Document as-built architecture and designs within the product description
  • Design data solutions that enable batch, near-real-time, event-driven, and/or streaming approaches depending on business requirements
  • Design & advise on orchestration of data pipeline execution to ensure data products meet customer latency expectations, dependencies are managed, and datasets are as up-to-date as possible, with minimal disruption to end-customer use
  • Ensure that designs are implemented with proper attention to data security, access management. and data cataloging requirements
  • Approve pull requests related to production deployments
  • Demonstrate solutions to business customers to ensure customer acceptance and solicit feedback to drive iterative improvements
  • Assist in troubleshooting issues for datasets produced by the team (Tier 3 support), on an as-required basis
  • Guide data modelers, business analysts and data scientists in the build of models optimized for KPI delivery, actionable feedback/writeback to operational systems and enhancing the predictability of machine learning models and experiments
  • Develop Bicep or Terraform templates to manage Azure Infra as code
  • Perform hands on data engineering work to build data ingestion and data transformation pipelines
Qualifications

EDUCATION
  • Requires an extensive knowledge in designing a data model to solve a business problem, specifying a data pipeline design pattern to bring data into a data warehouse, optimizing data structures to achieve required performance, designing low-latency and/or event-driven patterns of data processing, creation of a common data model to support current and future business needs.
  • This knowledge is considered to be normally acquired through the completion of a four year University education in computer science. computer/software engineering or other relevant programs within data engineering, data analysis, artificial intelligence, or machine learning.
EXPERIENCE
  • Experience guiding data lake ingestion and data modeling projects in the Azure cloud environment; experience in modeling relational and in-memory models with star/snowflake schemas; experience with designing and implementing event-driven (pub/sub), near-real-time, or streaming data solutions, involving structured, semi-structured and unstructured data across various platforms and.
  • A period of over 6 years and up to and including 8 years in data modeling, data warehouse design, and data solution architecture in a Big Data environment is considered necessary to gain this experience.

  • 25-108 Senior Data Engineer

    1 day ago

    Pickering, Ontario, Canada Morson Full time $90,000 - $120,000 per year

    Job DescriptionPosition:  Senior Data EngineerResume Due Date: Wednesday, June 25, :00PM EST Number of Vacancies: 2Level:  MP4 upto $90/hr INCDuration: 12 MonthsHours of work:     35Location: 889 Brock Road, Pickering (Hybrid – 4 days remote)Job OverviewAs a Senior Data Developer, you will be responsible for building and supporting the data driven...

  • 25-010 Senior Data Developer

    1 day ago

    Pickering, Ontario, Canada Morson Full time $416,000 per year

    Job Description Senior Data DeveloperLevel: MP5Hourly Rate: $80 - $95/hourDuration: 10 MonthsHours of work: 35Location: 889 Brock Rd., Pickering (100% Remote)Job OverviewJOB FUNCTIONAs a Senior Data Developer, you will be responsible for building and supporting the data driven applications which enable innovative, customer centric digital experiences.You...

  • 25-136 SAP Digital Engineer

    5 days ago

    Pickering, Ontario, Canada Morson Full time $90,000 - $120,000 per year

    Job DescriptionTitle:  Digital Engineering ArchitectResume Due Date: Monday, Oct 27th, :00PM EST Number of Vacancies: 2Level:  MP6Duration:  24 MonthsHours of work:  40Location:  Temp: 700 U (Hybrid – 2 days remote) Base: Oshawa (on rotating schedule from Aug 25)Job OverviewAbout the Role:As a Digital Engineering Architect at OPG, you will play a...

  • 25-138 ERP Program Data Migration Lead

    1 week ago

    Pickering, Ontario, Canada Morson Full time $120,000 - $180,000 per year

    Job DescriptionWe are currently requesting resumes for the following position:  ERP Program Data Migration LeadResume Due Date: Monday, August 18, :00PM EST)Number of Vacancies: 2Level:  MP6Duration:  24 MonthsHours of work:  40Location:  Temp: 700 U (Hybrid – 2 days remote) Base: CHQ (on rotating schedule from Aug 25)Job OverviewPosition...

  • 25-082 ServiceNow CMDB data Administrator

    1 week ago

    Pickering, Ontario, Canada Morson Full time $85,000 - $120,000 per year

    Job Description ServiceNow CMDB data AdministratorResume Due Date: Tuesday Aug 5th 2025, 5 PMNumber of Vacancies: 2Level: MP4 Hourly Rate: $85 - $100/hour Duration: 12 MonthsHours: 35Location: 889 Brock Road, Pickering (Hybrid – 3 days remote)*Needs to be able to working from the Oshawa location after oct 2025Job OverviewJob Summary:We are seeking a...

  • 25-090 - Business Analysts

    1 week ago

    Pickering, Ontario, Canada Morson Full time $60,000 - $84,000 per year

    Job DescriptionTitle: Business Analysts 25-090Resume Due Date: Thursday, May 22nd, :00PM EST)Number of Vacancies: 1Level:  MP4 (5 – 10 Years Experience) Rate: $60-$70 /hr INCDuration: 12 MonthsHours of work: 35Location: 889 Brock Road, Pickering (Hybrid – 2 days remote)Job OverviewParticipate in all phases of the project life-cycle: Initiation,...

  • 25-129 - FinOps Product Owner/Practitioner

    1 day ago

    Pickering, Ontario, Canada Morson Full time $104,000 - $208,000 per year

    Job DescriptionTitle: FinOps Product Owner 25-129Resume Due Date: Wednesday Oct 1st, :00PM EST)Number of Vacancies: 1Level: MP4Hourly Rate: Up to $100/hourDuration: 12 MonthsHours of work: 35Location: (hybrid – 3 days remote)Temp: 889 Brock Road PickeringBase: Oshawa office on rotating scheduleJob OverviewThe FinOps Product Owner leads the vision,...

  • 25-125 FinOps Engineer

    7 days ago

    Pickering, Ontario, Canada Morson Full time $70,000 - $90,000 per year

    Job DescriptionTitle:  FinOps EngineerResume Due Date: Friday Sept 26th, :00PM EST Number of Vacancies: 1Level:  MP4, $70- $90/hr INCDuration:  12 MonthsHours of work:  35Location: (Hybrid – 1 day remote)Temp: 889 Brock RoadBase: CHQ (rotating schedule from September 01, 2025)Job OverviewThe FinOps Engineer/Practitioner is responsible for implementing...

  • 25-046 Business Analyst

    7 days ago

    Pickering, Ontario, Canada Morson Full time $55,000 - $70,000 per year

    Job Description Business AnalystResume Due Date: Thursday, April 03, :00PM EST)Number of Vacancies: 1Level: MP2Hourly Rate: $55 - $70/hour INCDuration: 24 MonthsHours of work: 35Location: 1855 Energy Drive (100% on-site)Job OverviewProvide business process and support to Department Supervisor/Manager within the accountabilities of the Department.Carry out...

  • 25-103 Senior IT Service Management Advisor

    1 week ago

    Pickering, Ontario, Canada Morson Full time $80,000 - $120,000 per year

    Job DescriptionTitle:  Senior IT Service Management AdvisorResume Due Date: Wed, June 18th :00PM EST Number of Vacancies: 2Level:  MP4 - up to $95/hr Incorp Duration: 12 MonthsHours of work:     35Location: 889 Brock Road (Hybrid – 2 days Remote)Job OverviewThe Senior IT Service Management Advisor is a highly skilled Major Incident Commander...