Data Analyst

Intellectual Capital HR Consulting Pvt. Ltd.; Hyderabad; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Intellectual Capital HR Consulting Pvt. Ltd. is seeking a detail-oriented Data Analyst to support a Single Family Office in Mumbai.

You will onboard and maintain investment and accounting data across multiple asset classes, ensuring accurate mapping and classification of all transactions. The role prefers hands-on experience with wealth management software such as Asset Vantage or MProfit, and requires 2–5 years in wealth data operations, with a focus on data quality, feeds, cleansing, and

Qualifications

• 2–5 years of wealth management data operations experience.
• Mandatory: experience with wealth management software.
• Preferred: hands-on experience with Asset Vantage or MProfit.
• Graduate or postgraduate in commerce preferred.

Responsibilities

• Onboard and maintain investment and accounting data across asset classes.
• Map and classify transactions across equities, mutual funds, PMS, AIFs, PE, and offshore assets.
• Work with data feeds from custodians, brokers, PMS/AIF managers, and banks (US included).
• Coordinate data sanity checks and resolve data issues with stakeholders.
• Prepare dashboards and presentations summarizing portfolio data.

Skills

Excel VBA macros

Pivot tables

Advanced formulas

Data automation

Presentation skills

Problem-solving

Education

Graduate or Postgraduate in Commerce (MCom preferred)

Tools

Asset Vantage

MProfit

Job description

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

• 2–5 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/Postgraduate—MCom or relevant specialization preferred.
• Familiarity with investment accounting, performance reporting, and portfolio analytics.

Location - Mumbai