Data Engineer

IT/IQ

  • Canada
  • Contrat
  • Temps-plein
  • Il y a 8 jours
Position: Data Engineer (Contract)
Location: Canada (Remote or On-site, depending on project)Overview
A major public sector organization is leading a large-scale digital transformation initiative aimed at improving how services are designed, delivered, and accessed. The newly formed digital delivery division plays a central role in modernizing operations, ensuring that services are efficient, human-centered, and built using modern data and technology practices. The division partners closely with internal teams across various departments to deliver impactful service reviews and end-to-end digital solutions.Role Summary
The organization is seeking an experienced Data Engineer to join cross-functional teams involved in service innovation, program evaluation, and digital delivery projects. This role supports multiple concurrent initiatives, designing and maintaining robust data pipelines and systems to support analytics, transformation, and decision-making efforts. The successful candidate will work alongside product managers, designers, analysts, and engineers in an Agile environment to deliver meaningful, data-driven outcomes.Scope of Work
The Data Engineer will be assigned to two or more active projects, working closely with product and service delivery teams. While the work may vary in location and schedule, the position is expected to provide up to 1,960 hours annually, subject to project needs and agreement.Core Responsibilities
  • Design, implement, and maintain scalable ETL/ELT pipelines both on-premises and across cloud platforms (Azure, AWS, GCP)
  • Develop and optimize dimensional data models (star and snowflake schemas) for reporting and analytics
  • Ingest and integrate data from varied sources (SQL, NoSQL, APIs, flat files) while ensuring data accuracy, validation, and completeness
  • Enhance data workflows and pipeline performance to support large-scale and high-volume datasets
  • Utilize tools like SSIS and Azure Data Factory for orchestration, with monitoring, logging, and robust error handling
  • Automate deployments and testing pipelines using CI/CD best practices, with tools such as Git and Docker
  • Implement governance frameworks, access control, and security protocols for data lakes and warehouses
  • Translate stakeholder requirements into technical solutions including curated datasets and data marts
  • Perform data exploration and analysis to uncover insights, using tools such as Python, R, and DAX
  • Build Power BI dashboards and reports to visualize KPIs, trends, and service metrics
  • Develop predictive and descriptive models using machine learning techniques to inform service improvements
  • Communicate findings to non-technical stakeholders through presentations, reports, and visualizations
  • Contribute to the development of data literacy and self-serve analytics capabilities within delivery teams
  • Work iteratively within Agile project cycles, adapting outputs based on evolving needs
Required Qualifications
  • 5+ years experience in data engineering, data analysis, or a similar technical role
  • 5+ years working with diverse data sources, both cloud-based and on-premises
  • 3+ years designing data models using star and snowflake schemas
  • 3+ years focused on data quality assurance, security protocols, and governance practices
  • 3+ years hands-on experience with SSIS, Azure Data Factory, and API integration across platforms
  • 2+ years using Git, CI/CD tools, containerization (Docker/Kubernetes), and Infrastructure-as-Code tools such as Terraform, ARM, or CloudFormation
  • 2+ years of experience in data migration across hybrid and multi-cloud environments
Preferred Qualifications
  • Experience in application development with tools such as Next.js, Node.js, D3.js
  • Familiarity with additional data platforms: PostgreSQL, MongoDB, Azure Cosmos DB, Azure Synapse, Talend
  • Exposure to AI/ML practices within cloud ecosystems like Databricks or Azure ML Studio
  • Experience deploying analytics solutions iteratively within Agile product teams
Work Environment
  • Collaborative, cross-functional teams combining design, engineering, and research
  • Agile delivery model with continuous integration and deployment cycles
  • Emphasis on modern digital practices, human-centered design, and iterative delivery
  • Flexible work arrangements depending on project scope and team requirements

IT/IQ