Data Analyst

Job Description: Data Analyst Single Family Office (Mumbai)

Experience Required : Prior experience in managing wealth management software is mandatory

Role Overview

We are seeking a detail-oriented Data Analyst to support a Single-Family Office in Mumbai. The role involves managing, onboarding, and maintaining high-quality investment and accounting data across multiple asset classes and platforms. Candidates with hands-on experience in wealth management software (especially Asset Vantage and MProfit) will be preferred.

Key Responsibilities

Data Onboarding & Maintenance

• Assist the family office in onboarding investment and accounting data across all investment vehicles (initial setup and ongoing updates).
• Ensure accurate mapping and classification of all transactions across equities, mutual funds, bonds, PMS, AIFs, private equity, and global assets.

Data Feeds & Cleansing

• Understand and work with various types of data feeds received from custodians, brokers, PMS/AIF managers, and banks (India & overseas including US).
• Identify appropriate data sources, cleanse and standardize data to meet platform requirements.
• Investment & Accounting Understanding
• Develop strong working knowledge of investment management and investment accounting concepts.
• Learn and understand different investment structures and transactional flows across domestic and offshore jurisdictions.

Review & Coordination

• Coordinate periodic data sanity checks and review sessions with the team to ensure database accuracy.
• Collaborate with wealth managers, AMCs, custodians, and internal teams to resolve data-related issues.
• Issue Tracking & System Improvements
• Identify system issues, bugs, and mismatches in data; document them and track resolution with the technology partner.

Reporting & Presentation

• Prepare dashboards, visual reports, and presentations summarizing portfolio insights and data trends for management review.
• Build automated reports and reusable templates.

Technical Skills

• Strong Excel skills including VBA macros, advanced formulas, pivot tables, and data automation.
• Ability to prepare high-quality presentations and explain data insights clearly.
• Process implementation & management capability.
• Highly proactive and detail-focused approach.
• Ability to understand and explain complex investment and system-related concepts.
• Problem-solving mindset with the ability to identify issues and execute effective solutions.
• Capability to streamline processes and strong willingness to learn and grow.

Experience

• 25 years of relevant experience in wealth management data operations.
• Mandatory: Experience with wealth management software.
• Preferred: Hands-on experience with Asset Vantage or MProfit.

Qualifications

• Graduate/PostgraduateMCom or relevant specialization preferred.
• Familiarity with investment accounting, performance reporting, and portfolio analytics.

Location - Mumbai