MIS Executive

Position: MIS Executive

Experience: 1–2 Years

Industry: Finance / Banking / NBFC

Employment Type: Full-Time

Job Summary

We are looking for a detail-oriented MIS Executive to manage reporting, data analysis, and business information. The ideal candidate should have a Commerce/Finance background with strong Excel and coordination skills.

Key Responsibilities

·        Prepare and maintain daily, weekly, and monthly MIS reports.

·        Collect, analyze, and validate business data.

·        Maintain Excel-based reports and dashboards.

·        Perform data reconciliation and identify discrepancies.

·        Coordinate with internal teams for timely data collection.

·        Provide accurate reports and insights to management.

·        Maintain proper records and documentation.

Requirements

·        Graduate, preferably B.Com / Finance / Commerce.

·        1–2 years of relevant experience in Finance, Banking, or NBFC.

·        Good knowledge of MS Excel and basic accounting.

·        Understanding of banking/financial products.

·        Strong communication, coordination, and analytical skills.

·        High attention to detail and ability to meet deadlines.

To Apply

HR Swati

Position : Executive / Sr. Executive / Assistant Manager – MIS & Reconciliation

Industry : Fintech

Job Location : Gurgaon

Experience :

• Executive / Sr. Executive : 3–6 Years
• Assistant Manager : 5–8 Years

Role Overview :

We are looking for a detail-oriented and analytical MIS & Reconciliation professional to manage management reporting, account reconciliations, data validation, and periodic MIS activities.

The role will be responsible for preparing accurate and timely MIS reports, identifying and resolving reconciliation discrepancies, maintaining data integrity, and coordinating with cross-functional teams. The position will also contribute to process improvement and reporting automation initiatives.

Mandatory Skills :

MIS Reporting, Account Reconciliation, Advanced Excel (VLOOKUP, HLOOKUP, XLOOKUP, Pivot Tables, COUNTIF/COUNTIFS, SUMIF/SUMIFS), Data Analysis, Data Validation, Financial Reporting, and Discrepancy Resolution.

Key Responsibilities :

• Collect, consolidate, validate, and analyze data from multiple sources for MIS reporting.
• Prepare and circulate daily, weekly, monthly, and periodic MIS reports for management review.
• Perform account, transaction, and ledger reconciliations and investigate discrepancies.
• Identify data mismatches, exceptions, and reconciliation breaks and ensure timely resolution.
• Maintain high standards of data accuracy, completeness, and integrity across reporting activities.
• Coordinate with Finance, Operations, Business, and other internal teams to collect and validate required information.
• Maintain and update MIS dashboards, trackers, and reporting formats as required.
• Support audit requirements by preparing relevant reports, reconciliations, schedules, and supporting documentation.
• Ensure adherence to defined reporting processes, controls, and timelines.
• Identify opportunities to improve reporting processes and reduce manual efforts through automation and standardization.
• Assist in developing and maintaining automated MIS reports using advanced Excel and other relevant tools.
• Track key operational and financial metrics and highlight significant variances or exceptions to management.
• Maintain proper documentation of reports, reconciliation workings, processes, and controls.

Key Performance Indicators / Success Criteria :

• Accuracy and timely submission of MIS reports.
• Timely completion and accuracy of account/transaction reconciliations.
• Effective identification and resolution of discrepancies and exceptions.
• Data integrity and adherence to reporting standards.
• Quality of coordination with cross-functional stakeholders.
• Reduction in manual reporting efforts through process improvement and automation.
• Timely support for audits and management reporting requirements.

Mandatory Skills :

Advanced Excel

Strong hands-on experience with Microsoft Excel, including :

• VLOOKUP / HLOOKUP
• XLOOKUP
• COUNTIF / COUNTIFS
• SUMIF / SUMIFS
• Pivot Tables
• Conditional Formatting
• Data Validation
• IF / Nested IF
• INDEX-MATCH
• Data cleaning and consolidation
• Large-data-set handling and analysis

