The ideal candidate should have prior financial analysis experience from consulting, corporate, audit, or banking background or other suitable evidence of a passion for developing deep technical skills. If you are an experienced professional in business modelling now is a great time to join Kroll! We are expanding our Portfolio Valuation team and are looking for a motivated Vice President to join us and support our growth.
Day-to-day responsibilities :
- Conduct thorough reviews of existing Excel models and identify areas for structural and efficiency improvements.
- Develop and execute on the identified solutions to enhance model performance and reliability.
- Utilize advanced Excel features (e.g. LET and LAMBDA functions), visual basics, and macros to automate repetitive tasks and streamline processes.
- Integrate SQL and Python scripting within Excel to extend functionality and data analysis capabilities.
- Leverage Microsoft Copilot, Power Automate, and / or other advanced tools to optimize modeling techniques, outputs and workflows.
- Design and structure Excel models to seamlessly integrate data from the Azure cloud environment into workflows.
- Contribute to the development of compelling data visualizations and dashboards in Excel and Power BI, translating complex data sets into clear, actionable insights.
- Proactively stay informed of industry best practices and emerging tools through ongoing education and professional development.
- Work with Kroll engagement teams to identify and implement modeling solutions for our clients.
- Supervising and mentoring junior staff
Essential traits :
Bachelor's or Master's degree in Finance, Accounting, Economics, Computer Science or a related field.Minimum 9-12 years of experience creating and improving advanced financial models in Excel.Demonstrated leadership experience including managing and developing client relationships and mentoring and developing staffProven expertise in Excel modeling with a strong foundation in VBA, SQL, and / or Python.Familiarity with Databricks and / or Azure and the ability to integrate data from these platforms into Excel is preferred.A track record in creating data visualization solutions in Excel and Power BI is preferred.Knowledge of accounting concepts and alternative assets, including but not limited to private equity and / or private credit, is preferred.Excellent analytical, problem-solving, and project management abilities.Strong communication skills, with the capacity to convey technical concepts to non-technical stakeholders.Strong analytical and problem-solving skills, as well as strong verbal and written communication skills.A passion for learning and evidence of self-directed learning on technical subjects.Ability to work with staff at all levels of the organizationSkills Required
Vba, Excel, Sql, Python