remote
Investment Data & Reporting Analyst - MetLife
Software Engineer
Analyst role focused on managing, validating, and reporting investment data for a multi‑asset portfolio, leveraging SQL, Python, and Excel to deliver accurate insights and support risk‑managed decision making.
About the role
Key Responsibilities
- Extract, cleanse, and validate investment data from internal systems and external vendors (e.g., Bloomberg, FactSet).
- Develop and maintain automated reporting solutions using SQL queries, Python scripts, and Excel macros.
- Produce regular and ad‑hoc performance, risk, and attribution reports for fixed income, equities, private credit, and real‑estate portfolios.
- Collaborate with portfolio managers, risk analysts, and technology teams to ensure data integrity and alignment with investment strategies.
- Identify process improvement opportunities and implement data‑quality controls to enhance reporting efficiency.
Requirements
- Bachelor's degree in Finance, Economics, Computer Science, or related field; 2+ years of experience in investment data management or financial reporting.
- Proficiency in SQL and Python for data extraction, transformation, and automation.
- Advanced Excel skills, including pivot tables, VBA/macros, and complex formulas.
- Experience with data‑visualization tools (e.g., Tableau, Power BI) and familiarity with market data providers.
- Strong analytical mindset, attention to detail, and ability to communicate findings to both technical and non‑technical stakeholders.