MIS & Reconciliation

• Strong experience in MIS preparation and management reporting.
• Hands-on experience in account / transaction / ledger reconciliation.
• Ability to identify, analyze, and resolve data discrepancies.
• Good understanding of data validation and reporting controls.

Preferred / Additional Skills :

• Basic knowledge of Macros / VBA.
• Experience with Tally ERP 9 or similar accounting/ERP tools.
• Basic understanding of accounting principles and financial transactions.
• Exposure to reporting automation and process improvement.
• Experience working with large volumes of financial or transactional data.
• Good analytical and problem-solving skills.
• Strong communication and stakeholder coordination skills.

Educational Qualification :

Minimum Qualification :

• Bachelor's degree in B.A. / B.Com or equivalent.

Preferred Qualification :

• B.Com
• B.A.
• MBA – Finance / Accounting

Ideal Candidate Profile :

The ideal candidate should have strong hands-on experience in MIS reporting, reconciliation, Excel-based data analysis, and management reporting, preferably within the Fintech, BFSI, financial services, payments, or transaction-driven environment.

The candidate should be highly detail-oriented, comfortable working with large datasets, capable of independently identifying discrepancies, and proactive in improving reporting and reconciliation processes.

Key Responsibilities

• Collect, consolidate and manage data from various internal systems, SaaS platforms, CRM/ERP modules, logs, and databases.
• Generate daily, weekly, monthly, and ad-hoc MIS reports and dashboards for operations, sales, finance, customer-support or other relevant teams.
• Use advanced Excel to build, maintain, and manage complex spreadsheets — including pivot tables, VLOOKUP / HLOOKUP / INDEX-MATCH, SUMIF/COUNTIF, conditional formatting, charts/graphs, macros/VBA (if needed) to automate routine reporting tasks.
• Validate and clean data — ensure data integrity, consistency; identify and rectify discrepancies or anomalies.
• Collaborate with cross-functional teams (product, operations, support, finance, sales) to understand their data/reporting needs and deliver appropriate reports/insights.
• Provide ad-hoc data analysis or custom reporting as required by management or US stakeholders.
• Maintain documentation of reporting processes, data definitions/SOPs, report templates, and standard workflows.
• Ensure timely delivery of reports — especially considering night-shift schedule — so that US-based stakeholders receive data at start of their business day.
• Identify opportunities for process improvement and automation to make MIS reporting more efficient and reliable.

Required Skills & Qualifications

• Bachelor’s degree (in IT, Computer Science, Business, Statistics, or related field) or equivalent.

• Strong proficiency in Microsoft Excel — including advanced formulas/functions (VLOOKUP/HLOOKUP/INDEX-MATCH), pivot tables, charts/graphs, conditional formatting, data cleaning, data validation.
• Ability to build and maintain dashboards/reports; comfortable using Excel for recurring and ad-hoc reports.
• Strong analytical and problem-solving skills; ability to work with large datasets, identify trends, anomalies, and draw insights.
• Good communication skills — ability to coordinate with different teams/stakeholders, understand requirements, and present data/insights clearly.
• Readiness for night-shift work from office; ability to work independently, meet deadlines and manage time effectively.

We are looking for a Lead – Information Systems who can combine strong Salesforce/CRM expertise, advanced Excel skills, MIS reporting and business analytics to support data-driven decision-making.

🔹 What We’re Looking For

• Minimum 4 years of hands-on experience with CRM systems, preferably Salesforce

• Minimum 3 years of practical Salesforce experience preferred

• Advanced proficiency in Microsoft Excel, including:

Advanced formulas, Pivot Tables, Power Query, Data analysis, Automation

• Strong experience in MIS reporting, data validation, analysis and presentation of insights

• Proven experience creating and maintaining dashboards, KPI reports and management reports

• Good technical aptitude with the ability to understand business processes and convert them into effective reporting solutions

