Associate Data Research Analyst

Morningstar
Madrid, Spain
3 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience required
2 years minimum
Compensation
€29,000.0 - €39,000.0
Working hours
Regular working hours
Job source

Tech stack

Microsoft Excel Business Analytics Applications Databases Data Governance Extract Transform Load (ETL) Data Mining SQL Databases Data Delivery

Job description

As an Associate Data Analyst within Morningstar’s Performance & Portfolio Operations team, you will play a pivotal role in ensuring the accuracy, completeness, and timeliness of investment performance data and portfolio information. You will work cross-functionally with data research teams, operations, and client service groups to maintain high data quality standards for thousands of funds and portfolios globally., * Analyze performance calculations and methodologies to ensure compliance with industry standards.

  • Manage escalations and troubleshoot data anomalies in collaboration with data providers and internal teams.
  • Develop and maintain automated validations, reports, and analytical tools to improve data workflows.
  • Partner with IT and database teams to optimize data extraction, transformation, and loading (ETL) processes.
  • Provide mentorship and guidance to junior analysts and contribute to team knowledge sharing and training.
  • Support month-end and quarter-end close cycles for performance data delivery and audit processes.
  • Collaborate with product managers and client-facing teams to ensure timely communication around data issues and enhancements.
  • Participate in continuous process improvement initiatives using methodologies like Lean Six Sigma.

Requirements

Do you have experience in SQL?, * 2+ years of experience in financial data analysis, preferably within mutual funds, ETFs, or portfolio operations.

  • Proficiency in SQL and Excel for data querying, transformation, and analysis.
  • Understanding of portfolio performance concepts (time-weighted returns, money-weighted returns), NAV, and dividend mechanics.
  • Experience with data quality frameworks, anomaly detection, and root cause analysis.
  • Knowledge of investment fund structures, pricing policies, and regulatory reporting requirements.
  • Good communication skills, with the ability to translate complex data issues for non-technical stakeholders.
  • Detail-oriented with strong analytical and problem-solving capabilities.

About the company

Morningstar is a leading global provider of independent investment insights, serving both individual and institutional investors across public and private markets. Our offerings include a wide range of data, research, and investment management services, with $300+ billion in assets under management. Operating in 32 countries, Morningstar supports financial advisors, asset managers, retirement plan providers, and more with comprehensive investment solutions.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

2:31 min

Data mining literary works for language patterns

Jen Looper Jen Looper · Europe 2026 Virtual

1:14 min

Evolution of distributed SQL database architectures

Wei Hu Wei Hu · WWC 2024

1:42 min

Combining technical skills with strong business communication

Lukas Kölbl · LIVE

1:52 min

Evolution of distributed SQL database management systems

Akmal Chaudhri Akmal Chaudhri · LIVE

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · WWC 2022

Videos

See all

Related articles

See all