Azure Data ModelerLead

Position Description:

This role is hybrid and requires you to be at our Client office at a minimum 5 days a month- subject to change at any time.

Your future duties and responsibilities:

Roles & Responsibilities:
. Analyze current and related source systems existing schemas and ETL to understand entities relationships and business rules
. Design and deliver conceptual logical and physical data models to support migration to the target Azure data platform
. Produce and maintain key modelling artefacts:
- Conceptual logical physical models
- Entity-relationship diagrams (ERDs)
- Data dictionary metadata catalog and data lineage views
- Modelling standards naming conventions and guidelines
. Define source-to-target mappings from legacy structures to cloud-based data lakehouse / warehouse models
. Collaborate with data engineers on model implementation (tables views Delta models partitioning performance design)
. Work with business SMEs to validate data definitions hierarchies KPIs and transformation rules for data domains
. Support QA and reconciliation by defining validation rules between legacy and new platform
. Contribute to data governance for data: lineage impact analysis and controlled evolution of models over time

Required qualifications to be successful in this role:

. 7-10 years of experience with physical and relational data modeling.
. Strong experience in data modelling (conceptual logical physical) for DW/analytics platforms
. Proven ability to translate business concepts logical models physical data structures in DBs DWHs and data lakehouses
. Hands-on experience with ERDs data dictionaries/metadata catalogs data lineage and modelling standards
. Solid understanding of data warehousing and data engineering concepts including:
- Data warehouse design
- Star schema / Snowflake schema
- DataMesh architecture (data products)
- Data Pattern 5.0
. Strong SQL skills and experience analyzing complex source systems.
. Experience in migration/modernization projects (on-prem to cloud OCR/data platform re-platforming)
. Familiarity with Azure data stack: Azure Data Lake Azure Databricks / Spark Azure Data Factory (concepts of pipelines & orchestration)
. Understanding of data quality governance metadata and lineage practices
. Good communication skills and ability to work closely with business SMEs architects and engineering teams
. Training/Certifications (nice to have): CGI internal data engineering trainings Azure Cloud Fundamentals Azure Data Fundamentals plus hands-on project experience

#LI-AV1

Skills:

• Cloud Computing
• Embedded Software Development
• ETL
• Financial Services
• Snowflake
• Software Architecture
• SQLite
• Statistical Analysis

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.

At CGI we value the strength that diversity brings and are committed to fostering a workplace where everyone belongs. We collaborate with our clients to build more inclusive communities and empower all CGI partners to thrive. As an equal-opportunity employer being able to perform your best during the recruitment process is important to us. If you require an accommodation please inform your recruiter.

To learn more about accessibility at CGI contact us via email. Please note that this email is strictly for accessibility requests and cannot be used for application status inquiries.

Come join our teamone of the largest IT and business consulting services firms in the world.