SQL Analyst

Data Analytics is part of the Index Data Management group of Benchmark & Index Management within the FTSE Russell business. The Data Analytics team is a customer focused, technology enabled team, producing outstanding analytics and data derivations that drive insight and value for our partners. The team is responsible for crafting LSEG Intellectual Property by generating derived fundamental data content and similar content based on data standardization from raw data.

We are recruiting for a Factor Analyst, reporting to a Manager within the Data Analytics team. The Analyst will quickly develop the skills to work with key partners to develop, maintain and supervise derived data (e.g. Price earnings ratio). The candidate will be responsible for the timely, efficient and accurate review of derived data at all index review periods and will work with team members on data projects to improve and optimize our ways of work.

The position offers a clear development path and presents exciting opportunities in a challenging and multifaceted environment. The role provides an opportunity for the candidate to consolidate and further develop their financial, analytical and data and database knowledge and project management skills, working with colleagues across functional teams to complete projects and deliver content on time and to the highest possible standard.

Department Description – Index Data Management

Team Description – Data Analytics - Equities

Creation and Maintenance of High Quality Fundamental Factors

Create & document methodologies behind analytics in conjunction with Research and external clients

Specify requirements and collaborate closely with Technology on implementation of analytics!

Test output of data derivations ensuring Accuracy of calculations

Wrangle data from internal & external sources into standardized data models.

Create and supervise quality control checks on raw & derived data.

Ensuring high quality, complete derived data content is created and provided for use in index builds and other products

Respond to client questions in an efficient and timely manner, providing root cause and action plans where vital to prevent future reoccurrence of issues.

Assisting in the production of regular reports and in new product development in data and technology segments to support index and analytics

Communication

Produce data visualizations and data quality reports to management and partners

Clear documentation of technical requirements around analytics to ensure smooth implementation in partnership with technology CORPORATE

Deliver clear and accurate analysis to facilitate partner discussions

Build trust with partners by consistently understanding and fulfilling partner requests in an accurate, timely and professional manner.

Key Behaviors

Continuously adopt a pragmatic, flexible and responsive approach.

Create robust and repeatable processes to continuously deliver high quality output.

Suggest change and innovation to enhance current methods of working.

Working with teams in multiple locations simultaneously, in an iterative and collaborative manner

Maintain constructive and supportive working relationships with partners across the group

Demonstrate and practice adherence to LSEG internal controls and standards in data management, and document management and production (e.g. keeping appropriate records, following LSEG processes and using mandated tools, etc.)

Key Skills

Excellent understanding of accounting principles, and fundamental and valuation analysis

Proven experience with market data, including procedures of corporate action treatments, currency changes & common market identifiers.

Solid grasp of data management theories with 3-5 years practical experience, including managing and supervising data from common third-party vendors

Excellent digital literacy, including sophisticated knowledge of the MS Office suite of products, Database querying language (SQL) and a willingness and skill to learn new tools quickly.

Customer focused with a good understanding of typical workflows within Investment Managers

Excellent interpersonal and communication skills; proven ability to work within a team.

Educated to degree level or equivalent

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.