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:

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.