MGIS Inc. Logo

MGIS Inc.

Data Architect

Posted 4 Days Ago
Be an Early Applicant
Remote
Hiring Remotely in CAN
Mid level
Remote
Hiring Remotely in CAN
Mid level
Lead design and governance of enterprise data architecture and cloud migrations. Design data models, integration frameworks (ETL/ELT, APIs, streaming), and SharePoint/M365 migrations. Define data governance, security, and lifecycle policies; document architectures and enable adoption across teams. Support Azure-based platform modernization and performance optimization.
The summary above was generated by AI

This is a remote position.

Overview

This is a remote consulting opportunity supporting a government client.

Subcontractor Opportunity: This is not an employee position. The successful consultant must be incorporated and able to provide services through their corporation.

Role Summary

The Data Architect provides strategic and technical leadership for enterprise data environments, defining and governing data architecture to support analytics, artificial intelligence, and evidence-based decision making. The role is responsible for designing scalable, secure, and integrated data platforms that enable effective data management across departments and systems.

With a strong focus on modernization, the Data Architect leads the transformation from legacy and on-premise data and file systems to cloud-based platforms, including Microsoft 365 and SharePoint Online. The role ensures that data solutions are aligned with enterprise architecture standards, information management requirements, and regulatory obligations, while enabling accessibility, interoperability, and long-term sustainability.


Key Responsibilities

Enterprise Data Architecture

  • Define and maintain enterprise data architecture strategies, standards, and target-state models aligned with organizational priorities
  • Develop data architecture blueprints covering data ingestion, storage, integration, access, and lifecycle management
  • Establish and promote data architecture principles, patterns, and reference models across the organization
  • Ensure alignment between data architecture, enterprise architecture, and digital transformation initiatives

Data Modelling and Design

  • Design conceptual, logical, and physical data models to support business applications, analytics, and reporting needs
  • Ensure data models are scalable, reusable, and optimized for performance and integration
  • Define standards for metadata, data classification, and data structures across enterprise systems
  • Support the design of data warehouses, data lakes, and hybrid data solutions

Data Integration and Platform Architecture

  • Design and implement integration frameworks supporting ETL, ELT, APIs, and real-time data streaming
  • Define data exchange patterns to enable interoperability between systems and platforms
  • Ensure integration approaches align with enterprise standards, security requirements, and performance expectations
  • Support implementation of cloud-based data platforms, with a strong emphasis on Microsoft Azure services

SharePoint and M365 Data Migration

  • Lead migration of legacy data repositories, file shares, and on-premise systems to SharePoint Online and Microsoft 365
  • Define information architecture for SharePoint, including site design, content structures, and metadata frameworks
  • Ensure data migration approaches maintain data integrity, classification, and retention requirements
  • Leverage tools such as ShareGate or equivalent to support efficient, auditable migration processes

Data Governance, Security, and Compliance

  • Define and enforce enterprise data governance frameworks, including data quality, stewardship, and lifecycle management
  • Establish standards for data security, privacy, and access control aligned with organizational policies and regulatory requirements
  • Ensure compliance with applicable standards and privacy legislation
  • Support development of retention and disposition rules aligned with information and records management practices

Collaboration and Solution Enablement

  • Partner with business units, analytics teams, and developers to ensure data solutions meet operational and analytical needs
  • Provide guidance on data architecture best practices during project design and delivery
  • Collaborate with architects, engineers, and information management specialists to ensure cohesive and integrated solutions
  • Support adoption of data-driven practices and tools across the organization

Repository and Documentation Management

  • Maintain and organize data architecture artifacts, models, and documentation within the enterprise architecture repository
  • Ensure documentation is accurate, structured, and aligned with governance and audit requirements
  • Contribute to enterprise standards, templates, and knowledge-sharing practices
  • Support administration and continuous improvement of architecture repository content

