Job DescriptionData Engineer – SeniorClient: Government of Alberta – Technology and InnovationProject: Digital Regulatory Assurance System (DRAS)Location: Edmonton, Alberta – 9942 108 ST, Edmonton, AB T5K 2J5Contract & Work ScheduleHours: 36.25 hours/weekDaily: 7.25 hours/daySchedule: Monday–Friday, 8:15 AM–4:30 PM Alberta TimeWork Mode: Primarily remoteLocation Requirement: Must work from within CanadaOnsite: Edmonton meetings approximately 3–4 times per fiscal month or more, as requiredExtension: Up to 6 monthsRole OverviewThe 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 ResponsibilitiesDesign scalable, secure Microsoft Azure data architecturesBuild data ingestion and transformation pipelines using Azure Data Factory, Azure Databricks and Azure SynapseManage Azure Data Lake Storage Gen2Integrate data from ServiceNow, geospatial systems and other source systemsDevelop data models and semantic layersBuild and optimize ETL/ELT workflows using Python,



PySpark and SQLDevelop secure APIs and data services using Azure API ManagementImplement data governance, metadata, classification and lineageApply security controls including RBAC, encryption and data maskingMonitor and troubleshoot data pipelines and integrationsUse AI and automation for pipeline development, testing, monitoring and documentationCurate standardized, high-quality datasets for advanced analytics and AI.RequirementsMust-Have RequirementsAnalytics-ready data solutions, semantic layers, data marts & data products 3+ yearsGit / GitHub version control 4+ yearsAzure Storage, SQL, Synapse, networking & secure authentication 3+ yearsPython / PySpark & SQL Data Engineering 5+ yearsAzure Databricks & Delta Lake 3+ yearsAI for code generation, data analysis & automation 1+ yearNice-to-HaveData requirements analysis / transformation / cleansing / wrangling – 6 yearsMicrosoft SQL Server – 6 yearsMicrosoft Fabric – 2 yearsGovernment of Alberta Cloud setting – 1 yearRESTful API design/integration – 3 yearsActiveMQ / Azure Service Bus / Message Queueing – 3 yearsCross-functional software and data product development – 5 years #J-18808-Ljbffr

📌 Sql Server Reporting Services, Power Bi, Sql, Ssis (Edmonton)
🏢 Vantix Systems
📍 Edmonton