Senior Data Architect (Databricks, Azure & Enterprise Data Integration)

Date Posted: 10/07/2026
Hiring Organization: Rose International
Position Number: 508785
Industry: Government
Job Title: Senior Data Architect (Databricks, Azure & Enterprise Data Integration)
Job Location: Remote, Canada
Work Model: Remote
Shift: 8:15 to 4:30 Alberta time
Employment Type: Temporary
FT/PT: Full-Time
Estimated Duration (In months): 4
Min Hourly Rate($): 80.00
Max Hourly Rate($): 90.00
Must Have Skills/Attributes: Data Architecture, Databricks, Designing, ServiceNow
Experience Desired:
Experience in using a tool for architecture models such as: PowerDesigner, ER Studio, Er-win, BPwin, Rational Rose (4 yrs),
Experience project managing application development projects using Agile sprint development (4 yrs),
Experience with cloud computing or big data platforms and infrastructure (5 yrs),
Experience working with developing SQL databases (5 yrs),
Experience working with implementing a SQL data warehouse (5 yrs),
Experience working with querying data with Transact-SQL (5 yrs),
Experience working as a Data Architect in an enterprise IT environment equivalent in size and complexity to the Client (8 yrs)
Required Minimum Education: Bachelor's Degree
Required Certifications/Licenses: Certification in The Open Group Architecture Framework (TOGAF)
**C2C is not available**
Job Description
Required Education:
College or bachelor's degree in computer science or a related field of study
Required Certification:
Certification in The Open Group Architecture Framework (TOGAF)
Required Skills:
Experience designing, planning, implementing and supporting enterprise solution databases in an environment equivalent in size and complexity to the Government of Alberta (8 Years)
Experience documenting enterprise solution databases in an environment equivalent in size and complexity to the Government of Alberta (8 Years)
Experience in performing threat and risk assessments and presenting recommendations for risk mitigation to senior management (6 Years)
Experience providing leadership, planning, estimating, and presentations of ideas and solutions (5 Years)
Experience with enterprise architecture principles and associated best practices, methods, standards, tools, policies, and processes (8 Years)
Experience working as a Data Architect in an enterprise IT environment equivalent in size and complexity to the Government of Alberta (8 Years)
Experience in data architecture, data engineering, or data integration, with at least 3 years in a data architect role (7 Years)
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
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
Preferred Skills:
Experience designing and implementing enterprise architecture database plans and models that help align an organization's data, information or technology with its required business capabilities in a large enterprise IT environment equivalent in size and complexity to the Government of Alberta (5 Years)
Experience in using a tool for architecture models such as: PowerDesigner, ER Studio, Er-win, BPwin, Rational Rose (4 Years)
Experience project managing application development projects using Agile sprint development (4 Years)
Experience with cloud computing or big data platforms and infrastructure (5 Years)
Experience with enterprise business intelligence and performance management products. Specifically Cognos BI Suite, Microsoft SQL Server Services, MS Power BI (Query, View) or MicroStrategy (4 Years)
Experience working as a Data Architect designing and implementing enterprise database solutions within an organization of equivalent size and complexity to the Government of Alberta (4 Years)
Experience working with developing SQL databases (5 Years)
Experience working with implementing a SQL data warehouse (5 Years)
Experience working with querying data with Transact-SQL (5 Years)
Prior experience with the Government of Alberta (GoA) is considered a strong asset (5 Years)
Job Overview:
The client is modernizing how it regulates and assures environmental outcomes across the province. The Digital Regulatory Assurance System (DRAS) is central to that work. It supports applications, approvals, compliance, and monitoring activities that protect Alberta's air, land, water, and biodiversity. 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 trusted, timely, and reusable data for regulators, decision-makers, and Albertans.
Job Responsibilities:
Architecture and Design:
Define and maintain the target-state data architecture for integrating DRAS, the Databricks Data Management Platform, and the Alberta 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 Government of Alberta standards for information security, privacy (including Alberta's 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 GoA standards and roadmaps
Produce clear architecture documentation, diagrams, and decision records
Mentor team members and promote data architecture best practices

• **Only those lawfully authorized to work in the designated country associated with the position will be considered.**

• **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client's business needs and requirements.**

Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.
California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).