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! Weare expanding our Portfolio Valuation team and are looking for a motivatedVice Presidentto 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 staff
- Proven 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 communicationskills.
- A passion for learning and evidence of self-directed learning on technical subjects.
- Ability to work with staff at all levels of the organization
