Senior Data Architect

Job summary

Define enterprise data architecture, integration strategies, and data models for regulatory, environmental, and geospatial data across Databricks, DRAS, and the Alberta Geospatial Platform. Establish secure and reusable data practices, governance standards, and technical guidance while collaborating with cross-functional teams in an Agile environment.

Job details

Role: Data Architect – Senior Location: Edmonton, Alberta (Remote) Job Type: Contract Role Overview The role focuses on connecting regulatory and environmental data across DRAS, a Databricks-based Data Management Platform, and the Alberta Geospatial Platform. The successful candidate will define enterprise data architecture, integration patterns, data models, and governance practices to enable reliable, secure, and reusable data. Key Responsibilities Define target-state data architecture and integration strategies across enterprise platforms. Design conceptual, logical, and physical data models for regulatory, environmental, and geospatial data. Architect Databricks lakehouse solutions using Delta Lake, medallion architecture, Spark, and Unity Catalog. Design data pipelines and integration patterns using ETL/ELT, REST APIs, event streaming, and change data capture. Lead integration between cloud data platforms, enterprise systems, and geospatial platforms. Establish data contracts, API specifications, metadata, lineage, and data quality standards. Ensure compliance with security, privacy, information classification, and records management requirements. Collaborate with data engineers, GIS specialists, developers, business analysts, and product owners in an Agile environment. Provide architecture guidance, technical documentation, risk recommendations, and mentorship. Required Skills & Qualifications Strong experience in enterprise data architecture, database design, documentation, and data integration. Hands-on experience with Databricks, Delta Lake, Spark/PySpark, SQL, and Unity Catalog. Expertise in relational, dimensional, and lakehouse data modelling. Experience with enterprise integration patterns, including REST APIs, ETL/ELT, event streaming, and CDC. Experience with cloud data services, preferably Azure Data Lake Storage, Azure Data Factory, Event Hubs, and Key Vault. Experience with ServiceNow integration. Knowledge of geospatial data, GIS platforms, spatial formats, geometry, and coordinate reference systems. Strong understanding of data governance, metadata management, data quality, security, and privacy. Experience with enterprise architecture principles, risk assessments, and Agile delivery. Excellent communication, documentation, stakeholder management, and technical leadership skills.

What you’ll do

Define enterprise data architecture, integration strategies, and data models for regulatory, environmental, and geospatial data across Databricks, DRAS, and the Alberta Geospatial Platform. Establish secure and reusable data practices, governance standards, and technical guidance while collaborating with cross-functional teams in an Agile environment.

Requirements

Requires extensive enterprise data architecture and integration experience, including hands-on expertise with Databricks, Delta Lake, Spark/PySpark, SQL, Unity Catalog, and data modeling. Candidates should also bring cloud data services and ServiceNow integration experience, geospatial knowledge, and strong capabilities in governance, security, communication, and technical leadership.

Listed skills

• SQL · Preferred
• REST APIs · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Enterprise Data Architecture
• Data Modeling
• Databricks
• Delta Lake
• Apache Spark
• PySpark
• SQL
• Unity Catalog
• ETL/ELT
• REST APIs
• Event Streaming
• Change Data Capture
• Azure Data Services
• ServiceNow Integration
• Geospatial Data
• Data Governance

Job areas

• Data & Analytics
• Technology
• Software
• Environmental & Sustainability
• Government & Public Sector

More jobs from RAPS Consulting Inc