Job Description

Job Summary

n

We are looking for 2 highly skilled MIS professionals with strong Banking/BFSI domain experience and expertise in Power BI, Advanced Excel, Macros/VBA, and SQL. The ideal candidate should have strong analytical capabilities and hands-on experience in developing MIS reports,

n

dashboards, automation solutions, and management reports.

n

Key Responsibilities

n

n
- Develop, maintain, and automate daily/weekly/monthly MIS reports and dashboards.
n
- Create interactive and insightful Power BI dashboards for business and management reporting.
n
- Work extensively on Advanced Excel, including Pivot Tables, Pivot Charts, advanced formulas, data analysis, and reporting.
n
- Develop and maintain Excel Macros/VBA to automate repetitive reporting and data-processing activities.
n
- Write and optimize SQL queries for data extraction, validation, reconciliation, and reporting.
n
- Perform data analysis and identify trends, gaps, and key business insights.
n
- Prepare management dashboards and presentations highlighting KPIs, performance trends, and business metrics.
n
- Handle large volumes of data and ensure accuracy, completeness, and timely delivery of reports.
n
- Perform data validation, reconciliation, and quality checks across multiple sources.
n
- Collaborate with business, operations, finance, and other stakeholders to understand reporting requirements.
n
- Identify opportunities for MIS/reporting automation and process improvement.
n




- Ensure adherence to reporting timelines, quality standards, and banking processes.
n

n

Mandatory Skills

n

n
- Banking / BFSI domain experience – Mandatory
n
- Power BI – Strong hands-on experience
n
- Advanced Excel – Mandatory
n
- Macros / VBA – Mandatory
n
- SQL – Mandatory
n
- Strong knowledge of MIS reporting and dashboard development
n
- Good understanding of data analysis and visualization
n
- Excellent analytical and problem-solving skills
n
- Solid communication and stakeholder management skills
n

n

Preferred Skills

n

n
- Experience working with large datasets
n
- Knowledge of Power Query and DAX
n
- Experience in report automation and process improvement
n
- Exposure to banking operations, financial products, transactions, or banking KPIs
n
- Ability to independently manage reporting requirements from stakeholders
n

n

Candidate Profile

n

The ideal candidate should be excellent in MIS and analytical reporting, with strong hands-on technical skills and proven Banking/BFSI domain expertise. Candidates should be comfortable working independently, handling multiple reporting requirements, and delivering accurate, automated, and management-ready reports within tight timelines.

n

Key Skills: MIS | Banking | BFSI | Power BI | Advanced Excel | VBA | Macros | SQL | Dashboard | Reporting | Data Analysis | Automation | Power Query | DAX

📌 Management Information System Analyst (Pune)
🏢 SELECTIONS HR SERVICES PRIVATE
📍 Pune