Data Analyst apprentice

Job Title

Data Analyst Trainee – SAS Migration & Testing Automation (DMRR)

Job Profile

Entry‑level / Internship – Data Analyst (Technology / Data Engineering Support)

Business Unit

LCH SA – IT Shared Applications

Team: Data Management & Risk Reporting (DMRR)

Reporting Line

Reports to: IT Manager – Reporting Capabilities (DMRR Shared Apps)

Job Purpose

The Data Analyst Trainee will support the DMRR Shared Applications team in the automation and execution of testing activities related to the migration of the SAS-based Infocentre platform from legacy infrastructure (ATOS) to OVH Cloud.

The role contributes to ensuring:

Data consistency and completeness across environments

Industrialisation of testing processes

Reduction of manual validation effort

The trainee will work on data validation frameworks, reconciliation processes, and automated test execution supporting the overall migration program

Key Responsibilities

1. Automated Testing Development

Contribute to the design and implementation of automated testing frameworks covering:SAS job execution validationReport and dataset validationEnd-to-end process testing

Develop scripts (SAS / Python) to:Execute test cases across environments (legacy vs OVH)Detect discrepancies and generate structured outputs

Standardise test outputs for reuse and reporting

2. Data Validation & Reconciliation

Perform data reconciliation between source and target environments

Analyse:Input/output data flowsBatch processing outputsCritical datasets used in reporting chains

Build reusable comparison logic:Record-level checksAggregated controls (KPIs, totals, volumes)

Document data discrepancies and support investigation

3. Testing Execution Support

Participate in test cycles across multiple environments :Sandbox / DevPre‑Production (EUA)Production validation phases

Support:Regression testing of SAS processesBatch validation and scheduling checks

Assist in prioritisation of test scope based on data criticality

4. Monitoring & Reporting

Produce structured outputs on:Test execution statusIdentified defects and anomalies

Contribute to development of dashboards (Power BI / Python):Migration readiness indicatorsData quality trends

Support reporting to IT and project governance bodies

5. Continuous Improvement

Identify opportunities to:Automate repetitive validation tasksImprove efficiency of testing processes

Contribute to documentation of:Testing proceduresData validation rules

Develop understanding of DMRR data ecosystem and reporting flows

Required Qualifications & Skills

Education

Master’s degree (or currently pursuing) in:Data AnalyticsComputer ScienceEngineering or equivalent

Technical Skills

Knowledge of:Python (pandas or equivalent data libraries)SQL and relational data concepts

Interest in:SAS environment (SAS Base / SAS Studio)Data pipelines and batch processing

Familiarity with:Git / version control (preferred)Cloud environments (preferred)

Core Competencies

Strong analytical and problem‑solving skills

Attention to detail and data accuracy

Structured and methodical approach

Ability to work in a team environment

Good written and verbal communication skills

Key Deliverables

Automated test scripts (SAS / Python)

Data reconciliation tools and outputs

Test execution reports

Documentation of validation and testing procedures

Success Measures

Ability to detect and explain data inconsistencies

Reduction in manual testing effort through automation

Quality and reliability of testing outputs

Contribution to smooth migration with no material data discrepancies

Working Relationships

Internal:DMRR Shared Apps teamInfrastructure / Cloud teamsDevOps / CI‑CD teams

Career Stage:

Associate

London Stock Exchange Group (LSEG) Information:

Join us and be part of a team that values innovation, quality, and continuous improvement. If you're ready to take your career to the next level and make a significant impact, we'd love to hear from you.

LSEG is a leading global financial markets infrastructure and data provider. Our purpose is driving financial stability, empowering economies and enabling customers to create sustainable growth.

Our purpose is the foundation on which our culture is built. Our values of Integrity, Partnership , Excellence and Change underpin our purpose and set the standard for everything we do, every day. They go to the heart of who we are and guide our decision making and everyday actions.

Working with us means that you will be part of a dynamic organisation of 25,000 people across 65 countries. However, we will value your individuality and enable you to bring your true self to work so you can help enrich our diverse workforce.

We are proud to be an equal opportunities employer. This means that we do not discriminate on the basis of anyone’s race, religion, colour, national origin, gender, sexual orientation, gender identity, gender expression, age, marital status, veteran status, pregnancy or disability, or any other basis protected under applicable law. Conforming with applicable law, we can reasonably accommodate applicants' and employees' religious practices and beliefs, as well as mental health or physical disability needs.

You will be part of a collaborative and creative culture where we encourage new ideas. We are committed to sustainability across our global business and we are proud to partner with our customers to help them meet their sustainability objectives. Our charity, the LSEG Foundation provides charitable grants to community groups that help people access economic opportunities and build a secure future with financial independence. Colleagues can get involved through fundraising and volunteering.

LSEG offers a range of tailored benefits and support, including healthcare, retirement planning, paid volunteering days and wellbeing initiatives.

Please take a moment to read this privacy notice carefully, as it describes what personal information London Stock Exchange Group (LSEG) (we) may hold about you, what it’s used for, and how it’s obtained, your rights and how to contact us as a data subject .

If you are submitting as a Recruitment Agency Partner, it is essential and your responsibility to ensure that candidates applying to LSEG are aware of this privacy notice.