Data Architect

Role overview
• Title: Data Architect
• Location: Canada (remote)
• Position type: Fully remote
• Role type: Contract
• Duration: 12 months, with possible extension
• Interview type: Remote
• Rate: CAD $90/hour
• Years of experience: 12+, including 8+ as a Data Architect
About the role
• We're seeking an experienced Data Architect to join a public sector client on a Databricks-based data management platform with integrated geospatial services. You'll lead the regulatory, environmental and geospatial data architecture and integration across the platform, designing the data models, integrations and governance controls that delivery teams build on.
• This is a senior, hands-on role for someone who is comfortable owning architecture end to end, assessing security risks in data designs, and guiding delivery teams through implementation.
Key responsibilities
• Lead the enterprise data architecture for regulatory, environmental and geospatial data across the platform.
• Design conceptual, logical and physical data models using relational, dimensional and lakehouse approaches.
• Design Delta Lake structures and Unity Catalog organization on Databricks.
• Design batch, streaming, REST API and change data capture (CDC) integrations, including ETL/ELT pipelines in Spark, PySpark and SQL.
• Architect ingestion and orchestration on Azure using ADLS, Data Factory and Event Hubs, and design integration with ServiceNow.
• Define data governance, security, quality and lineage controls, including secrets management with Azure Key Vault.
• Perform threat and risk assessments on the data architecture and present recommendations.
• Provide architecture leadership, planning, estimating and presentations to delivery teams and stakeholders.
• Produce and maintain architecture documentation, including data models and enterprise database documentation.
Must haves
• College diploma or Bachelor's degree in Computer Science or a related field of study.
• 12+ years of total IT or data experience.
• 8+ years working as a Data Architect in an enterprise IT environment.
• 8+ years designing, planning, implementing and supporting enterprise solutions.
• 8+ years documenting enterprise solution databases.
• 8+ years applying enterprise architecture principles and associated best practices.
• 6+ years performing threat and risk assessments and presenting recommendations.
• Experience providing leadership, planning, estimating and presentations.
• Hands-on experience with Databricks, Delta Lake, Spark, PySpark, SQL and Unity Catalog.
• Experience with relational, dimensional and lakehouse modeling, REST APIs, ETL/ELT, streaming and CDC.
• Experience with Azure data services, including ADLS, Data Factory, Event Hubs and Key Vault, and with ServiceNow integration.
• Experience with geospatial data and platforms, data governance and security, and public-sector delivery.
Nice to haves
• TOGAF (The Open Group Architecture Framework) certification.
• 5+ years designing and implementing enterprise architecture database plans and models.
• 4+ years using architecture modeling tools such as PowerDesigner or ER Studio.
• 4+ years project managing application development projects using Agile sprints.
• 5+ years with cloud computing or big data platforms and infrastructure.
• 4+ years with enterprise business intelligence and performance management products.
• 4+ years working as a Data Architect designing and implementing enterprise databases.
• 5+ years developing SQL databases.
• 5+ years implementing a SQL data warehouse.
• 5+ years querying data with Transact-SQL.
• 5+ years of prior experience with the client organization.

Work arrangement
Yes