Management Information Systems Specialist

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 SummaryMIS 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 strong)