Data Engineer

Data Engineer – Corporate Engineering Company Profile

LSEG (London Stock Exchange Group) is a world-leading financial markets infrastructure and data business. We are dedicated, open-access partners with a commitment to excellence in delivering services across Data & Analytics, Capital Markets, and Post Trade.

Backed by three hundred years of experience, innovative technologies, and a team of over 23,000 people in 70 countries, our purpose is driving financial stability, empowering economies, and enabling customers to create sustainable growth.

Role Profile

• In this role, you'll be joining our CRM, External Digital and Marketing team within Data and Integrations Team, Corporate Engineering (CE) as a Data Engineer. This team works on data and integration requests by guiding customers on data migration cleansing, data quality techniques. This role impacts all divisional users of CRM Technology and downstream systems reliant on Customer Data – 7k users across Capital Markets, Post Trade and Data & Analytics.

The data and integrations team do this by:

• Conducting data quality analysis, end to end data reconciliations by profiling the source systems using ETL /SQL (IICS /Matillion/AWS Glue).
• Defining the data quality of the sources and lists the data quality metrics of the source systems.
• Working on detailed scoping and requirements working with business collaborators, SMEs, Technology Partner organizations and internal CRM Technology and Corporate Technology teams.
• Building and maintaining Customer Master and Product Master
• Continuously review operating metrics and data to find opportunities to improve.

Tech Profile/Essential Skills

• 7 years of technical experience.
• 5 years of experience on data migration using ETL tools.
• Able to translate business requirements into data solutions.
• Expert level skill on Informatica IICS or Matillion or equivalent ETL tool which covers from extracting the source to building the complex mappings.
• Proficient in the use or extract of data from Salesforce.
• Expert level skill on Power BI/Tableau
• Knowledge of the Salesforce Data modelling is desirable.
• Proficient level coding knowledge on Python and SQL.
• Understanding of Salesforce concepts is desirable.
• Experience with providing technical solutions and supporting documentation.

Preferred Skills and Experience

• Must have Experience on Snowflake Storage and Database.
• Should have experience of working with Cloud Native based applications using AWS/Azure
• Understanding of the SDLC and agile delivery methodology.
• Experience working with databases and data, performing data cleanup, and/or data manipulation and migration to and from
• Ability to work independently and in a team environment.
• Ability to communicate effectively in English with all levels of staff, both orally and written.
• Ability to handle own work and multitask to meet tight deadlines without losing sight of priorities under minimum supervision.
• Highly motivated, self-directed individual with a positive & pro-active demeanor to work.
• Customer and service focused, with determination to meet their needs and expectations.
• Be driven and committed to the goals and objectives of the team and organization.

Education and Professional Skills

• Professional qualification or equivalent.
• BS/MS degree in Computer Science, Software Engineering or STEM degree (Desirable).
• Solid English reading/writing capability required.
• Good communication & articulation skills.
• Curious about new technologies and tools, creative thinking and initiative taking.
• Agile related certifications preferable.

Detailed Responsibilities

• Proficient in data discovery, data migration, data quality analysis, end to end data reconciliations by profiling the source systems using ETL /SQL (IICS /Matillion Preferable).
• Analyses the data quality of the sources and lists the data quality metrics of the source systems.
• Proficient in MDM and Customer data solutions.
• Involved in the Single Customer View and Customer 360 implementations.
• Proficient in the data migration strategies for large scale programs
• Develops and improves data governance and business data processes within the Technology and business organizations and understands client requirements, specifying and analyzing these to a sufficient level of detail to ensure transparency of definition and ability for technical teams to translate to a technical solution design.
• Works with developers, architects, and solution designers to translate sophisticated business requirements and provides feedback on technical solutions proposed.
• Responsible for building and maintaining a relationship with business collaborators and impacted users.
• Proactively identifies, recommends, and implements improvements to the process as it relates to assigned projects.
• Frequently keeps up to date with the latest industry development and technology innovations.
• Flexible in approach, adapting plans and strategies to help manage risks around ambiguity.
• Strategic problem solver with strong intuition for business and well-versed in current technological trends and business concepts.

LSEG Benefits

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

We are proud to be an equal opportunities employer. This means that we do not discriminate based on anyone's race, religion, color, 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.

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. You will be part of a collaborative and creative culture where we encourage new ideas and are committed to sustainability across our global business. You will experience the critical role we have in helping to re-engineer the financial ecosystem to support and drive sustainable economic growth. Together, we are aiming to achieve this growth by accelerating the just transition to net zero, enabling growth of the green economy and creating inclusive economic opportunity.

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

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.

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.

---