1. Home
  2. Jobs
  3. Jobs in Mumbai
  4. Data Analyst jobs in Mumbai
  5. Business MIS Executive / Analyst
Agent
Jobs
Applied
Tracker
Profile
    1. Jobs for you
    2. Job

    Job · 23397352

    LKP Securities logo

    Business MIS Executive / Analyst

    LKP Securities · Mumbai · onsite · Posted 11d ago

    Undisclosed2–7 yrsfulltimeSourced fromNaukri

    About a minute. You'll make an account on the way through.

    About this role

    Role & responsibilities

    Revenue Collation & Reporting

    • Collate revenue from all business lines: broking revenue, third-party distribution revenue (MF, insurance, bonds, etc.) and MTF income.
    • Calculate product-wise commission and revenue share accurately.
    • Reconcile revenue figures with Portal and other TPD vendor portal.

    MIS Preparation

    • Prepare and circulate daily, monthly and quarterly MIS for sales employees.
    • Publish overall zone-wise / branch-wise business MIS with daily updates.
    • Track daily numbers against every RM, dealer and client.
    • Analyse client-wise revenue, product penetration and activation.
    • Monitor MTF book, utilisation and related income.

    Incentives & Targets

    • Calculate sales incentives as per the companys sales policy.
    • Set up and track sales employee targets versus achievement.
    • Highlight gaps, top performers and under-performers to management.

    Management Reporting

    • Provide detailed MIS, dashboards and insights to the Business Head.
    • Prepare ad-hoc reports and analysis for business reviews and meetings.
    • Ensure data accuracy, timeliness and confidentiality.

    Preferred candidate profile


    • Graduate / Postgraduate in Commerce, Finance or a related field (MBA preferred).
    • 2-7 years of experience in MIS / business analytics, preferably in a broking or financial services firm.
    • Advanced Excel (Pivot Tables, VLOOKUP/XLOOKUP, Power Query, Macros); Power BI or SQL is a plus.
    • Good understanding of broking products, MTF, distribution products and brokerage structures.
    • Strong numerical, analytical and reconciliation skills.
    • High attention to detail and ability to meet daily deadlines.
    • Good communication skills to coordinate with sales, operations and finance teams.

    Sourced from naukri

    Skills

    CalculationRevenue CollationAdvanced ExcelManagement reportingAnalyticsData AnalyticsXLOOKUPtargetsPivot TableVLOOKUPreportingIncentivesMIS Preparation

    About LKP Securities

    LKP Securities logo

    LKP Securities

    Financial Services

    750

    employees

    1948

    78 years old

    Mumbai, Maharashtra

    India

    ₹7.9L PA avg

    Avg at LKP Securities

    About

    LKP Securities: India s top leading Stock Brokers, offers trading on BSE and NSE across Equity, Mutual Fund, Commodity Trading and Currency Derivatives.

    Industries

    Financial Services

    Employee ratings

    10 reviews

    4.0/ 5

    Culture

    3.7

    Career growth

    3.2

    Work-life

    4.1

    Employees rate it well for

    Work-Life Balance42Overall Company40

    Find them on

    WebsiteLinkedInAmbitionBox reviews

    See all 144 Data Analyst jobs in MumbaiData Analyst jobs in IndiaJobs in Mumbai

    Career guides

    • Can AI Apply to Jobs for Me? Yes - Here's What It Can and Can't Do (2026)
    • Resume keywords for software engineers in India (with examples by role)
    • ATS resume format for India: template, CTC and notice period rules (2026)

    All career guidesAll articlesBrowse companies hiring

    Business MIS Executive / Analyst · waiting for your command