Performance, Optimization, and Innovation

  • Assess and optimize data platforms for performance, scalability, and cost efficiency
  • Identify opportunities to modernize legacy data environments and eliminate technical debt
  • Evaluate emerging technologies and tools to enhance data capabilities, including AI and advanced analytics platforms
  • Promote reuse of data assets, integration patterns, and shared services

Key Deliverables

  • Enterprise data architecture strategy and target-state models
  • Data models, integration frameworks, and architecture design documents
  • SharePoint and Microsoft 365 data migration plans and execution artifacts
  • Data governance frameworks, standards, and policies
  • Architecture documentation and technical artifacts maintained within the enterprise repository
  • Performance optimization and modernization recommendations


Requirements

Qualifications

Education and Certifications

  • Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related field preferred
  • Microsoft Certified: Azure Data Engineer Associate or equivalent certification preferred
  • Certifications in cloud platforms such as AWS, Azure, or GCP considered an asset
  • Microsoft Power Platform Developer or equivalent certification considered an asset
  • Certifications related to data governance, data management, or business intelligence considered an asset

Experience

  • Proven experience in data architecture, data modelling, and database design
  • Strong expertise in cloud data platforms, particularly Microsoft Azure data services
  • Hands-on experience with relational, NoSQL, and big data technologies
  • Experience designing and implementing ETL, ELT, API-based, and streaming data integration solutions
  • Demonstrated experience migrating data from legacy or on-premise environments to SharePoint Online and Microsoft 365
  • Experience with migration tools such as ShareGate or equivalent
  • Strong background in information management and records management, including SharePoint on-premise and online
  • Experience with Microsoft Power Platform development and integration
  • Strong understanding of data governance, security, and compliance frameworks
  • Ability to design and manage SharePoint site architecture, permissions, and integration with M365 tools

Similar Jobs

Yesterday
Remote
CAN
Senior level
Senior level
Information Technology • Professional Services • Software • Consulting
Lead data architecture for a Justice Information Management System modernization: consolidate reporting marts into an EDW, perform data profiling and modeling, develop ETL (SSIS), ensure data quality and governance, validate reporting, and communicate with stakeholders.
Top Skills: Data MartsData ModelingData WarehousingEnterprise Data Warehouse (Edw)ETLPower BIRelational DatabasesSap PowerdesignerSQLSql Server Integration Services (Ssis)Sybase Powerdesigner
Yesterday
Remote
CAN
Senior level
Senior level
Information Technology • Professional Services • Software • Consulting
Design and define enterprise data architectures and logical/physical data models using Kimball dimensional modelling; develop models with PowerDesigner; work with JOIN and JIMS; ensure alignment with information management, cybersecurity, privacy, and data governance; communicate technical concepts to technical and business stakeholders; support modernization initiatives.
Top Skills: Cloud ComputingJimsJoinKimball Dimensional ModellingSap/Sybase PowerdesignerSQL
3 Days Ago
Remote
4 Locations
Senior level
Senior level
Fitness • Healthtech • Payments • Software
Lead enterprise data architecture across AWS and Databricks Lakehouse: design scalable data models, ensure governance and data quality, mentor teams, evaluate and adopt data technologies (Delta Lake, Unity Catalog), oversee large projects and deliverables, and incorporate generative AI to accelerate data modeling and delivery.
Top Skills: Apache AirflowAws EksAws EmrAws GlueAws LambdaAws RedshiftAws S3Data VaultDatabricks LakehouseDatabricks SqlDatabricks WorkflowsDelta LakeGenerative Ai ToolsKimballPower BIPythonSQLUnity Catalog

What you need to know about the Vancouver Tech Scene

Raincouver, Vancity, The Big Smoke — Vancouver is known by many names, and in recent years, it has gained a reputation as a growing hub for both tech and sustainability. Renowned for its natural beauty, the city has become a magnet for professionals eager to create environmental solutions, and with an emphasis on clean technology, renewable energy and environmental innovation, it's attracted companies across various industries, all working toward a shared goal: advancing clean technology.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account