Senior Consultant, Business Modelling, Portfolio Valuation Services

Kroll s Portfolio Valuation team is a market leader in providing illiquid portfolio pricing valuation, with our Portfolio Valuation professionals assisting clients in the valuation of alternative investments, specifically for securities and positions for which there are no "active market" quotations available. As part of the team, you will help our client-facing professionals develop modelling solutions that empower us to better serve our clients in a rapidly evolving market.

If you are excited about a career in modelling now is a great time to join Kroll ! We are expanding our Portfolio Valuation team and are looking for a motivated Senior Consultant to join us and support our growth.

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. Finally, the Senior Consultant will need to be a self-starter with strong communication skills and the ability to learn complex concepts quickly to work with senior leaders in the group. This position has the opportunity to grow and gain exposure to many different groups and offices within Kroll by working on cross-border and team engagements.

Day-to-day responsibilities:

• Conduct thorough reviews of existing Excel models and identify areas for structural and efficiency improvements.
• Develop and execute 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.

Essential traits:

• Bachelor's or Master's degree in Finance, Accounting, Economics, Computer Science or a related field.
• Minimum 3-5 years of experience creating and improving advanced financial models in Excel.
• 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

About Kroll

Join the global leader in risk and financial advisory solutions Kroll. With a nearly century-long legacy, we blend trusted expertise with cutting-edge technology to navigate and redefine industry complexities. As a part of One Team, One Kroll, you'll contribute to a collaborative and empowering environment, propelling your career to new heights. Ready to build, protect, restore and maximize our clients value? Your journey begins with Kroll.

.

Kroll is committed to equal opportunity and diversity, and recruits people based on merit.

#LI-SC1