• Basic to intermediate understanding of finance and business metrics, including revenue, costs, budgeting and financial reporting concepts

• Strong analytical and problem-solving skills

• Excellent stakeholder management and communication skills

• Ability to work independently and convert data into actionable business insights

🔹 Key Responsibilities

• Manage and analyze data from Salesforce/CRM and other business systems

• Develop and maintain MIS reports, dashboards and KPI trackers

• Ensure data accuracy, validation and consistency across reports

• Analyze business data and identify trends, gaps and opportunities

• Translate business requirements into meaningful reports and dashboards

• Work closely with business and functional stakeholders to understand reporting requirements

• Support management with timely and accurate business insights and performance reports

• Identify opportunities to improve reporting processes through Excel, Power Query and automation

• Support CRM-related reporting and process improvements

🎯 Ideal Candidate

Someone who is comfortable working at the intersection of CRM + MIS + Excel + Business Analytics, and can go beyond preparing reports to explain what the data means and what action the business should take.

Job Title: Corporate Quality MIS Analyst – Automotive / Wiring Harness

Location: Goregaon East

Experience: 3–7 Years

Industry: Automotive / Auto Components / Wiring Harness

Role Type: Corporate HO-Based

Job Summary

We are looking for a Corporate Quality MIS Analyst with 3–7 years of experience in the Automotive, Wiring Harness, or Auto Components industry. The candidate will be responsible for consolidating quality data from multiple plants, analysing Quality KPIs, preparing MIS reports and dashboards, and providing management-level insights for quality improvement.

Key Responsibilities

Consolidate plant-wise Quality MIS, KPIs, and performance reports.

Analyse PPM, rejection, rework, FPY, customer complaints, CAPA, and 8D data.

Prepare quality MIS reports, dashboards, trend analysis, and management presentations.

Coordinate with Plant Quality Teams to ensure timely and accurate data submission.

Identify quality trends, deviations, recurring issues, and improvement opportunities.

Maintain standardized Corporate Quality MIS formats, databases, and reporting systems.

Support management reviews with accurate quality data and analytical insights.

Track plant-wise quality performance and highlight gaps against defined targets.

Key Requirements

3–7 years of experience in Quality MIS / Quality Reporting within Automotive, Wiring Harness, or Auto Components.

Strong understanding of Quality KPIs, MIS reporting, and data analysis.

Advanced proficiency in MS Excel, including Pivot Tables, VLOOKUP/XLOOKUP, and dashboards.

Good knowledge of PowerPoint and management presentation preparation.

Knowledge of 7 QC Tools, 8D, CAPA, Root Cause Analysis, PPM, Rejection, Rework, and FPY.

Strong analytical, coordination, communication, and reporting skills.

Experience coordinating with multiple plant/quality teams will be preferred.

Job Title: Corporate Quality MIS Analyst – Automotive / Wiring Harness

Company: Vi-Son Cables Pvt. Ltd.

Location: Mumbai – Corporate Office

Experience: 3–7 Years

Industry: Automotive / Auto Components / Wiring Harness

Job Summary

We are looking for a Quality MIS Analyst with experience in the Automotive, Wiring Harness or Auto Components industry to manage Corporate Quality MIS and reporting. The role will be responsible for consolidating quality data from all plants, analysing KPIs and preparing reports and dashboards for Management.

Key Responsibilities

• Consolidate plant-wise Quality MIS, KPIs and performance reports.
• Analyze PPM, rejection, rework, FPY, customer complaints, CAPA and 8D.
• Prepare MIS reports, dashboards, trend analysis and Management presentations.
• Coordinate with Plant Quality Teams for timely and accurate data.
• Identify quality trends, deviations and improvement areas.
• Maintain standardized Corporate Quality MIS and databases.

Key Requirements

