Position Name – Data Architect
Type of hiring – Fulltime/Subcon
Location – Downtown Toronto, ON
Work Model – Hybrid (3 days office, 2 days remote)
Job Description:
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
