KPMG - Consultant - Financial Modeling

About us :

- KPMG is a leading professional services firm comprising over 174,000 professionals who work together to deliver value in more than 155 countries through in-depth industry insights in Audit, Tax & Advisory. The firm recorded more than USD 24.4 billion in revenues in 2015.

- The position in discussion is with the Deal Advisory team at KPMG Global Services (KGS), which is KPMG's global delivery center and is an integral part of the firm's strategy to enhance innovation, build scalability, and improve profitability, globally.

- KGS- Deal Advisory Group is a team of over 415 professionals based in Gurgaon.

- KGS DA has been providing solutions to KPMG member firms globally. Leveraging insights and applying best practices, the team helps create customized approaches to M&A transactions. The team's capabilities include Corporate Finance, Transaction Services, Strategy, Business Modeling, Accounting Advisory Services, Deal Advisory Research and Benchmarking.

Roles and responsibilities :

We are recruiting for Consultant in the Business / Financial Modelling team. Working as a Consultant in this team, your responsibilities will include:

- Review models and feedback findings to clients using KPMG proprietary software (mechanical checks);

- Analytical and commercial review of the client models to ensure appropriate flow of funds, no earnings leakage etc.

- Ensuring the consistency of client models with project documentation and data books;

- Documenting model issues for inclusion in review reports and liaising with the project manager to fully explain the points raised;

- Reviewing and commenting on revised models received from clients to verify whether review comments have been acted upon;

- Support the specification / design of models and analysis tools;

- Develop models (incl. integrated P&L, Cash flow and Balance sheet models) from scratch;

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

- Carry out analysis of the outputs of models;

- Document the operation of models and the findings from our work; and

- Carry out testing of models as per KPMG quality control procedures.

Essential skills required :

Education / professional qualifications :

MBA / PGDBM / CFA Prior Experience :

- 5-8 years working experience of Financial Analysis, Business Modelling or Financial Modelling

Project and Team management exposure :

- Credible record of operating as an independent contributor and also working as part of a team during larger projects

Technical skills:

- Knowledge of Visual Basic

- Knowledge of Microsoft Access.

Behavioral / team skills :

- A good working knowledge of accounting, financial statements, and financial analysis;

- Strong analytical and problem solving skills;

- Advanced knowledge of Microsoft Excel;

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

- Excellent communication and presentation skills

- Ability to build effective networks internally and externally

PEOPLE BENEFITS :

- A strong learning culture.

- Quarterly rewards and recognition programme Encore

- Comprehensive medical insurance coverage for staff and family.

- Expansive general and accidental coverage for staff.