Data Engineer - Senior

Data Engineer – Senior 

Client: Government of Alberta – Technology and Innovation

Project: Digital Regulatory Assurance System (DRAS)

Location: Edmonton, Alberta – 9942 108 ST, Edmonton, AB T5K 2J5

Contract & Work Schedule

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

Role Overview

The Senior Data Engineer will primarily support the DRAS program , designing and operating reliable data pipelines and data products. The role focuses on data ingestion, integration, transformation, governance, quality, and delivery of trusted analytics-ready datasets for regulatory, compliance, reporting, and future AI use cases.

Key Responsibilities

• Design scalable, secure Microsoft Azure data architectures
  
• Build data ingestion and transformation pipelines using Azure Data Factory, Azure Databricks and Azure Synapse
  
• Manage Azure Data Lake Storage Gen2
  
• Integrate data from ServiceNow, geospatial systems and other source systems
  
• Develop data models and semantic layers
  
• Build and optimize ETL/ELT workflows using Python, PySpark and SQL
  
• Develop secure APIs and data services using Azure API Management
  
• Implement data governance, metadata, classification and lineage
  
• Apply security controls including RBAC, encryption and data masking
  
• Monitor and troubleshoot data pipelines and integrations
  
• Use AI and automation for pipeline development, testing, monitoring and documentation
  
• Curate standardized, high-quality datasets for advanced analytics and AI.
  

Requirements

Must-Have Requirements

Skill / Qualification
Required Experience

3+ years

4+ years

3+ years

5+ years

3+ years

1+ year

Nice-to-Have

• Data requirements analysis / transformation / cleansing / wrangling – 6 years
  
• Microsoft SQL Server – 6 years
  
• Microsoft Fabric – 2 years
  
• Government of Alberta Cloud environment – 1 year
  
• RESTful API design/integration – 3 years
  
• ActiveMQ / Azure Service Bus / Message Queueing – 3 years
  
• Cross-functional software and data product development – 5 years