Data Architect/ Data Modeler
- Toronto, ON, Canada
$65 to $70 CAD / hour · Contract
Applications open in a new tab.
Job details
- Pay
- $65 to $70 CAD / hour
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
Title: Data Architect/ Data Modeler
Duration: 12+ Months + Extensions
Interview Process: 1 - Virtual and 1- In person
Location: Toronto, ON- Hybrid
Compensation: $65-$70/hour
Must Have:
- Data modeling: Developing conceptual, logical, and physical models for enterprise analytical platforms.
- API source analysis: Interpreting REST API specifications and profiling semi-structured JSON data to establish source semantics, extraction limitations, and source-to-target mappings.
- Azure Lakehouse modeling: Designing Azure Databricks and Delta Lake models with sound entity keys, relationships, historical tracking, and schema evolution.
- Data exploration and validation: Using SQL and Python or PySpark to explore data and validate design assumptions.
- 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 requirements.
- Collaboration: Working with domain experts and engineering teams to deliver implementable 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 automated 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 benefits or payments.
More about this job
Responsibilities
Develop conceptual, logical, and physical data models for enterprise analytical platforms, including Azure Databricks and Delta Lake lakehouses. Analyze API sources and data, translate business needs into reusable data products and contracts, and define governance requirements in collaboration with domain experts and engineering teams.
Requirements
The role requires experience with enterprise data modeling, REST API specifications, semi-structured JSON, Azure Databricks, and Delta Lake. Candidates must be able to explore and validate data using SQL and Python or PySpark, and apply data mesh and governance principles; cybersecurity experience, Unity Catalog, and OCSF are nice to have.
Skills
- Data 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 Management
- Data Lineage
- Stakeholder Collaboration
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Security & Safety
Keywords
- Data Architecture
- Data Modeling
- Conceptual Data Models
- Logical Data Models
- Physical Data Models
- REST APIs
- JSON
- Source-To-Target Mapping
- Azure Databricks
- Delta Lake
- Lakehouse
- SQL
- Python
- PySpark
- Data Products
- Data Contracts
- Data Mesh
- Data Governance
- Data Quality
- Metadata
- Data Lineage
- Cybersecurity
- Unity Catalog
- Open Cybersecurity Schema Framework (OCSF)