Discover your dream Career
For Recruiters

SQL Analyst

London Stock Exchange Group Mexico City, Mexico
Posted 2 hours ago Permanent Competitive

SQL Analyst

London Stock Exchange Group Mexico City, Mexico
Role Summary :
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

Role Responsibilities:

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

LSEG unlocks the power of markets to create opportunities across the global economy.

Through our connected network of market infrastructure, data and analytics, we help customers access capital, manage risk and make confident decisions.

Our insights bring clarity to complex markets, and our trusted services ensure resilience and stability. With deep expertise and global scale, we partner with customers to drive innovation and shape the future of finance.

Few organisations operate at the scale, complexity and reach of LSEG. Here, you'll work alongside experts, be inspired to deliver your best work and help shape what's next for our business and the global economy.

Guided by our values of Integrity, Partnership, Excellence and Change, we bring together diverse perspectives, encourage fresh thinking, and create an environment where learning never stops.

Join more than 26,000 colleagues across 60 countries, supporting customers in over 170 countries. Alongside flexible ways of working, you'll have access to benefits that support your wellbeing and your future, including 26 weeks' parental leave, healthcare, retirement planning and a wellness allowance. Through the LSEG Foundation and two paid volunteering days each year, you'll also have opportunities to get involved in your local community and support causes that matter to you.

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 .

By clicking on "Apply", the process for submitting an application will begin. If you have any questions prior to clicking "Apply", please contact the recruiter.

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.

LSEG. Make more possible.
Job ID  R0125401
More Jobs From London Stock Exchange Group
London Stock Exchange Group
Senior Fixed Income Analyst
London Stock Exchange Group
Mexico City, Mexico
2 hours ago Full time Competitive
London Stock Exchange Group
Index Management - Team Lead
London Stock Exchange Group
Mexico City, Mexico
2 hours ago Full time Competitive
London Stock Exchange Group
Index Review Analyst
London Stock Exchange Group
Mexico City, Mexico
2 hours ago Full time Competitive
London Stock Exchange Group
Sales Specialist, Distribution - FTSE Russell
London Stock Exchange Group
London, United Kingdom
2 days ago Full time Competitive
London Stock Exchange Group
Index Analyst
London Stock Exchange Group
Bangalore, India
2 hours ago Full time Competitive
London Stock Exchange Group
Senior Content Specialist
London Stock Exchange Group
Bangalore, India
1 day ago Full time Competitive
London Stock Exchange Group
Senior Market Data Compliance Manager
London Stock Exchange Group
London, United Kingdom
4 days ago Full time Competitive
London Stock Exchange Group
Fixed Income Index Analyst
London Stock Exchange Group
Exeter, United Kingdom
3 days ago Full time Competitive
London Stock Exchange Group
Content Infrastructure Owner -Estimates
London Stock Exchange Group
Bangalore, India
3 days ago Full time Competitive
London Stock Exchange Group
Fixed Income Quantitative Specialist
London Stock Exchange Group
New York, United States
3 days ago Full time Competitive

Boost your career

Find thousands of job opportunities by signing up to eFinancialCareers today.
More Jobs Like This
London Stock Exchange Group
Senior Fixed Income Analyst
London Stock Exchange Group
Mexico City, Mexico
London Stock Exchange Group
Index Management - Team Lead
London Stock Exchange Group
Mexico City, Mexico
London Stock Exchange Group
Index Review Analyst
London Stock Exchange Group
Mexico City, Mexico
Data Analyst Senior - Power BI / SQL - (H/F)
Open Sas
Villeurbanne, France
American Express
Senior Analyst-Control Management (SQL, Python)
American Express
Gurgaon, India