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: Edmonton, AB, Canada, T5K 2G6
Work Model: Onsite
Shift: Monday to Friday (08:15AM to 16:30PM)
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
Preferred Certifications/Licenses: Certification in The Open Group Architecture Framework (TOGAF)
**C2C is not available**
Job Description
Required Education:
- Bachelor degree in Computer Science or a related field of study.
Preferred Certification
- Certification in The Open Group Architecture Framework (TOGAF).
Required Experience And Skills
- Experience designing, planning, implementing and supporting enterprise solution databases in an environment equivalent in size and complexity to the Client (8 years)
- Experience documenting enterprise solution databases in an environment equivalent in size and complexity to the Client (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
- 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 Client (8 years)
- 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
Preferred Experience And 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 Client (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 Client (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 Client is considered a strong asset (5 years)
Competencies
- Systems Thinking: Understands how DRAS, the data platform, and the geospatial platform connect, and anticipates downstream impacts of design choices.
- Creative Problem Solving: Finds practical, innovative solutions to complex integration and data challenges.
- Agility: Adapts quickly to changing priorities and evolving technology in a fast-paced environment.
- Drive for Results: Delivers high-quality architecture that produces measurable value for the program.
- Build Collaborative Environments: Works effectively across teams, ministries, and disciplines to reach shared goals.
- Develop Networks: Builds relationships with stakeholders and technical partners to advance the work.
- Develop Self and Others: Shares knowledge, mentors colleagues, and keeps learning.
Overview Data Architect, Digital Regulatory Assurance System (DRAS)
- 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 Client 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 Client Platform. You will set the direction for how regulatory, environmental, and spatial data moves, connects, and is governed across these systems.
- 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 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 Client 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.
- **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.).
