Azure Data ArchitectAstra North Infoteck Inc. • Brampton, ON, ca

Azure Data Architect

Astra North Infoteck Inc. • Brampton, ON, ca

1 day ago

Job type

Full-time

Job description

Azure Data Architect

Brampton - Hybrid (2-3 days from Office)

Experience Range : 8+ years

1) Architecture & Solution Design

Define end to end data platform reference architectures using Azure services such as Azure Synapse / SQL, Microsoft Fabric (Lakehouse, Warehouse, Semantic Models), Databricks, Azure Data Lake Storage Gen2, Data Factory / Synapse Pipelines, Event Hubs / Kafka, and Stream Analytics.
Select appropriate storage and compute patterns (e.g., lakehouse, data mesh, medallion zones, Delta format) aligned to use cases, SLAs, and scalability needs.
Produce and maintain HLD / LLD, Architecture Decision Records (ADRs), ERDs, and interface / API specifications.

________________________________________

2) Data Modeling & Engineering Patterns

Establish dimensional (Kimball), 3NF, and Data Vault models where appropriate; promote semantic models for BI (Power BI / Fabric).

Define ingestion and processing patterns (batch, streaming, CDC, micro batch) and file format standards (Parquet, Delta Lake, Avro).

Set coding standards and performance guidelines for SQL, T SQL, PySpark, and Spark SQL.

________________________________________

3) Data Integration & Pipelines

Architect robust ETL / ELT pipelines with ADF / Synapse Pipelines, Fabric Data Factory, Databricks Workflows, and orchestration using ADF triggers and Logic Apps.

Integrate data from ERPs / CRMs, SaaS applications, APIs, and on prem systems via Self hosted Integration Runtime, Event Hubs, Kafka, Service Bus, and Change Data Capture tools.

________________________________________

4) Governance, Security & Compliance

Implement data governance (catalogs, lineage, glossary, ownership) using Microsoft Purview; establish data mesh guardrails and federated governance practices.

Enforce security using Azure AD (Entra ID), RBAC / ABAC, Managed Identities (MSI), Key Vault, Private Endpoints, VNet integration, row / column level security, dynamic data masking, and encryption at rest / in transit.

Define data quality, master / reference data practices, and support audit, retention, and regulatory requirements.

________________________________________

5) Performance, Reliability & Cost Optimization

Design for scalability and resilience (partitioning, caching, Z ordering, concurrency control, workload isolation).

Tune Spark and SQL workloads; optimize storage layouts; configure auto optimize / auto compaction strategies (e.g., Delta).

Own FinOps for data platforms : capacity planning, cost governance, tagging, budgets / alerts, and rightsizing.

________________________________________

6) DevOps, CI / CD & Observability

Establish CI / CD for data and infrastructure using Azure DevOps or GitHub Actions, with Terraform / Bicep and deployment strategies (blue green, canary).

Implement monitoring and alerting with Azure Monitor, Log Analytics, Fabric / Databricks observability, and custom dashboards; define SLOs / SLIs for data pipelines.

Define backup & disaster recovery strategies and RPO / RTO targets for critical datasets.

________________________________________

7) Leadership & Collaboration

Lead data architecture governance and design reviews; mentor data engineers and analysts.

Partner with Product, Security, Enterprise Architecture, and Business stakeholders to align roadmaps and priorities.

Drive vendor / tool evaluations, proofs of concept, and build vs buy decisions.

________________________________________

Skills & Experience

Required

7+ years in data architecture / engineering, including 3–5 years with Azure data services.

Hands on expertise with several of the following :

o Azure Synapse Analytics / Azure SQL

o Microsoft Fabric (Lakehouse, Warehouse, Semantic Models / DAX)

o Databricks (Spark, Delta Lake, Unity Catalog), PySpark / Spark SQL

o ADLS Gen2, Data Factory / Synapse Pipelines / Fabric Data Factory

o Event Hubs, Service Bus, Kafka, Stream Analytics, CDC tools

Strong data modeling (dimensional, 3NF, Data Vault) and ELT / ETL design.

Proficient in SQL, T SQL, PySpark; solid understanding of metadata management and lineage.

Security & networking basics : AAD, RBAC, VNets, Private Endpoints, Key Vault, Managed Identities.

IaC & DevOps : Terraform / Bicep, Git, Azure DevOps / GitHub, automated testing for data pipelines.

Preferred

Experience with data mesh and lakehouse patterns; MLOps handoffs (Feature Store, Model Registry).

Performance engineering at large scale (TB–PB).

Knowledge of data quality frameworks (e.g., Great Expectations, Deequ) and DQ scorecards.

Exposure to Microsoft Purview (catalog, classifications, policies).

Familiarity with privacy / compliance (SOX, HIPAA, GDPR, PCI).

Create a job alert for this search

Azure Data Architect • Brampton, ON, ca

Similar jobs

Senior Azure & M365 Infrastructure Architect

Altis Technology • Mississauga

Full-time

A leading tech firm in Canada is seeking a Senior Network / System Analyst to design and manage network and security infrastructure in Azure and Microsoft 365 environments. This role requires 6+ years...Show more

Last updated: 22 days ago • Promoted

Senior Enterprise Architect

Maarut Inc • mississauga, ON, ca

Full-time

Experience and Skill Set Requirements : Must Haves : Expert knowledge and 10+ years experience in Identity and Access Manag...Show more

