Data Architect - Senior

Procom; Edmonton; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading technology consultancy is seeking a Senior Data Architect for a contract role in Edmonton, Canada. This hybrid role involves modernizing data systems to a cloud-native Azure Data Management Platform. Key responsibilities include designing scalable data architectures and leading the development of data ingestion pipelines using Azure services. Candidates should have substantial experience in data architecture and cloud solutions, particularly with Azure and Databricks.

Qualifications

• 3+ years managing Databricks workspaces.
• 8+ years as a Data Architect in a large enterprise.
• 4+ years designing data solutions for analytics.
• 4+ years experience with Git for version control.
• 5+ years with Azure services for secure solutions.
• 6+ years in Python and SQL for ETL workflows.
• 3+ years building data pipelines with Databricks.

Responsibilities

• Design and implement scalable data architecture on Microsoft Azure.
• Lead data ingestion and transformation pipelines using Azure data services.
• Architect and manage data lakes with Azure Data Lake Storage.
• Integrate diverse source systems using APIs and connectors.
• Develop data models for analytics and reporting.
• Monitor data pipelines ensuring reliability and performance.

Skills

Databricks management

Data architecture design

Data solution design for analytics

Git version control

Azure services

Python programming

ETL/ELT workflows

Building data pipelines

Education

College or Bachelor degree in Computer Science

Tools

Databricks

Power BI

Azure Data Factory

Azure Synapse Analytics

SQL

GitHub

Job description

Overview

Data Architect - Senior :

On behalf of our Government client, Procom is searching for a Data Architect - Senior for a contract role. This position is a hybrid position with occasional days onsite at our client’s Edmonton office.

Data Architect - Senior - Job Description :

The project involves modernization initiatives shifting legacy systems to a cloud-native Azure Data Management Platform, alongside on-premises geospatial systems. This transformation requires a Data Architect to design, implement and manage scalable, secure, and integrated data solutions.

Ministries such as Environment and Protected Areas, Transportation and Economic Corridors, and Service Alberta rely on complex data from systems like ServiceNow, ERP platforms, and geospatial tools. The Data Architect will enable seamless ingestion, transformation, and integration of this data using Azure services including Data Factory, Synapse Analytics, Data Lake Storage, and Purview.

Responsibilities

• Design and implement scalable, secure, and high-performance data architecture on Microsoft Azure, supporting both cloud-native and hybrid environments.
• Lead the development of data ingestion, transformation, and integration pipelines using Azure Data Factory, Azure Databricks, and Azure Synapse Analytics.
• Architect and manage data lakes and structured storage solutions using Azure Data Lake Storage Gen2, ensuring efficient access and governance.
• Integrate data from diverse source systems including ServiceNow, and geospatial systems, using APIs, connectors, and custom scripts.
• Develop and maintain robust data models and semantic layers to support operational reporting, analytics, and machine learning use cases.
• Build and optimize data workflows using Python and SQL for data cleansing, enrichment, and advanced analytics within Azure Databricks.
• Design and expose secure data services and APIs using Azure API Management for downstream systems.
• Implement data governance practices, including metadata management, data classification, and lineage tracking.
• Ensure compliance with privacy and regulatory standards (e.g., FOIP, GDPR) through role-based access controls, encryption, and data masking.
• Collaborate with cross-functional teams to align data architecture with business requirements, program timelines, and modernization goals.
• Monitor and troubleshoot data pipelines and integrations, ensuring reliability, scalability, and performance across the platform.
• Provide technical leadership and mentorship to data engineers and analysts, promoting best practices in cloud data architecture and development.

Mandatory Skills

• College or Bachelor degree in Computer Science or a related field of study.
• 3 years Experience managing Databricks workspaces, including cluster configuration, user roles, permissions, cluster policies, and applying monitoring and cost optimization for efficient, governed Spark workloads
• 8 years Experience as a Data Architect in a large enterprise, designing and implementing data architecture strategies and models that align data, technology, and business goals with strategic objectives
• 4 years Experience designing data solutions for analytics-ready, trusted datasets using tools like Power BI and Synapse, including semantic layers, data marts, and data products for self-service, data science, and reporting
• 4 years Experience in Github / Git for version control, collaborative development, code management, and integration with data engineering workflows.
• 5 years Experience with Azure services (Storage, SQL, Synapse, networking) for scalable, secure solutions, and with authentication (Service Principals, Managed Identities) for secure access in pipelines and integrations
• 6 years Experience in Python (including PySpark) and SQL, applied to developing, orchestrating, and optimizing enterprise-grade ETL / ELT workflows in a large-scale cloud environment.
• 3 years Experience building scalable data pipelines with Azure Databricks, Delta Lake, Workflows, Jobs, and Notebooks, plus cluster management. Extending solutions to Synapse Analytics and Microsoft Fabric is a plus.

Assignment Details

• Data Architect - Senior – Assignment Length: 4 months
• Data Architect - Senior - Start Date: ASAP
• Data Architect - Senior - Assignment Location: Edmonton, Alberta, Canada. This is a hybrid role, requiring occasional days onsite at the client's office.