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
• Design indexing strategies (clustered, non-clustered, column store) for performance improvement
• 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)

CGI is an equal opportunity employer. In addition, CGI is committed to providing accommodation for people with disabilities in accordance with provincial legislation. Please let us know if you require reasonable accommodation due to a disability during any aspect of the recruitment process and we will work with you to address your needs.

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 empl…