Azure Data Engineer - Senior Software Engineer

Company Profile:

Founded in 1976, CGI is among the largest independent IT and business consulting services firms in the world. With 94,000 consultants and professionals across the globe, CGI delivers an end-to-end portfolio of capabilities, from strategic IT and business consulting to systems integration, managed IT and business process services and intellectual property solutions. CGI works with clients through a local relationship model complemented by a global delivery network that helps clients digitally transform their organizations and accelerate results. CGI Fiscal 2024 reported revenue is CA$14.68 billion and CGI shares are listed on the TSX (GIB.A) and the NYSE (GIB). Learn more at cgi.com.

Job Title: Azure Data Engineer – Senior Software Engineer.

Position: Senior Software Engineer

Experience: 5 to 10 Yrs

Category: Software Development/ Engineering

Shift: 10:00 AM to 6 PM(3 Days Mandatory Work from Office)

Main location: CGI India

Position ID: J0626-1911

Employment Type: Full Time

Education Qualification: Bachelor's degree in Computer Science or related field or higher with minimum 3 years of relevant experience.

Position Description: Designed and implemented a scalable enterprise data platform on Microsoft Azure to centralize data from multiple business systems. Built a Lakehouse architecture using Azure Data Lake Storage and developed robust ETL/ELT pipelines for ingesting, transforming, and loading large-scale datasets. Created conceptual, logical, and physical data models, implementing star and snowflake schemas to support business intelligence and advanced analytics.

Responsibilities:

Design and implement scalable data architectures using Microsoft Azure

Build and manage data warehouse/Lakehouse solutions with Azure Data Lake Storage

Develop conceptual, logical, and physical data models aligned with business needs

Implement star and snowflake schemas for efficient analytics and reporting

Build and optimize complex stored procedures in Microsoft SQL Server using T-SQL

Apply advanced SQL techniques including joins, CTEs, and window functions

Optimize query performance using execution plans and query tuning techniques

Implement table partitioning and efficient data distribution for large datasets

Optimize ETL/ELT pipelines for scalability, reliability, and cost efficiency

Monitor and resolve performance issues such as blocking, deadlocks, and long-running queries

Implement Slowly Changing Dimensions (SCD Type 1 & 2) for historical tracking

Ensure data quality, governance, validation, and security compliance

Develop dashboards and reports using Microsoft Power BI and collaborate with stakeholders

Lead and mentor data engineers, driving best practices, code reviews, and architectural decisions

Must-Have Skills:

Strong hands-on experience with Microsoft Azure data services

Design and implementation of scalable Azure data architectures

Strong understanding of Enterprise data warehouse architecture

Lakehouse architecture patterns & Data ingestion and transformation frameworks

Batch and incremental data processing.

Mandatory expertise in: Conceptual, logical, and physical data modelling

Dimensional modelling techniques Star schema design Snowflake schema design

Fact and dimension modelling

Slowly Changing Dimensions:

SCD Type 1

SCD Type 2

Data normalization and denormalization principles

Good to Have

Experience with Azure Databricks and Apache Spark for large-scale data processing and transformation

Knowledge of PySpark / Python programming for data engineering automation and advanced transformations

Experience with Delta Lake and Lakehouse architecture (Bronze, Silver, Gold layer implementation)

Life at CGI:

It is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…

You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction

Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise

You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons

Come join our team, one of the largest IT and business consulting services firms in the world

#LI-PJ1

Your future duties and responsibilities

Required qualifications to be successful in this role

Together, as owners, let’s turn meaningful insights into action.

Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…

You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.

Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.

You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

Come join our team—one of the largest IT and business consulting services firms in the world.