Data Engineer – Senior

Data Engineer – Senior

Client: Government of Alberta – Technology and Innovation
Project: Digital Regulatory Assurance System (DRAS)
Location: Edmonton, Alberta
Work Location: 9942 – 108 ST, Edmonton, AB T5K 2J5

Contract & Schedule

• Hours: 36.25 hours/week
  
• Daily Hours: 7.25 hours/day
  
• Working Hours: 8:15 AM – 4:30 PM Alberta Time, Monday–Friday
  
• Work Mode: Primarily Remote
  
• Onsite: Edmonton meetings approximately 3–4 times per fiscal month or more, as required
  
• Work Location Restriction: Resource must work from within Canada.
  
• Extension: Up to 6 months
  

Role Overview

The Data Engineer will support the DRAS modernization initiative, designing, building, and operating reliable data pipelines and data products. The role focuses on integrating data into the Data Management Platform, applying transformations, ensuring data quality and governance, and producing trusted analytics-ready datasets.

Key Responsibilities

• Design scalable and secure Azure data architectures
  
• Develop data pipelines using Azure Data Factory, Azure Databricks and Azure Synapse
  
• Manage Azure Data Lake Storage Gen2
  
• Integrate data from systems such as ServiceNow and geospatial platforms
  
• Build data models, semantic layers, data marts and analytics-ready datasets
  
• Develop ETL/ELT workflows using Python, PySpark and SQL
  
• Work with Azure API Management and REST APIs
  
• Implement data governance, metadata, classification and lineage
  
• Apply security controls including RBAC, encryption and data masking
  
• Monitor and troubleshoot pipelines for reliability and performance
  
• Use AI/automation tools for code generation, testing, monitoring and documentation
  
• Develop standardized datasets supporting analytics and future AI use cases.
  

Requirements

Must-Have Qualifications

Requirement
Experience
Computer Science or related post-secondary education
Required
Data solutions for trusted, analytics-ready datasets, semantic layers/data marts/data products
3+ years
Git/GitHub version control
4+ years
Azure Storage, SQL, Synapse, networking & secure authentication
3+ years
Python/PySpark & SQL for Data Engineering
5+ years
Azure Databricks & Delta Lake
3+ years
AI for code generation, data analysis and automation
1+ year

Nice-to-Have

• Data/business requirements analysis – 6 years
  
• Microsoft SQL Server – 6 years
  
• Microsoft Fabric – 2 years
  
• Government of Alberta Cloud data products – 1 year
  
• RESTful API design/integration – 3 years
  
• Message queuing technologies such as ActiveMQ / Azure Service Bus – 3 years
  
• Cross-functional software/data product development – 5 years