Senior Data Analyst

Senior Data Analyst

Full-Time 45000 - 55000 £ / year (est.) Hybrid
CGI

At a Glance

  • Tasks: Transform complex data into actionable insights and innovative solutions.
  • Company: Join CGI, a top-rated employer known for its inclusive culture.
  • Benefits: Enjoy competitive salary, private healthcare, pension, and a share scheme.
  • Other info: Collaborative environment with opportunities for professional growth and development.
  • Why this job: Make a real impact in data-driven transformation with cutting-edge technology.
  • Qualifications: Experience in Python, SQL, and data modelling is essential.

The predicted salary is between 45000 - 55000 £ per year.

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.

Your future duties and responsibilities:

  • Take ownership of delivering high-quality data analysis and analytical solutions that help clients make confident, evidence-based decisions.
  • Work across the full delivery lifecycle, from initial discovery and requirements gathering through to data modelling, transformation and reporting.
  • Translate complex business challenges into practical, scalable solutions.
  • Use your expertise in Python, SQL and modern data platforms to improve data quality, develop trusted data products and support cloud-based transformation initiatives.
  • Influence technical decisions, challenge existing approaches and introduce innovative ways of working.
  • Collaborate with Data Engineers, Architects and business stakeholders to 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.

What you can expect from us:

Together, as owners, let’s turn meaningful insights into action. Life at CGI 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. You’ll 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. You’ll shape your career by joining a company built to grow and last. You’ll 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.

Senior Data Analyst employer: CGI

At CGI, we pride ourselves on being an inclusive employer that fosters a supportive and collaborative work culture. As a Platform Engineer in Glasgow, you'll enjoy competitive benefits including a strong pension scheme, private healthcare, and the opportunity to become a CGI Partner through our share scheme. With a commitment to employee growth and development, you'll have the freedom to innovate and make a meaningful impact while working alongside a diverse community of experts dedicated to shaping the future of technology.

CGI

Contact Details:

CGI Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Senior Data Analyst

✨Get Involved in Data Science Meetups

Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like CGI!

✨Show Off Your Projects

Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Senior Data Analyst at CGI.

✨Leverage Professional Networks

Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like CGI.

✨Apply Directly through Our Website

When you find a suitable opening like Senior Data Analyst at CGI, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!

We think you need these skills to ace Senior Data Analyst

Data Analysis
Python
SQL
Data Modelling
ETL/ELT
Lakehouse Architecture
Business Intelligence

Some tips for your application 🫡

Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!

Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!

Craft a Tailored Cover Letter:For a full-time role at CGI, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.

Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at CGI. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!

How to prepare for a job interview at CGI

✨Brush Up on Your Statistics

For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!

✨Showcase Your Projects

Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!

✨Get Comfortable with Python and R

Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at CGI!

✨Prepare for Case Studies

Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.