[Security Clearance Role] - Senior Data Engineer - SDE 26-04860

Job Title: Senior Data Engineer

Location: Edmonton, AB (Remote with occasional onsite requirements)
Duration: 12 Months

Security & Compliance

• Criminal record check may be required.
• Enhanced security clearance may be required for certain assignments.
• Additional high-level clearances may be required during the engagement.

Project Overview

A large public sector organization is undertaking a major digital transformation initiative to deliver simpler, more efficient, and user-centered services. A dedicated Digital Design and Delivery division has been established to drive innovation, modernization, and adoption of modern data practices across multiple departments.

The organization is seeking a Senior Data Engineer to support service innovation, program reviews, and digital transformation initiatives. The role involves working within cross-functional agile teams, collaborating with product owners, designers, and engineers to deliver high-quality data solutions.

Role Summary

The ideal candidate will have strong expertise in data engineering and analytics, with the ability to design scalable data architectures, build reliable pipelines, and generate actionable insights. This role combines hands-on engineering with analytical and stakeholder-facing responsibilities.

Key Responsibilities

Data Engineering

• Design, build, and maintain scalable data pipelines (on-premises and cloud: Azure, AWS, Google Cloud Platform).
• Develop and optimize dimensional data models (star/snowflake schemas).
• Integrate data from multiple sources (SQL, NoSQL, APIs, files) ensuring data quality and consistency.
• Build and maintain ETL/ELT pipelines using tools such as SSIS and Azure Data Factory (ADF).
• Enhance data workflows for scalability, reliability, and performance.
• Implement CI/CD pipelines for automated deployment and testing of data solutions.
• Manage data lakes and data warehouses with proper governance and security controls.
• Collaborate with cross-functional teams to translate business requirements into data solutions.
• Develop curated data marts to support analytics and reporting.

Data Analytics

• Analyze datasets to identify trends, patterns, and anomalies.
• Develop dashboards and reports using Power BI, DAX, or similar tools.
• Build predictive/descriptive models using Python or R.
• Communicate insights clearly to both technical and non-technical stakeholders.
• Support agile delivery and promote data-driven decision-making.
• Mentor teams on analytics best practices and self-service BI capabilities.

Work Environment

• Primarily remote, with occasional onsite meetings in Edmonton.
• Some travel within the region may be required.
• Candidates must be authorized to work within Canada.

Mandatory Requirements

• Bachelor s degree in Computer Science, IT, or a related field.
• 5+ years of experience as a Data Engineer and/or Data Analyst.
• Experience ensuring data quality, security, and governance.
• 3+ years designing dimensional models (star/snowflake schemas).
• 3+ years developing dashboards and visualizations (Power BI, Tableau, Python).
• 5+ years working with diverse data sources (on-prem and cloud).
• 3+ years experience with data migrations across environments.
• 2+ years experience with:
  • Git and collaborative workflows
  • CI/CD pipelines
  • Containerization (Docker/Kubernetes)
  • Infrastructure as Code (Terraform, ARM, CloudFormation)
• 3+ years experience with:
  • SSIS
  • Azure Data Factory
  • API-based data integration

Nice to Have

• Experience in application development (OOP or functional programming).
• Experience working in large enterprise or public sector environments.
• Familiarity with databases and tools such as:
  • PostgreSQL, MongoDB, Azure Cosmos DB
  • Synapse, Fabric, Informatica, Talend, DBT, Airbyte
• Exposure to AI/ML workflows (e.g., Databricks, Azure ML).

Additional Notes

• Candidates may be required to complete mandatory training (privacy, security, workplace conduct, etc.).
• Work hours may vary depending on project needs.