Consultant - Deal Advisory - BFSI

Consultant -Deal Advisory

Role & Responsibilities :

We are recruiting for a Consultant in the team. Your responsibilities will include:

The requirements for role is classified in 3 categories:

i ) Model Design & Development :

- Gather requirements, understand the specific business needs and solution design

- Prepare model architecture design and specification documentation;

- Develop Excel and/or Access based Financial, Operational, Business case and Cost Optimisation models as per modelling best practices;

- Conceptualise, design and develop various automated MIS / Reporting solutions using MS Excel, Access, SQL Server, QlikView and Tableau etc.

- Amend models developed by other KPMG staff or by third parties

ii) Model Review & Testing :

- Review models and feedback findings to clients using KPMG proprietary software;

- Stress test the models as per quality control procedures

iii) Other Responsibilities:

- Independently handle efforts around conceptualization, execution and delivery of assignments

- Ensure QA of outputs to the client while adequately undertaking project management and stakeholder management responsibilities

- Proactively co-ordinate with onsite engagement teams to ensure high quality and on-time delivery

- Support technical skill-building within the organization (training, process definition, research of new tools and techniques, etc)

- Interface with senior executives of clients and target companies to obtain relevant data and other documents

- Proactively set-up and lead meetings with the stakeholders for obtaining clarifications, resolving issues, communicating progress and post-delivery de-brief and feedback

- Support activities around client proposal and technical documentation

Skills & Qualifications :

To succeed in this demanding role you will need to demonstrate the following skills and experience:

- 2 - 4 years of working experience in Business Modeling/Financial Modelling/Data Modeling, Business analysis/Financial Analysis/Commercial Analysis and consulting.

Required Skill set :

Technical Skills :

- Experience in model review techniques and testing procedures, modelling principles, best practices etc.

- Exposure to model any of the model review tools and review methodologies

- Advanced knowledge of Microsoft Excel, knowledge of VBA Programming and modelling best practices

- Knowledge of MS Access, database concepts such as database design, normalization, SQL queries and stored procedures etc.

- Knowledge of Microsoft Visual Studio, SSIS, SSRS, data visualisation tools like QlikView, Tableau and other BI tools will be an advantage

- Strong problem solving and data interpretation skills; knowledge / experience in analysing large data sets

Business Skills :

- Good understanding of accounting principles, financial statements, and in particular financial evaluation methods and valuation techniques

- Exposure to reviewing valuation models, feasibility studies, investment and transaction (acquisition / separation) models

- Exposure to UKGAAP & IFRS can be an advantage

- Commercial outlook and a good understanding of the general business and economic environment;

Organizational Skills :

- Excellent written, verbal communication and presentation skills

- Ability to build and maintain effective networks internally and externally with multiple stakeholders

Flexibility and Adaptability :

- Strong team player with demonstrated ability to organize, plan and prioritize the competing priorities

- Adaptable, open to change and continuously seeking opportunities to improve systems, processes and methods

- Demonstrated ability to learn and succeed in a fast-paced environment

- Experience of working with clients / teams outside India and ability to travel

Optional Skills :

- Knowledge / experience in project involving optimization / simulation modeling through concepts Monte-Carlo simulation and Linear Programming

Qualification:

- Undergraduate degree in Engineering / Economics / Commerce / Mathematics

- Post graduate or equivalent in commerce /MBA / Computer Science.

- Both the undergrad and the Masters SHOULD BE from a Top tier university.

Contact
Jaswinder kohli