Find similar career opportunities
Senior Data Engineering Consultant Category: Software Development/ Engineering
Main location: Canada, British Columbia, Vancouver
Position ID:J0926-0668
Employment Type: Full Time
Position Description: Our BC offices are building another new team! This exciting initiative will bring together highly skilled data scientists, architects and developers to deliver an innovative solution to a client in the Public sector. We are seeking a Senior Data Engineering Consultant to join our growing data practice and help clients deliver modern, secure, and scalable enterprise data solutions on Microsoft Azure.
Your future duties and responsibilities: . Design, build, and support enterprise-grade data platforms and pipelines that ingest, transform, and serve data from structured and unstructured sources at scale
. Develop secure, repeatable, and highly performant ETL/ELT pipelines using Azure-native services and modern engineering practices
. Build data transformation and orchestration workflows for batch and near real-time processing (event-driven patterns where required)
. Implement data ingestion across APIs, SaaS applications, databases, and file-based sources.
. Apply strong data security controls to protect data in transit and at rest, aligned with client and regulatory requirements
. Develop data quality, validation, and reconciliation frameworks to ensure accuracy of key business metrics
. Contribute to data governance practices including metadata management, cataloging, lineage, and documentation
. Collaborate with solution architects, analysts, and stakeholders to translate business needs into technical designs and delivery plans
. Provide estimates and guidance on data gaps, feasibility, and level of effort; support delivery teams through implementation
. Produce and maintain documentation including data dictionaries, pipeline runbooks, and operational support materials
. Evaluate and recommend new tools and practices to improve reliability, performance, cost-efficiency, and maintainability
Required qualifications to be successful in this role: . Bachelor's degree or diploma in mathematics, informatics, statistics, computer science, information systems, or equivalent practical experience
. Strong hands-on experience in Microsoft Azure, including Fabric services such as Azure Data Factory, Azure Synapse Analytics, Azure Data Lake Storage (or equivalent Azure data platform components)
. Advanced SQL proficiency (data modeling, query optimization, complex transformations, performance tuning)
. Strong Python proficiency for data engineering (pipeline development, automation, validation, orchestration, APIs)
. Experience building and operating data pipelines using modern DevOps practices (CI/CD, Git workflows, automated testing, Infrastructure-as-Code exposure preferred)
. Strong understanding of data security principles and secure software development practices
Additional Experience (Preferred)
. Experience with Microsoft Azure Databricks
. Experience with Spark (PySpark), streaming/event-driven architectures, and messaging tools (e.g., Kafka, Event Hubs)
. Familiarity with Snowflake and/or lakehouse patterns
. Experience enabling analytics and reporting consumers (e.g., Power BI, semantic models, curated datasets)
. Experience working in regulated environments (financial services, government, healthcare) and supporting auditability requirements
Professional Attributes
. Strong ownership mindset; able to execute with minimal oversight and drive outcomes.
. Detail-oriented with strong organization and follow-through
. Comfortable managing multiple priorities and deadlines in a client delivery environment
. Clear, confident communicator who can translate technical concepts into business-impact language
. Passion for turning disparate data into trusted, actionable insights
#LI-ST3
CGI is providing a reasonable estimate of the pay range for this role. The determination of this range includes various factors including but not limited to skill set level, geographic market, experience and training, and licenses and certifications. Compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is $85,000 - $160,000.
Use of the term 'engineering' in this job posting refers to the technical sense related to Information Technology (IT) and does not imply that the individual practices engineering or possesses the requisite license as prescribed by the applicable provincial or territorial engineering regulator. We are seeking individuals with expertise in IT engineering-related functions, but licensure from an engineering regulator is not a prerequisite for this position. Engineering is a regulated profession in Canada which is restricted in terms of use of titles and designation.
Skills: What you can expect from us: 
