Senior Data Architect

Job summary

Define the target-state architecture and data models for integrating DRAS, Databricks, and the Alberta Geospatial Platform, including secure, governed data flows and lakehouse structures. Lead integration design and delivery, resolve complex data issues, document architecture decisions, and advise and mentor multidisciplinary teams.

Job details

Role- Senior Data Architect Location –9915 - 108 ST NW, Edmonton, Alberta, CAN, T5K 2G6 Duration-Long term Contract Start Date:11/02/26 End Date:03/31/27 Job Description- We are looking for an experienced Data Architect to design and lead data integration between DRAS, our Databricks-based Data Management Platform, and the Alberta Geospatial Platform. You will set the direction for how regulatory, environmental, and spatial data moves, connects, and is governed across these systems. The goal is to be trusted, timely, and reusable data for regulators, decisionmakers, and Albertans. You will join a high-performing, multidisciplinary team in a fast-paced, agile environment. The team includes developers, data engineers, GIS specialists, business analysts, and product owners. Key Responsibilities Architecture and Design • Define and maintain the target-state data architecture for integrating DRAS, the Databricks Data Management Platform, and the client Geospatial Platform. • Design conceptual, logical, and physical data models for regulatory, environmental, and geospatial data domains. • Establish integration patterns (batch, near-real-time, event-driven, API-based, change data capture) suited to each use case. • Design lakehouse structures on Databricks, including medallion (bronze/silver/gold) layers, Delta Lake tables, and Unity Catalog organization. • Architect spatial data flows that preserve geometry, coordinate reference systems, and spatial accuracy across platforms. Integration and Delivery • Lead the design of data pipelines and interfaces between systems, working closely with data engineers and developers during build. • Define data contracts, API specifications, and interface agreements between system owners. • Resolve complex integration issues involving data quality, schema changes, latency, and system dependencies. • Take part in agile ceremonies (sprint planning, backlog refinement, reviews) and turn architecture into actionable user stories. Data Governance, Security, and Quality • Embed data governance practices, including metadata management, lineage, data classification, and master and reference data. • Ensure designs meet client standards for information security, privacy (including access-to-information and privacy legislation), and records management. • Define data quality rules, validation frameworks, and monitoring approaches across integrated systems. • Apply role-based access controls and data-sharing policies appropriate to data sensitivity. Leadership and Collaboration • Serve as the trusted data architecture advisor to program leadership, product owners, and technical teams. • Work with business areas to understand regulatory processes and turn them into data requirements. • Coordinate with enterprise architecture, cybersecurity, and other ministries' platform teams to keep the work aligned with Client standards and roadmaps. • Produce clear architecture documentation, diagrams, and decision records. • Mentor team members and promote data architecture best practices. Required Qualifications • University degree in Computer Science, Information Systems, Engineering, Geomatics, or a related field. • 7+ years of progressive experience in data architecture, data engineering, or data integration, with at least 3 years in a data architect role. • Hands-on experience designing solutions on Databricks, including Delta Lake, Spark (PySpark/SQL), and Unity Catalog. • Strong experience with data modelling (relational, dimensional, and lakehouse approaches). • Proven experience designing enterprise integration patterns, including REST APIs, ETL/ELT, event streaming, and change data capture. • Experience with cloud data platforms, preferably Microsoft Azure (Data Lake Storage, Data Factory, Event Hubs, Key Vault). • Experience with ServiceNow Integration. • Experience in the public sector, ideally with government regulatory systems or programs. • Experience integrating with geospatial platforms, and working knowledge of geospatial data concepts, formats, and standards. • Working knowledge of geospatial data concepts, formats, and standards. • Solid understanding of data governance, metadata management, data quality, and data security principles. • Experience working in agile delivery teams, with experience in public sector in similar capacity • Excellent communication skills, with the ability to explain technical concepts to non-technical audiences. # Requirement Experience/Required Experience 1 Experience designing, planning, implementing, and supporting enterprise solutions -8 years 2 Experience documenting enterprise solution databases in an equivalent environment --8 years 3 Experience performing threat and risk assessments and presenting recommendations 6 years 4 Experience providing leadership, planning, estimating, and presentations Yes 5 Experience with enterprise architecture principles and associated best practices 8 years 6 Experience working as a Data Architect in an enterprise IT environment 8 years Nice to Have Professional Licenses/Certification 7 Certification in The Open Group Architecture Framework (TOGAF) Yes 8 Experience designing and implementing enterprise architecture database plans and models 5 years 9 Experience using architecture modeling tools such as PowerDesigner, ER Studio, etc. 4 years 10 Experience project managing application development projects using Agile sprints 4 years 11 Experience with cloud computing or big data platforms and infrastructure 5 years 12 Experience with enterprise business intelligence and performance management products 4 years 13 Experience working as a Data Architect designing and implementing enterprise databases 4 years 14 Experience developing SQL databases 5 years 15 Experience implementing a SQL data warehouse 5 years 16 Experience querying data using Transact-SQL (T-SQL) 5 years

What you’ll do

Define the target-state architecture and data models for integrating DRAS, Databricks, and the Alberta Geospatial Platform, including secure, governed data flows and lakehouse structures. Lead integration design and delivery, resolve complex data issues, document architecture decisions, and advise and mentor multidisciplinary teams.

Requirements

Requires a relevant university degree and substantial enterprise data architecture or integration experience, including hands-on Databricks, Delta Lake, Spark, Unity Catalog, data modeling, and integration patterns. Candidates should also bring cloud platform and geospatial integration knowledge, governance and security expertise, public-sector or agile delivery experience, and strong communication and leadership skills.

Listed skills

• SQL · Preferred
• REST APIs · Preferred
• Microsoft Azure · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

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

Job areas

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

More jobs from Enterprise Solutions Inc.