Data Architect/ Data Modeler
- Toronto, ON, Canada
$70 to $75 CAD / hour · Contract
Applications open in a new tab.
Job details
- Pay
- $70 to $75 CAD / hour
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
Title: Data Architect/ Data Modeler
Duration: 12+ Months + Extension
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
able designs.
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
More about this job
Responsibilities
Design conceptual, logical, and physical data models for enterprise analytical platforms and Azure Databricks/Delta Lake lakehouses, including entity keys, relationships, historical tracking, and schema evolution. Analyze API and JSON sources, validate designs with SQL and Python or PySpark, and define reusable data products, data contracts, and governance requirements in collaboration with business and engineering teams.
Requirements
The role requires experience in enterprise data modeling, REST API specification analysis, semi-structured JSON profiling, and Azure Databricks and Delta Lake modeling. Candidates should be able to explore and validate data using SQL and Python or PySpark, translate business needs into data products and contracts, and establish data governance requirements; cybersecurity domain experience, Unity Catalog, and OCSF are nice to have.
Skills
- Data Modeling
- Conceptual, Logical, And Physical Modeling
- REST API Analysis
- JSON Data Profiling
- Azure Databricks
- Delta Lake
- SQL
- Python
- PySpark
- Data Product Design
- Data Contracts
- Data Mesh
- Data Governance
- Data Quality
- Metadata And Lineage
- Data Validation
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Security & Safety
Keywords
- Data Architecture
- Data Modeling
- Enterprise Analytics
- REST APIs
- JSON
- Source-To-Target Mapping
- Azure Databricks
- Delta Lake
- Lakehouse
- Entity Keys
- Historical Tracking
- Schema Evolution
- SQL
- Python
- PySpark
- Data Products
- Data Contracts
- Data Mesh
- Data Governance
- Data Quality
- Metadata
- Data Lineage
- Sensitive Data Handling
- Cybersecurity
- Unity Catalog
- Open Cybersecurity Schema Framework (OCSF)