SQL Analyst

LSEG•Charlotte, NC

18h

About The Position

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

Requirements

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

Responsibilities

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
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
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.
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.)