Data Analyst
Posted Updated
Description
At CGI, we help organisations unlock the value of their data, transforming complex information into trusted insights that drive smarter decisions and meaningful business outcomes. As a Data Analyst, you’ll play a key role in shaping innovative data solutions, modernising analytics platforms and helping clients realise the full potential of their data. Working alongside talented engineers, architects and business stakeholders, you’ll take ownership of challenging assignments, bring fresh thinking to complex problems and deliver solutions that make a lasting difference. With the freedom to influence outcomes, opportunities to develop your expertise and the support of a collaborative community, you’ll help shape the future of data-driven transformation.
CGI was recognised in the Sunday Times Best Places to Work List 2025 and has been named a UK ‘Best Employer’ by the Financial Times. We offer a competitive salary, excellent pension, private healthcare, plus a share scheme (3.5% + 3.5% matching) which makes you a CGI Partner not just an employee. We are committed to inclusivity, building a genuinely diverse community of tech talent and inspiring everyone to pursue careers in our sector, including our Armed Forces, and are proud to hold a Gold Award in recognition of our support of the Armed Forces Corporate Covenant. Join us and you’ll be part of an open, friendly community of experts. We’ll train and support you in taking your career wherever you want it to go.
Due to the secure nature of the programme, you will need to hold UK Security Clearance or be eligible to go through this clearance. These roles will be predominately hybrid with some work based in UK CGI or client offices depending on the specific programme. Travel away from base office will be expensed.
You'll have the opportunity to influence technical decisions, challenge existing approaches and introduce innovative ways of working. Collaborating with Data Engineers, Architects and business stakeholders, you'll contribute to a supportive environment where knowledge sharing, continuous improvement and professional development are encouraged.
Key responsibilities include:
• Lead & Discover: Facilitate stakeholder workshops to understand business objectives, gather requirements and translate findings into technical specifications, user stories and acceptance criteria.
• Analyse & Investigate: Use Python, pandas and SQL to explore complex datasets, identify patterns and anomalies, investigate root causes and deliver actionable insights.
• Design & Model: Develop conceptual, logical, physical and dimensional data models, defining relationships, business rules, source-to-target mappings and data lineage.
• Transform & Modernise: Support data transformation and migration initiatives using modern Lakehouse platforms, including Azure and Databricks.
• Develop & Validate: Apply Bronze, Silver and Gold medallion architecture principles to create governed, reliable and business-ready data products.
• Visualise & Communicate: Build insightful reports and dashboards using Power BI or comparable tools, translating analytical findings into clear business recommendations.
• Optimise & Assure: Analyse ETL/ELT pipelines, implement data quality controls, coordinate reconciliation and user acceptance testing, and resolve data issues.
• Collaborate & Influence: Work closely with multidisciplinary Agile teams, provide trusted client advice, challenge assumptions constructively and mentor colleagues.
• Deliver & Improve: Maintain delivery backlogs and documentation using Jira or Azure DevOps, following established testing, version control and release practices.
Required qualifications to be successful in this role
To succeed in this role, you should bring strong technical data analysis capabilities, proven consulting experience and the confidence to translate complex information into meaningful business outcomes. You'll combine hands-on expertise in Python, SQL and data modelling with a solid understanding of modern data architectures. Your collaborative approach, analytical curiosity and ability to take ownership of delivery will help you build trusted relationships and contribute to successful client outcomes.
Essential skills and experience:
• Data Analysis & Consulting: Proven experience delivering data analysis or analytics solutions in client-facing or complex organisational environments.
• Python & SQL: Strong hands-on proficiency in Python, including pandas, and advanced SQL for data profiling, transformation, investigation and validation.
• Data Modelling: Experience designing conceptual, logical, physical and dimensional data models, including source-to-target mappings, data dictionaries and lineage documentation.
• ETL/ELT & Data Integration: Strong understanding of data pipelines, transformation processes and integration between source systems and downstream services.
• Lakehouse Architecture: Good understanding of modern Lakehouse platforms and Bronze, Silver and Gold medallion architecture principles.
• Business Intelligence: Experience developing reports and dashboards using Power BI or comparable BI technologies.
• Requirements & Documentation: Ability to translate business requirements into clear technical specifications, user stories and acceptance criteria.
• Stakeholder Engagement: Strong communication, workshop facilitation and consulting skills, with experience collaborating across multidisciplinary Agile teams.
Desirable skills and experience:
• Experience with Microsoft Azure, Azure SQL, Azure Data Factory or Databricks, including SQL workload migration.
• Familiarity with data modelling tools such as Hackolade or ERwin.
• Knowledge of Microsoft Fabric, Azure Synapse, Spark or PySpark.
• Experience with Tableau, Qlik, semantic layers, data governance or observability tools.
• Understanding of APIs and structured data formats, including JSON and XML.
• Experience delivering data solutions within public sector, transport or other regulated environments.
#LI-JW1
CGI was recognised in the Sunday Times Best Places to Work List 2025 and has been named a UK ‘Best Employer’ by the Financial Times. We offer a competitive salary, excellent pension, private healthcare, plus a share scheme (3.5% + 3.5% matching) which makes you a CGI Partner not just an employee. We are committed to inclusivity, building a genuinely diverse community of tech talent and inspiring everyone to pursue careers in our sector, including our Armed Forces, and are proud to hold a Gold Award in recognition of our support of the Armed Forces Corporate Covenant. Join us and you’ll be part of an open, friendly community of experts. We’ll train and support you in taking your career wherever you want it to go.
Due to the secure nature of the programme, you will need to hold UK Security Clearance or be eligible to go through this clearance. These roles will be predominately hybrid with some work based in UK CGI or client offices depending on the specific programme. Travel away from base office will be expensed.
Profil recherché
In this role, you will take ownership of delivering high-quality data analysis and analytical solutions that help clients make confident, evidence-based decisions. Working across the full delivery lifecycle, from initial discovery and requirements gathering through to data modelling, transformation and reporting, you will translate complex business challenges into practical, scalable solutions. You'll use your expertise in Python, SQL and modern data platforms to improve data quality, develop trusted data products and support cloud-based transformation initiatives.You'll have the opportunity to influence technical decisions, challenge existing approaches and introduce innovative ways of working. Collaborating with Data Engineers, Architects and business stakeholders, you'll contribute to a supportive environment where knowledge sharing, continuous improvement and professional development are encouraged.
Key responsibilities include:
• Lead & Discover: Facilitate stakeholder workshops to understand business objectives, gather requirements and translate findings into technical specifications, user stories and acceptance criteria.
• Analyse & Investigate: Use Python, pandas and SQL to explore complex datasets, identify patterns and anomalies, investigate root causes and deliver actionable insights.
• Design & Model: Develop conceptual, logical, physical and dimensional data models, defining relationships, business rules, source-to-target mappings and data lineage.
• Transform & Modernise: Support data transformation and migration initiatives using modern Lakehouse platforms, including Azure and Databricks.
• Develop & Validate: Apply Bronze, Silver and Gold medallion architecture principles to create governed, reliable and business-ready data products.
• Visualise & Communicate: Build insightful reports and dashboards using Power BI or comparable tools, translating analytical findings into clear business recommendations.
• Optimise & Assure: Analyse ETL/ELT pipelines, implement data quality controls, coordinate reconciliation and user acceptance testing, and resolve data issues.
• Collaborate & Influence: Work closely with multidisciplinary Agile teams, provide trusted client advice, challenge assumptions constructively and mentor colleagues.
• Deliver & Improve: Maintain delivery backlogs and documentation using Jira or Azure DevOps, following established testing, version control and release practices.
Required qualifications to be successful in this role
To succeed in this role, you should bring strong technical data analysis capabilities, proven consulting experience and the confidence to translate complex information into meaningful business outcomes. You'll combine hands-on expertise in Python, SQL and data modelling with a solid understanding of modern data architectures. Your collaborative approach, analytical curiosity and ability to take ownership of delivery will help you build trusted relationships and contribute to successful client outcomes.
Essential skills and experience:
• Data Analysis & Consulting: Proven experience delivering data analysis or analytics solutions in client-facing or complex organisational environments.
• Python & SQL: Strong hands-on proficiency in Python, including pandas, and advanced SQL for data profiling, transformation, investigation and validation.
• Data Modelling: Experience designing conceptual, logical, physical and dimensional data models, including source-to-target mappings, data dictionaries and lineage documentation.
• ETL/ELT & Data Integration: Strong understanding of data pipelines, transformation processes and integration between source systems and downstream services.
• Lakehouse Architecture: Good understanding of modern Lakehouse platforms and Bronze, Silver and Gold medallion architecture principles.
• Business Intelligence: Experience developing reports and dashboards using Power BI or comparable BI technologies.
• Requirements & Documentation: Ability to translate business requirements into clear technical specifications, user stories and acceptance criteria.
• Stakeholder Engagement: Strong communication, workshop facilitation and consulting skills, with experience collaborating across multidisciplinary Agile teams.
Desirable skills and experience:
• Experience with Microsoft Azure, Azure SQL, Azure Data Factory or Databricks, including SQL workload migration.
• Familiarity with data modelling tools such as Hackolade or ERwin.
• Knowledge of Microsoft Fabric, Azure Synapse, Spark or PySpark.
• Experience with Tableau, Qlik, semantic layers, data governance or observability tools.
• Understanding of APIs and structured data formats, including JSON and XML.
• Experience delivering data solutions within public sector, transport or other regulated environments.
#LI-JW1
Skills
- Acceptance Criteria
- Agile
- Analytics
- API
- Azure
- Azure Data Factory
- Azure DevOps
- Azure Synapse
- Business Intelligence
- Cloud
- Data Governance
- Data Lineage
- Data Modeling
- Data Pipelines
- Data Quality
- Databricks
- DevOps
- ELT
- ETL
- Jira
- JSON
- Lakehouse
- Medallion Architecture
- Microsoft Fabric
- Observability
- pandas
- Power BI
- PySpark
- Python
- Qlik
- Requirements Gathering
- Spark
- SQL
- Tableau
- User Stories
- Version Control
- XML
Sign in to read and join the discussion.