Data Architect/ Data Modeler

Job summary

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.

Job details

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 enefits or payments.

What you’ll do

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.

Listed skills

• SQL · Preferred
• Python · Preferred
• Data Validation · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• 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

Job areas

• Data & Analytics
• Technology
• Software
• Security & Safety

More jobs from Collabera