Last updated: 2 days ago • Promoted

Senior Spark & Big Data Architect (Scala, Real-Time)

Citibank (Switzerland) AG • Mississauga

Full-time

A prominent financial institution in Canada seeks an experienced technical leader to oversee big data initiatives.The ideal candidate owns a Bachelor's or Master's in a related field and brings ove...Show more

Last updated: 20 days ago • Promoted

Sr Data Architect (Azure / AWS)

Ccube • Mississauga

Full-time

Hello Data Architect Professional!.We are looking for a SrData Architect (Azure / AWS) Toronto, ON for a Hybrid Role.Job Title : Data Architect (Azure / AWS). Location : Toronto, ON / Mississauga, ON.Prim...Show more

Last updated: 1 day ago • Promoted

Astronomer / Airflow Architect

360 Technology • Mississauga

Full-time

EVP- Business Development and Strategy at 360 Technology LLC.Help guide a small group of technologists in their Apache Airflow journeys, including identifying new use cases and onboarding new domai...Show more

Last updated: 22 days ago • Promoted

Senior Data Platform Developer, Generative AI Data & Analytics Oakville, Ontario

Geotab Inc. • Oakville

Full-time +1

Senior Data Platform Developer, Generative AI.Geotab is a global leader in IoT and connected transportation and certified “Great Place to Work. We are a company of diverse and talented individuals ...Show more

Last updated: 22 days ago • Promoted

Senior Cognos BI Lead – Architecture, Dashboards & Data

Cynet systems Inc • Mississauga

Full-time

A leading BI solutions provider based in Mississauga seeks an experienced BI Developer to lead Cognos development efforts. The role requires over 5 years of experience in Cognos Analytics and busine...Show more

Last updated: 4 days ago • Promoted

Data Engineer - Iris Software Inc.

Iris Software Inc. • mississauga, on, ca

Full-time

Iris Software is looking to hire a.Job Title : Data Engineer / Architect.Location : Toronto, ON (3-4 days onsite).Proficient with Advanced SQL, Python, and other data querying language.Experience in ...Show more

Last updated: 12 days ago • Promoted

Senior Solutions Architect : Big Data & AI Delivery Lead

Sigmoid • Mississauga

Full-time

A leading data solutions firm is seeking a Solutions Architect to lead technical engagements for fortune 1000 clients.This role requires excellent leadership and technical skills to build scalable ...Show more

Last updated: 22 days ago • Promoted

Oracle Cloud Solution Architect & Technical Lead (Onshore)

Jade Global • Mississauga

Full-time

A leading IT consulting firm is seeking an Oracle Solution Architect / Technical Lead in Mississauga, Canada.This full-time role involves leading Oracle Cloud implementations and integrations, requ...Show more

Last updated: 22 days ago • Promoted

Senior Data Architect

ODAIA • Mississauga

Full-time

The RBC Insurance Team is currently undertaking a multiyear journey of modernization and transformation of the core Insurance applications. As part of this transformation there will be multiple init...Show more

Last updated: 4 days ago • Promoted

Data Architect (Contract – 12 Months) - Facility Association

Facility Association • mississauga, on, ca

Full-time

Are you looking to work with an organization that has an impact on the insurance industry? Do you want your voice to have an impact?. At Facility Association, we pride ourselves on being a standout ...Show more

Last updated: 24 days ago • Promoted

Senior Data Engineer (Hadoop + GCP Dataproc) - TechDoQuest

TechDoQuest • mississauga, on, ca

Full-time

Hadoop ecosystem, with deep expertise in Hive, Hive Metastore, and GCP Dataproc.Strong hands-on experience with Dataproc Serverless, BigQuery, Google Cloud Storage (GCS), Cloud Composer, and Cloud ...Show more

Last updated: 3 days ago • Promoted

Oracle ERP Cloud Technology Architect - 65714761

Cognizant • Vaughan

Full-time

As an Oracle Cloud ERP Technology Architect, you will play a pivotal role in designing and implementing cutting‑edge solutions using Oracle technologies. You will leverage your expertise in Oracle C...Show more

Last updated: 22 days ago • Promoted

Senior Solutions Architect – Enterprise Cloud

Canada Mortgage and Housing Corporation • Toronto, Ottawa

Full-time

A national housing organization in Toronto seeks a Solutions Architect committed to improving IT services.The role includes leading the evaluation and design of solutions for business applications ...Show more

Last updated: 20 days ago • Promoted

Senior Private Cloud Enterprise Architect - Lead & Innovate

Rogers Communications • Brampton

Full-time

A leading telecommunications company in Brampton is seeking a Sr.Enterprise Technical Architect to lead infrastructure solution designs. Responsibilities include executing platform discoveries and c...Show more

Last updated: 4 days ago • Promoted

Senior Power BI & Data Analytics Architect

CONFLUX SYSTEMS • Mississauga

Full-time

A leading data analytics company in Peel Region, Mississauga is seeking an experienced Power BI Developer.The ideal candidate will have strong expertise in SQL and data warehousing, with a focus on...Show more

Last updated: 5 days ago • Promoted

Databricks Engineer - Azure Data Pipelines & Lakehouse

Compunnel, Inc. • Mississauga

Full-time

A leading technology company in Canada seeks a Databricks Engineer.The role involves designing and optimizing large-scale data pipelines using Databricks and Azure, requiring over 10 years of exper...Show more

Last updated: 22 days ago • Promoted