Client Reporting Analyst

CES LIMITED.; Chennai District; On-site; INR 600,000 - 900,000; Full time

Job summary

A financial services company in Tamil Nadu seeks a Strategic Client Service Reporting Analyst to manage and validate client reports. This role involves ensuring the accuracy and timely delivery of reports while maintaining data integrity across various platforms. Candidates should have 3–5 years of experience in client reporting, strong Excel and SQL skills, and attention to detail. A collaborative approach in handling large datasets is essential.

Qualifications

• 3–5 years of experience in client reporting within asset management.
• Strong Excel skills including pivot tables and data validation.
• Working knowledge of SQL for data extraction.

Responsibilities

• Execute and validate recurring reporting for clients.
• Download and publish reports across multiple platforms.
• Review and reconcile data discrepancies.

Skills

Client reporting experience

Strong Excel skills

Knowledge of SQL

Attention to detail

Strong communication skills

Tools

Excel

SalesVision

VBA

Python

Job description

Job Summary

The Strategic Client Service Reporting Analyst will partner with TCW’s Strategic Client Service and Operations teams to execute recurring reporting, data validation, and reconciliation activities supporting all client types. This role will ensure accurate, timely delivery of performance, holdings, and compliance reports to clients and distribution platforms, while maintaining data integrity across multiple internal systems (e.g., SalesVision, Morningstar, Lipper, ICI, Schwab, Fidelity).

Key Responsibilities

• Execute and validate recurring daily, weekly, monthly, and quarterly client and intermediary reports (e.g., Fund Charges, Mutual Fund Flows, ETF Reports, Market Timing).
• Download, format, and publish reports such as SalesVision, Morningstar, Lipper, ICI, and third‑party distribution platforms (e.g., Schwab, Fidelity).
• Perform monthly SEC Yield updates and website performance reviews once published.
• Maintain and update templates, file structures, and trial balance files for reporting consistency.
• Review and reconcile data discrepancies across internal and external reports; elevate exceptions as needed.
• Manage data inputs and updates for various products, and dealer compliance reports.
• Partner with Communications, Data Engineering, and Accounting teams to ensure timely and accurate report delivery.
• Maintain documentation of reporting procedures and schedules; identify and implement process improvements.
• Assist with automation of recurring reporting tasks in collaboration with offshore and technology partners.
• Support ad‑hoc client reporting requests and internal performance reviews.

Required Skills & Experience

• 3–5 years of experience in client reporting, performance reporting, or investment operations within an asset management or financial services environment.
• Strong Excel skills, including pivot tables, lookups, and data validation.
• Working knowledge of SQL or similar query tools for basic data extraction and validation.
• Familiarity with fund accounting concepts, performance calculations, and SEC yield reporting.
• Experience managing recurring reporting schedules and handling large datasets with attention to detail.
• Strong organizational, analytical, and communication skills with a focus on accuracy and timeliness.

Preferred Skills

• Experience with institutional client reporting platforms (e.g., SalesVision).
• Prior exposure to UCITS or global fund reporting standards.
• Experience with VBA, Python, or other automation/scripting tools for report automation.
• Understanding of data governance and control frameworks.
• Ability to collaborate effectively with onshore and offshore teams across multiple time zones.