Lead Analyst - Azure Data Brick With Etl And Power Bi @ CGI

Develop 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 Fabric's 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
. Develop scalable ETL/ELT pipelines using Apache Spark, PySpark, and Databricks Workflows.
. Development of integration of Databricks with enterprise systems such as data catalogs, data quality frameworks, ML platforms, and BI tools.
. Design and development of high-performance reporting models and paginated reports, configurable inquiries and interactive dashboards using Power BI.
. Guide and implement teams in implementing CI/CD pipelines, version control, and automated testing for Databricks notebooks and jobs.
. Provide technical leadership in performance tuning, cost optimization, and cluster configuration.
. Participate in 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 5 years of relevant experience.Must to have Skills-
6+ of experience in data architecture and engineering, with 5+ years in Databricks and Apache Spark. Strong proficiency in SQL & DAX
. Experience of migrating Snowflake and other custom EDW/ ETL solutions to Databricks.
. Experience of migrating different reporting solutions like Cognos, SAP BO etc to Power BI and Databricks.
. Deep knowledge and practical experience with Kimball dimensional modelling and data warehousing concepts and temporal data structures.
. Expertise in designing and deploying ETL/ELT pipelines for large-scale data integration.
. Proficiency in Power BI for paginated report and dashboard development, including DAX.
. Deep expertise in Delta Lake, structured streaming, PySpark, and SQL.
. Strong understanding of Lakehouse architecture, data mesh, and modern data stack principles.
. Experience with Unity Catalog, Databricks Repos, Jobs API, and Workflows.
. Proven ability to design and implement secure, governed, and highly available data platforms.
. Familiarity with cloud platforms (Azure, AWS, GCP) and their integration with Databricks.
. Experience with CI/CD, DevOps, and infrastructure-as-code tools (Terraform, GitHub Actions, Azure DevOps).
. Knowledge of machine learning lifecycle, MLflow, and model deployment strategies.
. An understanding of E-R data models (conceptual, logical, and physical).
. Understanding of advanced data warehouse concepts is required
. Strong analytical skills, including a thorough understanding of how to interpret customer business requirements and translate them into technical designs and solutions.
. Strong communication skills both verbal and written. Capable of collaborating effectively across a variety of IT and Business groups, across regions, roles and able to interact effectively with all levels.
. Strong problem-solving skills. Ability to identify where focus is needed and bring clarity to business objectives, requirements, and priorities.Must to Have :