Data Engineer – Intermediate

Data Engineer Intermediate (GOAPRDJP)

Interview Window: 2731 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.
  
• Manage Azure Data Lake Storage Gen2.
  
• 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.
  
• Design secure REST APIs using Azure API Management.
  
• 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 Azure Databricks Delta Lake Workflows Jobs Notebooks Cluster Management.
  
• 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)