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
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
#LI-SC1