HamburgerMenu
iimjobs
Job Views:  
276
Applications:  54
Recruiter Actions:  4

Job Code

1602929

Excel Modeler / Financial Modeler

Work mode - In office

Key skills:

Cash Flow, Modeling, Advanced Excel, Financial Modelling, Financial Reporting, Budgeting, Forecasting, Cash Flow Modeling, Data Modeling, General Ledger, Data Analysis

Experience : 5 to 10 Years


Job location : Hyderabad, Bengaluru

Job Sescription:

Skills:

- Expertise in advanced Excel functions such as INDEX, MATCH, OFFSET, SUMIFS, VLOOKUP, XLOOKUP, nested formulas, and array formulas.

- Experience of gathering requirements from Business and building financial models,

- Experience of building Cashflow transaction models.

- Experience of creating an Excel Models by understanding a requirement document provided as an input.

- Strong experience with Power Query, Power Pivot, and Excel Solver.

- Experience in Banking, financial services, Securitisation, consulting, or data analytics industries.

- Ability to handle and analyse large datasets with a focus on accuracy and attention to detail.

- Basic Knowledge of SQL will be nice to have.

JD:

- Design and develop complex Excel models for financial forecasting, budgeting, scenario analysis, and data-driven decision-making.

- Create automated solutions using advanced Excel functions, macros, and VBA (Visual Basic for Applications).

- Perform financial analysis, conduct data analysis using Excels data tools (Power Query, Power Pivot) to transform and analyse large datasets.

- Provide support for scenario planning and optimization, using advanced tools.

- Perform what-if analyses and create models for risk assessment and mitigation.

- Maintain and update existing Excel models, ensuring data accuracy, performance optimization, and troubleshooting issues.

- Document model assumptions, logic, and processes for future reference and team usage.

Didn’t find the job appropriate? Report this Job

Job Views:  
276
Applications:  54
Recruiter Actions:  4

Job Code

1602929

UPSKILL YOURSELF

My Learning Centre

Explore CoursesArrow