Data Analyst

Intellectual Capital HR Consulting Pvt. Ltd.; Surat; Presencial; INR 600 000 - 1 000 000; Tempo integral

Resumo da oferta

Intellectual Capital HR Consulting Pvt. Ltd. in Mumbai seeks a detail-oriented Data Analyst to support a Single Family Office by onboarding and maintaining high-quality investment and accounting data across asset classes.

Familiarity with wealth management software such as Asset Vantage or MProfit is preferred. This role requires strong Excel skills (VBA, formulas, pivot tables), data cleansing, and the ability to present insights through dashboards and presentations.

Qualificações

• 2–5 years of wealth-management data operations experience.
• Experience with wealth management software is mandatory.
• Onboarding and data maintenance across multiple asset classes and platforms.

Responsabilidades

• Assist onboarding of investment and accounting data across all investment vehicles and ensure initial setup and ongoing updates.
• Map and classify transactions across equities, mutual funds, bonds, PMS, AIFs, private equity, and global assets.
• Work with various data feeds from custodians, brokers, PMS/AIF managers, and banks (India & overseas).
• Cleans data to meet platform requirements and develop understanding of investment accounting concepts.
• Coordinate data sanity checks and review sessions with the team, resolving data issues with partners.
• Prepare dashboards and visual reports summarizing portfolio insights for management.

Conhecimentos

Excel

VBA

Pivot tables

Data automation

Presentation skills

Problem solving

Data onboarding

Formação académica

Graduate/Postgraduate—MCom or relevant specialization

Ferramentas

Asset Vantage

MProfit

Descrição da oferta de emprego

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