Data Architect

Job summary

Lead enterprise architecture for regulatory, environmental, and geospatial data, including data models, Databricks lakehouse structures, integrations, and governance controls. Assess architecture security risks, guide delivery teams through implementation, and maintain architecture documentation while providing planning, estimating, and stakeholder presentations.

Job details

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.

What you’ll do

Lead enterprise architecture for regulatory, environmental, and geospatial data, including data models, Databricks lakehouse structures, integrations, and governance controls. Assess architecture security risks, guide delivery teams through implementation, and maintain architecture documentation while providing planning, estimating, and stakeholder presentations.

Requirements

Requires a relevant college diploma or bachelor's degree, 12+ years of IT or data experience, and 8+ years in enterprise data architecture and solution design, implementation, support, and documentation. Candidates need hands-on Databricks, Delta Lake, Spark, PySpark, SQL, Unity Catalog, Azure data services, geospatial data, integration, governance, and security experience, plus leadership and threat-assessment capabilities.

Listed skills

• SQL · Preferred
• REST APIs · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Data Architecture
• Databricks
• Delta Lake
• Unity Catalog
• Spark
• PySpark
• SQL
• Data Modeling
• ETL/ELT
• REST APIs
• Streaming
• Change Data Capture
• Azure Data Services
• Geospatial Data
• Data Governance
• Threat and Risk Assessment

Job areas

• Data & Analytics
• Technology
• Government & Public Sector
• Management & Leadership

More jobs from Top Recruitment