Senior Data Architect

Job summary

Lead the architecture and modernization of enterprise data platforms, specifically migrating from Google BigQuery to Azure Databricks. Define the target-state Lakehouse architecture and implement data governance and security standards using Unity Catalog.

Job details

Role: Data Architect Location: Downtown Toronto, Canada Hybrid: (3 days office, 2 days remote) Job Summary We are seeking an experienced Data Architect to lead the architecture and modernization of our enterprise data platforms. This role is critical as we undertake a large-scale migration from Google BigQuery/GCP to Azure Databricks. The Data Architect will be responsible for defining the target-state architecture, developing the migration strategy, implementing data governance, and executing the Lakehouse architecture for a strategic data transformation program. Responsibilities Define the Azure Databricks Lakehouse architecture and create a comprehensive migration roadmap. Design and implement Medallion Architecture (Bronze, Silver, Gold) and Delta Lake solutions. Lead the architecture for the BigQuery-to-Databricks migration, including source-to-target mapping. Establish governance, security, and data management standards utilizing Unity Catalog. Architect scalable data models, ingestion frameworks, and analytics platforms to support business needs. Collaborate with business, engineering, and program teams to deliver cloud modernization initiatives effectively. Mandatory Skills Expertise in Azure Databricks, including Delta Lake and Lakehouse Architecture. Proficient in PySpark and SQL. Strong background in Data Modeling (Dimensional/Data Vault), Data Migration, and Modernization. Experience with Azure Data Factory and ADLS Gen2. Familiarity with CI/CD processes and Azure DevOps. Proven experience in delivering large-scale cloud data migration programs. Preferred Skills Experience with BigQuery migration. Financial Services industry experience is preferred. Qualifications 15+ years of experience in Data & Analytics. 5+ years of experience in Data Architecture. Preferred certifications include: Microsoft Azure Solutions Architect Expert Databricks Certified Professional TOGAF

What you’ll do

Lead the architecture and modernization of enterprise data platforms, specifically migrating from Google BigQuery to Azure Databricks. Define the target-state Lakehouse architecture and implement data governance and security standards using Unity Catalog.

Requirements

Requires over 15 years of experience in Data & Analytics with at least 5 years in Data Architecture. Proficiency in Azure Databricks, PySpark, and SQL is mandatory, with preferred certifications in Azure, Databricks, or TOGAF.

Listed skills

• SQL · Preferred
• CI/CD · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Azure Databricks
• Delta Lake
• Lakehouse Architecture
• PySpark
• SQL
• Data Modeling
• Dimensional Modeling
• Data Vault
• Data Migration
• Azure Data Factory
• ADLS Gen2
• CI/CD
• Azure DevOps
• Unity Catalog
• Medallion Architecture
• BigQuery

Job areas

• Data & Analytics
• Technology
• Consulting
• Software
• Engineering