Vice President, Business Modelling, Portfolio Valuation Services

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