Innominds - Excel Modeler / Financial Modeler

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 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 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.

(ref : iimjobs.com)