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.
** 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:
** Senior 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…