Investment Recordkeeping & MIS Executive | Family Office, SandMartin

About the Role:

Family Office

long-term career

Key Responsibilities:

Investment Recordkeeping & Data Management

• Record all

  buy and sell transactions

  across Shares, Mutual Funds, PMS, AIFs, Bonds, Commodities, and Currency Derivatives.
• Maintain and update detailed records in

  advanced Excel

  using formulas and functions such as

  VLOOKUP, HLOOKUP, Pivot Tables, and Macros

  .
• Update transaction data on

  MoneyControl, Value Research, MProfit, and Morningstar

  for real-time tracking.
• Maintain

  digital and physical dockets

  for each transaction (including contract notes, payment proofs, and correspondence).

Portfolio Tracking & Index Regulation

• Track and regulate

  indices of Stocks, Bullion, Commodities, and related benchmarks

  to monitor performance.
• Analyze market trends and ensure timely valuation updates across all investment classes.
  
• Support the Family Office team in preparing

  performance dashboards and portfolio analytics

  .

Reporting & Compliance

• Prepare

  daily, weekly, and monthly MIS reports

  , covering realized/unrealized gains, capital deployed, and asset allocation.
• Track and classify

  Short-Term and Long-Term Capital Gains

  for all transactions.
• Ensure data accuracy and readiness for

  audit and tax compliance

  .
• Assist in reconciliations between Excel records, PMS/AIF statements, and bank accounts.
  

Technology & AI Integration

• Use or learn

  AI-based investment tracking and analytics tools

  to enhance efficiency and insight generation.
• Automate recurring reporting processes to improve data accuracy and timeliness.
  

Required Skills & Competencies:

• Advanced MS Excel

  (VLOOKUP, HLOOKUP, Pivot Tables, Macros, and Automation).
• Experience with

  MoneyControl, Value Research, MProfit, and Morningstar

  .
• Knowledge of

  financial instruments and market operations

  .
• Understanding of

  capital gains computation and investment accounting

  .
• Strong analytical mindset with attention to detail.
  
• Integrity, confidentiality, and commitment to long-term growth.
  

Qualifications & Experience:

• Education:

  B.Com / M.Com / MBA (Finance) / CA (Inter) or equivalent.

• Experience:

  2–4 years in investment recordkeeping, accounting, or family office operations.
• Preference for candidates

  willing to make a long-term commitment

  and adopt

  AI-driven tools

  .

Location:

Noida / Delhi NCR

Employment Type:

Full-Time | Permanent