Senior Data Architect

FinneyTaylor Consulting Group Ltd.; Edmonton; On-site; CAD 110,000 - 165,000; Full time

Job summary

Our Edmonton-based client, FinneyTaylor Consulting Group Ltd., seeks a Data Architect to design and govern enterprise data architectures across regulatory, environmental, and geospatial domains. You will define target-state architectures, model data across lakehouse patterns, and implement robust integration patterns using Databricks and Azure services.

The role emphasizes public sector experience, geospatial data competencies, and strong governance, security, and metadata practices.

Qualifications

• University degree in Computer Science / Information Systems / Engineering / Geomatics or related field.
• 7+ years in data architecture, data engineering, or data integration, with at least 3 years in a data architect role.
• Hands-on experience designing solutions on Databricks, including Delta Lake, Spark(PySpark/SQL), and Unity Catalog.
• Strong experience with data modelling (relational, dimensional, and lakehouse approaches).
• Proven experience designing enterprise integration patterns, including REST APIs, ETL/ELT, event streaming, and change data capture.
• Experience with cloud data platforms, preferably Microsoft Azure (Data Lake Storage, Data Factory, Event Hubs, Key Vault).
• Experience with ServiceNow Integration.
• Experience in the public sector, ideally with government regulatory systems or programs.
• Experience integrating with geospatial platforms, and working knowledge of geospatial data concepts, formats, and standards.
• Working knowledge of geospatial data concepts, formats, and standards.
• Solid understanding of data governance, metadata management, data quality, and data security principles.

Responsibilities

• Define and maintain the target-state data architecture for integrating DRAS, the Databricks Data Management Platform, and the Alberta Geospatial Platform.
• Design conceptual, logical, and physical data models for regulatory, environmental, and geospatial data domains.
• Establish integration patterns (batch, near-real-time, event-driven, API-based, change data capture) suited to each use case.
• Design lakehouse structures on Databricks, including medallion (bronze/silver/gold) layers, Delta Lake tables, and Unity Catalog organization.
• Architect spatial data flows that preserve geometry, coordinate reference systems, and spatial accuracy across platforms.

Skills

Data architecture

Data engineering

Data integration

Databricks

Delta Lake

Spark

PySpark

SQL

Unity Catalog

Data modelling

Enterprise integration patterns

REST APIs

ETL/ELT

Event streaming

Change data capture

Azure

Data Lake Storage

Data Factory

Event Hubs

Key Vault

ServiceNow Integration

Geospatial data concepts

Geospatial formats

Geospatial standards

Data governance

Metadata management

Data quality

Data security

Public sector experience

Education

University degree in Computer Science/Information Systems/Engineering/Geomatics or related field

Tools

Databricks

Unity Catalog

Azure Data Lake Storage

Azure Data Factory

Azure Event Hubs

Azure Key Vault

Job description

Job Description

Our Client in Edmonton is looking for a Data Architect!

Must Have Primary Skills

• University degree in Computer Science,Information Systems, Engineering, Geomatics, or a related field.
• 7+years of progressive experience in data architecture, data engineering, or dataintegration, with at least 3 years in a data architect role.
• Hands-onexperience designing solutions on Databricks, including Delta Lake, Spark(PySpark/SQL), and Unity Catalog.
• Strongexperience with data modelling (relational, dimensional, and lakehouseapproaches)
• Provenexperience designing enterprise integration patterns, including REST APIs,ETL/ELT, event streaming, and change data capture.
• Experiencewith cloud data platforms, preferably Microsoft Azure (Data Lake Storage, DataFactory, Event Hubs, Key Vault).
• Experiencewith ServiceNow Integration.
• Experiencein the public sector, ideally with government regulatory systems or programs.
• Experienceintegrating with geospatial platforms, and working knowledge of geospatial dataconcepts, formats, and standards.
• Workingknowledge of geospatial data concepts, formats, and standards.
• Solidunderstanding of data governance, metadata management, data quality, and datasecurity principles.

Nice To Have Secondary Skills

• Experienceworking in agile delivery teams, with experience in public sector in similarcapacity
• Excellentcommunication skills, with the ability to explain technical concepts tonon-technical audiences.

Proven Experience In

• Define and maintain the target-state dataarchitecture for integrating DRAS, the Databricks Data Management Platform, andthe Alberta Geospatial Platform.
• Designconceptual, logical, and physical data models for regulatory, environmental,and geospatial data domains.
• Establishintegration patterns (batch, near-real-time, event-driven, API-based, changedata capture) suited to each use case.
• Designlakehouse structures on Databricks, including medallion (bronze/silver/gold)layers, Delta Lake tables, and Unity Catalog organization.
• Architectspatial data flows that preserve geometry, coordinate reference systems, andspatial accuracy across platforms.

Skills

Industry experience required: Government