Manager - MIS - BFSI

- This position involves extracting data from Systems and mapping the same as per the requirement.

- Coordinating with different teams for data and checking its accuracy.

- Preparing & cascading Daily, Weekly & Monthly MIS Reports at the National level for liabilities with zero errors and timely execution.

- Preparing presentations, Graphs, and analytical reports.

- Coordinating with the regions for feedback and different requirements.

- Support liabilities-HO in rolling out the data on new Projects and Initiatives and also updating on the progress & its impact via analysis of data.

- Ad-hoc analysis: prepare ad-hoc analysis on Operations data upon requests, using corporate Business Intelligence tool and customizing queries

Responsibilities:

1. Should have worked extensively in data handling.

2. Ability to work with Ms-Excel and execute macros + Power point skills is a must

3. Experience, knowledge of SQL Server administration tools including SQL Server Management Studio, SQL Server Agent

4. Skilled at optimizing large complicated SQL Queries and All Joins, updating queries, Ranks, For/While loops, Conditional Subqueries and writing Stored Procedures and creating Jobs.

5. Responsible for data importing, cleaning, transforming, validating, modelling data with the purpose of understanding or making conclusions from the data for decision-making purposes

6. Aggregate data from various sources, manipulate and analyze them at scale, support strategic and tactical initiatives, Analyze data for errors and inconsistencies

7. Identify, analyze, and interpret trends or patterns in complex data sets, comprising of both structured and unstructured data, using SQL and Excel.

8. Strong proficiency with SQL and its variation among popular databases

9. Good to have Knowledge on Tableau and Power BI

10. Working with operations and other reporting teams to understanding the requirements

Required Knowledge, Skills and Abilities

1. SQL Server

2. Experience in any of the BI tools is preferred (Power BI/ Tableau)

3. Excel Skills

4. Knowledge/prior experience in VBA/Macros is preferred

5. Strong analytical skills with the ability to collect, organize, analyze and presenting finding

6. Willingness to learn and enhance knowledge

7. SSIS/SSRS preferred