Data Architect – 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 Architect. 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).
- Building Enterprise Data Architecture or Data Lake for the Migration projects
- 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 customers, 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
- 12 years of technical experience.
- 7 years of experience on data migration and reporting using ETL and Reporting Tools
- 5 years of experience on ETL/Database Development
- 2 years of experience on Salesforce Data Migration projects
- Expert level skill on Informatica IICS or Matillion or AWS Glue 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.
- Must have knowledge on the Salesforce Data modelling.
- Must have Experience on Snowflake Storage and Database.
- Expert level coding knowledge on Python to do ETL.
- Able to translate business requirements into data solutions.
- Understanding of Salesforce concepts.
- Snowflake development.
- Experience with providing technical solutions and supporting documentation.
Preferred Skills and Experience
- Experience of Tableau and/or Power BI reporting preferred for management reporting.
- Must have experience of working with Cloud Native based applications.
- 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 Salesforce.com.
- Should have experience with Enterprise Architect or Erwin Data modeler
- 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).
- 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.
- Domain expert in MDM and Customer data.
- Lead the Single Customer View and Customer 360 implementations.
- Lead the data migration strategies for large scale programs.
- Data mining to uncover patterns, anomalies, and correlations in large data sets.
- Data management to efficiently and cost-effectively collect, store, and use data.
- Coding languages like Python and Java to develop applications for data analysis.
- Machine learning to build scalable systems for handling Big Data Systems.
- Structured query language (SQL) to manipulate data.
- Data modelling tools like Erwin or Visio to visualize metadata and database schema.
- Creating and implementing data management processes and procedures
- Researching data acquisition opportunities.
- Developing application programming interfaces (APIs) to retrieve data.
- 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 a relationship with partners, collaborators and impacted users.
- Demonstrates proposed solutions and seeks and addresses feedback.
- Proactively identifies, recommends, and implements improvements to the process as it relates to assigned projects.
- Flexible in approach, adapting plans and strategies to help handle 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.
