Data Architect/ Data Modeler

Collabera; Toronto; Hybrid; CAD 96,000 - 103,000; Full time

Job summary

Collabera in Toronto, hybrid role, is seeking a data engineering professional to design and implement data models and data pipelines. The role focuses on data modeling, API source analysis, Azure Lakehouse modeling with Databricks and Delta Lake, and data governance to ensure high-quality analytics products.

You will collaborate with domain experts and engineering teams to translate business needs into reusable data products and contracts, with potential cybersecurity domain exposure.

Qualifications

• Experience designing enterprise analytical data models.
• Ability to profile data sources via REST API specs and JSON.
• Design Azure Lakehouse models with sound keys, relationships and history.

Skills

Data modeling

API source analysis

Azure Lakehouse modeling

Data exploration & validation

Data products

Data governance

Collaboration

Tools

Azure Databricks

Delta Lake

SQL

Python/PySpark

Job description

s
Interview Process: 1 - Virtual and 1- In pers

on
Location: Toronto, ON- Hybrid- 5X/Month in Off

ice
Compensation: $70-$75/

hour
Must

• Have:
  Data modeling: Developing conceptual, logical, and physical models for enterprise analytical pla
• tforms.
  API source analysis: Interpreting REST API specifications and profiling semi-structured JSON data to establish source semantics, extraction limitations, and source-to-target m
• appings.
  Azure Lakehouse modeling: Designing Azure Databricks and Delta Lake models with sound entity keys, relationships, historical tracking, and schema e
• volution.
  Data exploration and validation: Using SQL and Python or PySpark to explore data and validate design as
• sumptions.
  Data products: Translating business needs into reusable data products and practical data contracts aligned with data mesh
• principles.
  Data governance: Defining data quality, metadata, lineage, and sensitive-data handling r
• equirements.
  Collaboration: Working with domain experts and engineering teams to deliver implement
• 
  Nice to have:
  Cybersecurity data domain experience and familiarity with Unity Catalog and the Open Cybersecurity Schema

Framework (OCSF).
We may use AI-enabled and/or automated tools to support parts of our recruitment process, including application screening, interview scheduling, and candidate communications. These tools are used to enhance consistency and efficiency. All hiring decisions involve human review and are not based solely on au

tomated processing.
The Company offers a total rewards package in accordance with all applicable federal, provincial, and local laws and requirements. Benefit eligibility and offerings vary based on role, employment status, and work location. For contractor positions, benefits are limited to those entitlements and protections required by applicable law, which may include (as applicable) vacation pay, public holidays, leaves of absence, and other legally mandated b

benefits or payments.