Associate Consultant Azure Data Brick Architect

Position Description:

Company Profile:
Founded in 1976 CGI is among the largest independent IT and business consulting services firms in the world. With 94000 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 .

Position: Associate Consultant - Azure Data Brick Architect (D
Experience: 8-15 years
Category: Software Development/ Engineering
Shift Timing: 12:00 PM to 10:00 PM
Location: Chennai /Bangalore/Hyderabad/Pune/Mumbai
Position ID: J1125-1341
Employment Type: Full Time


The ETL Data Architect will be responsible for designing developing and implementing robust and scalable data architectures and ETL solutions. This role requires deep expertise in Databricks for data processing and Lakehouse architecture Kimball dimensional modelling for data warehousing and Power BI and Microsoft Fabric for data visualization and analytics platform implementation. . As an ETL Architect you will lead the design and implementation of scalable secure and high-performance data solutions using the Databricks Lakehouse Platform. You will define architectural standards guide engineering teams and collaborate with stakeholders to align data strategies with business goals. Your role will focus on leveraging Databricks unified analytics capabilities to build enterprise-grade data platforms that support advanced analytics machine learning and real-time data processing.

Your future duties and responsibilities:

Define and own the end-to-end architecture of data platforms built on Databricks including ingestion transformation storage and consumption layers.
. Develop and maintain data models data flow diagrams and other architectural documentation based on Kimball dimensional modelling principles.
. Design and implement end-to-end data architectures leveraging Microsoft Fabrics capabilities ( Embedded Power BI integration/ implementation).
. Design and implement Lakehouse architectures using Delta Lake Unity Catalog and structured streaming.
. Proven expertise in implementing data governance using Unity Catalog including fine-grained access control column-level lineage data classification audit logging and centralized metadata management across workspaces and cloud environments
. Architect scalable ETL/ELT pipelines using Apache Spark PySpark and Databricks Workflows.
. Lead the integration of Databricks with enterprise systems such as data catalogs data quality frameworks ML platforms and BI tools.
. Lead the Design and development of high-performance reporting models and paginated reports configurable inquiries and interactive dashboards using Power BI.
. Guide teams in implementing CI/CD pipelines version control and automated testing for Databricks notebooks and jobs.
. Collaborate with data scientists engineers and business stakeholders to support ML model lifecycle management using MLflow.
. Demonstrated experience or familiarity with AI systems such as Databricks DBRX Mosaic AI and AutoML including their integration into data.
. Provide technical leadership in performance tuning cost optimization and cluster configuration.
. Conduct architectural reviews code audits and mentoring sessions to ensure adherence to standards and scalability.
. Provide technical leadership and guidance to data engineers and developers.
. Collaborate closely with clients business stakeholders and internal teams to translate business requirements into technical solutions.
. Stay current with Databricks innovations and advocate for adoption of new features and capabilities.

Required qualifications to be successful in this role:

Education Qualification: Bachelors degree in computer science or related field or higher with minimum 9 years of relevant experience.

Must to Have:
Azure Databricks Databricks Lakehouse Architecture
ETL / ELT Data Architecture
Apache Spark / PySpark Delta Lake Delta Live Tables (DLT)
Unity Catalog Medallion Architecture
Dimensional Modeling (Star & Snowflake) Kimball Data Vault
Slowly Changing Dimensions (SCD Types 1 2 3)
Data Governance RBAC Data Lineage Metadata Management
CI/CD & DevOps (Azure DevOps GitHub Actions Terraform)
SQL Power BI Self-Service Analytics Semantic Model Paginated Reports
Data Quality (Great Expectations) Performance Tuning Cost Optimization
Cloud Platforms (Azure AWS GCP) Azure Data Factory Synapse Event Hubs

Nice-to-Have Skills:
Streaming frameworks (Kafka Event Hubs) workspace automation
Advanced data modeling for Finance Performance Budgeting HRM systems
Subject-area models for financial reporting workforce analytics payroll insights
Delta Change Data Feed (CDF) and real-time data marts
Certifications:
oDatabricks Certified Data Engineer Associate / Professional
oDatabricks Certified Associate Developer for Apache Spark
oAzure / Power BI certifications

CGI is an equal opportunity 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

Skills:

• Azure Data Factory
• Azure DevOps
• English

What you can expect from us:

Together as owners lets turn meaningful insights into action.

Life at CGI is rooted in ownership teamwork respect and belonging. Here youll 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. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.

Your work creates value. Youll 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.

Youll shape your career by joining a company built to grow and last. Youll 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 teamone of the largest IT and business consulting services firms in the world.