Data Analyst

Job Responsibilties

• Knowledge of TPP industry– MF, PMS / AIF, Unlisted, LI, Bonds, etc.
• Data Reporting of TPP– MF, PMS / AIF, Unlisted, LI, Bonds, etc.
• Income reconciliation, AUM validation
• Raising invoice for PMS AIF
• Following up with AMCs for Brokerage, transaction and AUM related concerns
• KRA incentive validation
• Automate processes and publish dashboards Python, Excel reports, VBA Macros.
• Collaborate with business units to gather reporting requirements and translate them into technical solutions.
• Maintain documentation for all developed solutions and support end-user training.
• Ensure data integrity, security, and compliance with internal and external regulations.

Education & Experience

• Postgraduate with overall experience of 8-10 years
• Experience in TPP, BI, data reporting

Technical Skills

• Advanced Excel, VBA Macros,
• Proficient in Python – (NumPy, Pandas), and SQL
• Familiarity with Power BI

Soft Skills:

• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.
• Ability to work independently and manage multiple tasks with tight deadlines