SQL Analyst

MEX001 Refinitiv de Mexico SA de CV

Ciudad de México

Hybride

MXN 1 106 000 - 1 660 000

Plein temps

Il y a 4 jours
Soyez parmi les premiers à postuler

Obtenez une réponse de cet employeur

Votre CV et votre lettre de motivation, adaptés exactement à ce que l’employeur recherche.

Passez les filtres ATS

Avantages offerts par ce poste

26 weeks' parental leave
Healthcare
Retirement planning
Wellness allowance
Volunteering days

Résumé du poste

London Stock Exchange Group's Data Analytics team is seeking a Senior Associate Factor Analyst to develop and supervise derived data, including price-earnings-like metrics, for index-building and client reporting. You will partner with Research and Technology to specify requirements, document methodologies, test data accuracy and deliver high-quality analytics across multiple regions.

This role offers a clear development path, flexible working and comprehensive benefits as part of a global

Qualifications

  • Strong understanding of accounting principles and valuation analyses.
  • Experience with market data, corporate actions, currency changes and market identifiers.
  • Solid data management knowledge with 3–5 years experience supervising data from vendors.
  • Proficiency in MS Office, SQL, and basic data visualization.

Responsabilités

  • Create and maintain high-quality fundamental factors.
  • Document methodologies with Research and clients.
  • Collaborate with Technology on analytics implementation.
  • Test data derivations for calculation accuracy.
  • Wrangle data from internal and external sources into standardized models.
  • Ensure quality control of raw and derived data.
  • Produce data visualizations and quality reports for management.

Connaissances

Accounting principles
Market data
Data management
SQL
MS Office
Interpersonal communication
Team collaboration
Degree level educated

Formation

Bachelor's degree or equivalent

Outils

SQL

Description du poste

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.

LSEG (London Stock Exchange Group) 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 culture of connecting, creating opportunity and delivering excellence shapes how we think, how we do things and how we help our people fulfil their potential. Our Data & Analytics, Capital Markets and Post Trade divisions have a combined power that provides a comprehensive, integrated suite of trusted financial market infrastructure services to help our customers pursue their ambitions. Explore our divisions LSEG is headquartered in the United Kingdom, with significant operations in 70 countries across Europe, the Middle East, Africa, North America, Latin America and Asia Pacific.

Find out more Get to know some of our people who are pushing the boundaries of technology, finance and more around the world.

Obtenez votre examen gratuit et confidentiel de votre CV.

ou faites glisser et déposez votre fichier ici.

Similar jobs

Postes similaires à comparer

Index Review Analyst
Index Review Analyst

MEX001 Refinitiv de Mexico SA de CV • Ciudad de México

Sur place
MXN 600 000 - 900 000
Parental leave
Healthcare
Retirement planning
+1
Senior Fixed Income Analyst
Senior Fixed Income Analyst

MEX001 Refinitiv de Mexico SA de CV • Ciudad de México

Sur place
MXN 600 000 - 1 100 000
26 weeks' parental leave
Healthcare
Retirement planning
+2
Index Management - Team Lead
Index Management - Team Lead

MEX001 Refinitiv de Mexico SA de CV • Ciudad de México

Sur place
MXN 2 213 000 - 3 504 000
26 weeks parental leave
Healthcare
Retirement planning
+2
Factor Analyst - Data Analytics & SQL Specialist
Factor Analyst - Data Analytics & SQL Specialist

MEX001 Refinitiv de Mexico SA de CV • Ciudad de México

Hybride
MXN 1 106 000 - 1 660 000
26 weeks' parental leave
Healthcare
Retirement planning
+2
Associate Data Analyst: Insights, AI & Dashboards
Associate Data Analyst: Insights, AI & Dashboards

Euromonitor • Ciudad de México

Hybride
MXN 420 000 - 600 000
Senior Data Analyst - Foundational Data & Insights
Senior Data Analyst - Foundational Data & Insights

Euromonitor • Ciudad de México

Sur place
MXN 600 000 - 780 000
Healthcare insurance
Flexible hours
Volunteer days
+1
Platform Support Analyst
Platform Support Analyst

SimCorp • Mexique

Hybride
MXN 400 000 - 700 000
Hybrid work model
Bonus scheme
Pension
+1
Associate Director, Engineering & Quality
Associate Director, Engineering & Quality

HopHR • Nuevo León

Hybride
MXN 1 205 026 - 1 549 320
Work-Life Balance
Continuous Learning Opportunities
Comprehensive Healthcare
+2
Client Services Associate
Client Services Associate

S&P Global Inc. • Ciudad de México

Hybride
MXN 300 000 - 380 000
Health & Wellness
Flexible Downtime
Continuous Learning
+3
Senior Associate, Americas Corporate Action
Senior Associate, Americas Corporate Action

S&P Global Inc. • Ciudad de México

Hybride
MXN 900 000 - 1 300 000
Health & Wellness
Flexible Downtime
Continuous Learning
+3