Data Architect Metadata & Lineage Governance

Toronto - Canada

Monthly Salary: Not Disclosed

Posted on: 7 hours ago

Vacancies: 1 Vacancy

Job Summary

Role: Data Architect - Metadata & Lineage Governance.

Location: Toronto ON (Onsite).

Duration: Long Term Contract.

Job Overview
Own the complete visibility of enterprise data flows-from source systems across LOBs to analytics consumption. This specialized architecture role ensures governance traceability and regulatory compliance through comprehensive metadata catalogs and lineage mapping.

Core Ownership
Lineage & Metadata Architecture

Data Flow Mapping: Source-to-target lineage (ETL APIs streaming)
Process Documentation: Data flow diagrams attribute-level mappings transformation rules
Metadata Repositories: Centralized catalogs (Snowflake Collibra Alation)
Governance Frameworks: Data ownership stewardship quality gates

Cross-Functional Coordination

Stakeholder Alignment: LOB owners data stewards engineering leads
Project Integration: Metadata as standard project deliverable
Tooling Standards: Lucidchart diagrams Confluence specs JIRA tracking
Technical Validation: SQL lineage queries Python metadata extraction

Day-to-Day Impact

Map 100 systems across Finance Risk AML Payments domains
Document transformation logic ensuring 100% audit traceability
Validate lineage accuracy through SQL/Python forensics
Drive governance adoption across engineering teams
Maintain living metadata catalogs current within 24 hours of changes

Required Expertise (Must-Have)

3 years data lineage/metadata management (enterprise scale)
Advanced SQL: Window functions recursive CTEs cross-DB lineage queries
Python: Metadata extraction pandas profiling automation scripts
Excel: Pivot tables VBA macros complex formula auditing
Data Governance: Principles lifecycle stewardship frameworks
Cloud: AWS S3/Glue Azure ADLS/Synapse Snowflake lineage

Technical Stack Proficiency

Databases: MSSQL DB2 Teradata Oracle Sybase
Cloud: Azure Data Factory AWS Glue Snowflake
Tools: Lucidchart Confluence JIRA GitHub Airflow Kafka
Languages: Advanced SQL Python Excel VBA
Domains: AML/Fraud/Payments (preferred)

Nice-to-Have Impact

Big Data lineage (Spark/Hadoop job flows Kafka topics)
MLOps pipeline transparency (feature stores model lineage)
Agile delivery of governance frameworks

Role: Data Architect - Metadata & Lineage Governance. Location: Toronto ON (Onsite). Duration: Long Term Contract. Job Overview Own the complete visibility of enterprise data flows-from source systems across LOBs to analytics consumption. This specialized architecture role ensures governance trac...

Role: Data Architect - Metadata & Lineage Governance.

Location: Toronto ON (Onsite).

Duration: Long Term Contract.

Core Ownership
Lineage & Metadata Architecture

Data Flow Mapping: Source-to-target lineage (ETL APIs streaming)
Process Documentation: Data flow diagrams attribute-level mappings transformation rules
Metadata Repositories: Centralized catalogs (Snowflake Collibra Alation)
Governance Frameworks: Data ownership stewardship quality gates

Cross-Functional Coordination