cover image
VySystems

Data Architect

Hybrid

Toronto, Canada

Freelance

17-01-2026

Share this job:

Skills

Unity SQL CI/CD SQL Server Snowflake Databricks

Job Specifications

Role : Data Architect

Location : Toronto Canada (3 days onsite a week)

Contract

Job Description:

Define and maintain reference architectures (Lakehouse, CDC, streaming) and domain data models (conceptual, logical, physical).
Create and enforce data standards: naming conventions, data types, modeling practices, semantic definitions (aligned to business glossaries).
Establish metadata operating model: ownership, stewardship, processes for Catalog, Glossary, Data Dictionary, and Data Lineage.
Integrate lineage capture across pipelines (ETL/ELT/streaming), BI layers, and ML workflows.
Architect cross-platform data flows across Databricks, Oracle/SQL Server, Snowflake and metadata tools.
Define IAM models: RBAC/ABAC, SSO/federation, SCIM provisioning; directory-driven entitlements and periodic access reviews.
Define catalog strategy (e.g., Unity Catalog/Purview/Collibra/Alation) and integrate with CI/CD for automated registration and lineage.
Design reusable pipeline frameworks with configuration-driven IO, logging, metrics, retry/error handling, and data quality checks.

About the Company

Vy Systems is a part of vy.ventures and is in the business of Technology consulting, Solutions, and Managed Services, providing invaluable services across many countries since 2002. We have formulated company policies and protocols based on our distinctive DNA that has evolved over two decades and strikes a good balance between IQ and EQ. Our DNA incorporates/encompasses emotional components, Key analytical talents, intellectual abilities, plain old common sense, and presence of mind to solve issues and make important busin... Know more