• 3–7 years of experience in Automotive / Wiring Harness / Auto Components Quality.
• Strong knowledge of Quality MIS, Quality KPI reporting and data analysis.
• Proficiency in MS Excel, Pivot Tables, VLOOKUP/XLOOKUP, dashboards and PowerPoint.
• Knowledge of 7 QC Tools, 8D, CAPA and Root Cause Analysis.
• Strong analytical, coordination and communication skills.

We are looking for a detail-oriented and analytical Data Analyst to join our team. The ideal candidate will be responsible for collecting, analyzing, and interpreting data to identify trends, generate insights, and support business decision-making.

The candidate should be comfortable working with large datasets, creating reports and dashboards, and communicating findings clearly to business stakeholders.

Key Responsibilities

• Collect, clean, organize, and analyze data from multiple sources.
• Identify trends, patterns, anomalies, and business opportunities from data.
• Create dashboards, reports, and visualizations for business teams.
• Track and report key performance indicators (KPIs).
• Perform ad-hoc analysis to support business and management decisions.
• Develop and maintain automated reports where possible.
• Work with stakeholders to understand reporting and analytical requirements.
• Ensure data accuracy, consistency, and quality.
• Present analytical findings in a clear and actionable manner.
• Maintain documentation for reports, dashboards, and data processes.

We are looking for a skilled Power BI / Power Platform Analyst with experience in data analysis, dashboard development, automation, and executive reporting. The ideal candidate should be proficient in Power BI, Power Apps, Power Automate, and advanced Excel to transform business data into actionable insights and improve operational efficiency.

Responsibilities

• Develop interactive dashboards and reports using Power BI to support business decision-making.
• Build and maintain applications using Microsoft Power Apps to streamline business processes.
• Design automated workflows using Power Automate to reduce manual tasks and improve efficiency.
• Perform data analysis, data validation, and data cleansing using Excel and other relevant tools.
• Prepare executive-level reports, KPI dashboards, and management presentations.
• Gather reporting requirements from stakeholders and translate business needs into analytical solutions.
• Integrate data from multiple sources and ensure data accuracy and consistency.
• Identify trends, performance gaps, and opportunities for process improvement.

Required Skills

• Strong experience in Power BI, Power Apps, and Power Automate.
• Advanced Excel skills, including PivotTables, lookup functions, and data analysis.
• Experience in dashboard development, KPI tracking, and executive reporting.
• Strong analytical, problem-solving, and data interpretation skills.
• Good communication and stakeholder management skills.
• Knowledge of SQL, DAX, Power Query, and data modelling is an added advantage.

Job Summary

We are looking for an experienced professional with strong expertise in Power BI, Power Apps, Power Automate, Excel, data analysis, and executive reporting. The candidate will be responsible for developing interactive dashboards, automating business processes, analyzing data, and preparing management reports to support business decision-making.

Key Responsibilities

• Develop, maintain, and enhance interactive dashboards and reports using Power BI.
• Build Power Apps solutions to improve business processes and user productivity.

Required Technical Skills

• Power BI: Dashboard development, report creation, data modeling, and visualization.
• Power Apps: Canvas apps, forms, and business application development.
• Power Automate: Workflow automation, approvals, notifications, and process automation.
• Microsoft Excel: Advanced formulas, PivotTables, lookups, data cleaning, and analysis.
• Data Analysis: Data interpretation, trend analysis, KPI tracking, and business insights.
• Executive Reporting: Management dashboards, performance reports, and KPI presentations.
• DAX & Power Query: Data transformation, calculations, and report optimization.

Preferred Skills

• Experience integrating multiple data sources.
• Knowledge of Microsoft 365 and SharePoint.
• Understanding of business intelligence and reporting best practices.
• Strong analytical, problem-solving, and communication skills.
• Ability to interact with business stakeholders and senior management.

Experience and Qualification

• Minimum 5+ years of relevant experience in BI, data analytics, reporting, or Microsoft Power Platform.
• Hands-on experience with Power BI, Power Apps, Power Automate, and Excel.