Data Engineer – Intermediate

SereneAID; Edmonton; On-site; CAD 90,000 - 120,000; Full time

Job summary

The Government of Alberta is seeking an Intermediate Data Engineer to support the Digital Regulatory Assurance System (DRAS) modernization. The successful candidate will design, develop, and maintain enterprise-scale Azure data platforms, build analytics-ready datasets, and create secure, scalable data pipelines supporting regulatory reporting, compliance monitoring, and business intelligence.

The role will work with ServiceNow, APIs, and geospatial data, develop semantic models and data marts,

Qualifications

• Experience designing analytics-ready data platforms and pipelines.
• 1+ year using AI-assisted code generation, automation, or data analysis.
• 3+ years designing analytics-ready data platforms (Power BI, Synapse, semantic models, data marts).
• 2+ years Databricks data governance, metadata management, and security.
• 4+ years GitHub/Git.
• 3+ years Azure services (Storage, SQL, Synapse, Networking, Managed Identity, Service Principals).
• 5+ years Python (PySpark) and SQL for enterprise ETL/ELT.

Responsibilities

• Design scalable Azure data architecture for cloud and hybrid environments.
• Build and maintain ETL/ELT pipelines using: Azure Databricks, Delta Lake, Azure Data Factory, Azure Synapse Analytics
• Develop data workflows using Python (PySpark) and SQL.
• Integrate data from ServiceNow, APIs, and geospatial systems.
• Develop semantic models, data marts, and analytics-ready datasets.
• Implement data governance, metadata management, lineage, and security.
• Optimize enterprise data pipelines and monitor performance.
• Utilize AI-assisted development tools for code generation, automation, testing, and documentation.
• Support regulatory analytics and future AI initiatives.

Skills

Azure Databricks

Python (PySpark)

SQL

Data governance

ETL/ELT pipelines

REST API integration

Education

Post-secondary degree in Computer Science or related field

Tools

Azure Data Factory

Azure Synapse Analytics

Delta Lake

ServiceNow

Power BI

Git / GitHub

Talend ETL

REST API development

Job description

Client: Government of Alberta (GOA) – Technology and Innovation

Project: Digital Regulatory Assurance System (DRAS)

Location: Edmonton, Alberta (Primarily Remote; must attend onsite meetings in Edmonton 3–4 times/month as required)

Duration: Approximately 12 months + possible 6-month extension

Hours: 36.25 hours/week (7.25 hours/day)

Interview Window: 27–31 July 2026

Job Description

The Government of Alberta is seeking an Intermediate Data Engineer to support the Digital Regulatory Assurance System (DRAS) modernization initiative. The successful candidate will design, develop, and maintain enterprise-scale Azure data platforms, build analytics-ready datasets, and create secure, scalable data pipelines supporting regulatory reporting, compliance monitoring, and business intelligence.

Requirements

Key Responsibilities

• Design scalable Azure data architecture for cloud and hybrid environments.
  
• Build and maintain ETL/ELT pipelines using:
  • Azure Databricks
    
  • Delta Lake
    
  • Azure Data Factory
    
  • Azure Synapse Analytics
    
• Develop data workflows using Python (PySpark) and SQL.
  
• Integrate data from ServiceNow, APIs, and geospatial systems.
  
• Develop semantic models, data marts, and analytics-ready datasets.
  
• Implement data governance, metadata management, lineage, and security.
  
• Optimize enterprise data pipelines and monitor performance.
  
• Utilize AI-assisted development tools for code generation, automation, testing, and documentation.
  
• Support regulatory analytics and future AI initiatives.
  

Mandatory Requirements

• Post-secondary degree/diploma in Computer Science or related field.
  
• 1+ year using AI-driven code generation, automation, or data analysis.
  
• 3+ years designing analytics-ready data platforms (Power BI, Synapse, semantic models, data marts).
  
• 2+ years Databricks data governance, metadata management, and security.
  
• 4+ years GitHub/Git.
  
• 3+ years Azure services (Storage, SQL, Synapse, Networking, Managed Identity, Service Principals).
  
• 5+ years Python (PySpark) and SQL for enterprise ETL/ELT.
  

Nice-to-Have Skills

• Business/data requirement analysis (6+ years)
  
• Microsoft SQL Server (6+ years)
  
• Microsoft Fabric (2+ years)
  
• Government of Alberta Cloud experience (1+ year)
  
• Talend ETL (2+ years)
  
• REST API development (3+ years)
  
• Cross-functional software development (5+ years)
  
• ServiceNow integrations (1+ year)
  
• Azure Service Bus / ActiveMQ messaging (3+ years)