Job Description

Overview

We are seeking a highly skilled

Data Architect / Modeler

to design, implement, and optimize enterprise-level data architecture and modeling solutions in a complex, distributed environment. The successful candidate will work closely with business and technical stakeholders to define data strategies, deliver integrated designs, and ensure alignment with enterprise architecture and business objectives.

Responsibilities

Develop and implement data architecture for application development, including data flow, distribution, database location, and access methods. Provide a standard business vocabulary, define strategic data requirements, and outline integrated designs that align with enterprise strategies. Define conceptual, logical, and physical models mapping from data sources to curated models and data marts. Design dimensional data mart models, document source-to-target mapping, and design/implement transformations from curated models to data marts. Conduct knowledge transfer and training sessions using the review-watch-do methodology; prepare and present learning materials for resource enablement. Develop documentation, knowledge transfer materials, and training content for long-term sustainability. Monitor project milestones, provide status updates, and ensure knowledge transfer objectives are met.
Required Skills & Experience

Technical Experience

Proficiency in

SQL and Python

, with hands-on experience in

Databricks

and

Spark SQL

for data modeling and transformation. Experience with at least

two different platforms, operating systems, environments, database technologies, languages, and communication protocols

. Strong understanding of

database design performance considerations

in various environments. Knowledge and experience in

information resource management tools and techniques

.
Data Architecture & Modeling

Proven experience in the

design, development, and implementation of data models

for analytics and BI. Expertise in BI modeling methodologies (

Inmon, Kimball, Data Vault

), data mapping, data warehouse, data lake, and data lakehouse design. Strong understanding of

data quality principles

, with ability to implement automated data quality checks using SQL and Python. Experience with structured methodologies for design, development, and implementation of applications. Hands-on experience with

data modeling tools

(ERWIN, VISIO, PowerDesigner), metadata structures, repositories, and data dictionaries. Skilled in monitoring and enforcing

data modeling/normalization standards

. Experience developing

enterprise architecture deliverables

(e.g., models).
Agile Product Development

Experience working in

Agile, sprint-based development environments

. Understanding of iterative product development cycles (

Discovery, Agile, Beta, Live

). Experience collaborating with developers in shared codebases using

Git

(Azure DevOps, GitHub, Bitbucket). Ability to contribute to version-controlled environments and participate in

code reviews

.
Desirable Skills

Experience with

middleware and gateways

. Experience designing/developing

automated data distribution mechanisms

. Knowledge of

object-oriented analysis and design techniques

. Familiarity with

Ontario Government Enterprise Architecture processes and practices

. Experience creating

detailed data standards

for system integration. Strong knowledge of

dimensional and relational data models

.
Must-Haves

Proficiency in SQL and Python with

Databricks

and

Spark SQL

. Experience across at least two

platforms, OS, databases, languages, and communication protocols

. Experience designing and implementing

data models for analytics and BI

. Expertise in

BI modeling methodologies

(Inmon, Kimball, Data Vault), data mapping, data warehouses, data lakes, and data lakehouses. Strong understanding of

data quality principles

and automation using SQL and Python. Experience with

middleware and gateways

. Experience designing/developing

automated data distribution mechanisms

.
Job Types: Full-time, Fixed term contract
Contract length: 12 months

Pay: From $75.00 per hour

Expected hours: 36.25 per week

Application question(s):

How many years of experience do you have using SQL and Python with Databricks and Spark SQL for data modeling and transformation tasks? How many years of experience do you have working with at least two different platforms, operating systems, environments, database technologies, programming languages, or communications protocols? How many years of experience do you have in the design, development, and implementation of data models for analytics and business intelligence? How many years of experience do you have applying BI modeling methodologies (Inmon, Kimball, Data Vault) as well as working with data mapping, data warehouses, data lakes, and data lakehouses in an enterprise setting?
Location:

Toronto, ON (preferred)
Work Location: Hybrid remote in Toronto, ON