Company Description Purshottam Investofin Ltd is a New Delhi based company operating in the financial services sector. The organization focuses on delivering investment and financial solutions. As a growing company, it offers opportunities to work with structured data, reporting, and analytics that support decision-making. Team members can expect a professional environment that values accuracy, accountability, and clear communication. The company encourages the use of technology and information systems to improve operational efficiency.

Job Summary

MIS Executive — Reconciliation & Reporting (Trading Operations)

Experience: 3–5 years

About the Role

We're building the reporting and control backbone for a multi-trader financial operation. This role sits at the center of it: you'll own the daily reconciliation between trade instructions, execution records, and settlement/accounts data, and turn that into clean MIS that leadership can act on — accurate individual performance reporting, exception tracking, and cost/P&L; attribution.

This is not a dashboard-decoration job. The core of the role is catching where records *don't* agree, understanding why, and making sure the numbers that reach leadership are ones you'd stake your name on.

What You'll Do

- Reconcile trade/transaction data across multiple independent sources (internal logs, execution records, and external contract notes/statements) on a daily and weekly cadence

- Build and maintain the exception-reporting process — identifying mismatches, categorizing them, and escalating the ones that matter

- Design and maintain MIS reports and dashboards (daily/weekly/monthly) for leadership, including individual-level performance and P&L; reporting

- Apply cost, holding-cost,



and tax-adjustment logic consistently across reports so that gross numbers and true net numbers are both available and clearly distinguished

- Automate recurring reporting workflows to reduce manual effort and turnaround time, using Excel/Power Query/VBA, Power BI, SQL, or scripting/AI tools as appropriate

- Maintain data validation discipline — no report goes out with an unresolved discrepancy silently baked in

- Work directly with a small operations/execution team and with senior leadership; this role reports independently of the execution function it reconciles against

Must-Have Skills & Experience

- 3–5 years in an MIS, reconciliation, data analysis, or reporting role

- Advanced Excel (Pivot Tables, XLOOKUP/INDEX-MATCH, Power Query, conditional formatting, data validation) — genuinely advanced, not just familiar

- Demonstrated experience reconciling data across multiple sources/systems and identifying discrepancies independently

- Comfort building and maintaining recurring reports and dashboards (Power BI, Google Sheets, or equivalent)

- Strong attention to detail and a track record of being the person who catches the error before it goes out the door

- Clear written and verbal communication — able to explain a discrepancy or a number to a non-technical stakeholder concisely

Good to Have

- Prior exposure to financial/transactional data reconciliation (banking, NBFC, broking, payments, fintech, or similar)

- Working knowledge of SQL (joins, aggregations) and/or Python for data handling

- VBA or Power Query-based automation experience

- Hands-on use of AI tools (ChatGPT, Claude, Copilot, etc.) for reporting, scripting, or workflow automation — we're building toward AI-assisted automation of this function and want someone who can grow into that

- Experience with stock market / F&O; / trading operations specifically (not required — we'll train the domain if the reconciliation instinct is solid)

📌 Management Information Systems Specialist (Delhi)
🏢 Purshottam Investofin
📍 Delhi