About 17Capital
17Capital is a private credit manager, specializing in NAV finance for the private equity industry. It provides non-dilutive capital to high-quality private equity management companies, funds, and institutional investors as part of their toolkit for value creation and portfolio management. Founded in 2008, 17Capital has completed over 100 investments and 50 exits, deploying more than $13 billion since inception. 17Capital has raised $13 billion across six successive funds and mandates.
For more information, please go to www.17capital.com
17Capitals’ Values
Our values are the basis on which we build strong relationships with our clients, our investors and each other. They are the foundation of our business and integral to our continued ability to pioneer success.
Build trust – We behave and act in ways that earn trust
Embrace “different” – We embrace new ideas and constantly strive to discover new ways of doing things
Make things happen – We are agile and responsive in a way that delivers success for all our stakeholders
Strive for excellence – We act with professionalism and adhere to our high standards
Overview of Department
The Fund Finance team currently comprises 13 team members who have responsibility across the preferred equity and credit funds. This is a rare opportunity to join an expanding and high-performing team supporting the ambitious growth plans of the business. The CFO has over 20 years’ experience and is supported by Finance Directors and Fund Controllers with significant PQE.
Position Summary
We are looking to add an Associate to the Fund Performance team, a growing team within 17Capital responsible for performance analysis across 17Capitals’ Funds and Investments servicing internal and external stakeholders. The role represents an exciting opportunity to be part of a team which will sit at the forefront of the business with touchpoints across the business and with senior stakeholders. The individual will work closely with Fund Accounting, Client Services and the Investment Teams.
The successful candidate will have advanced MS Excel modelling experience and will have a mandate to enhance in-house performance analysis models as well as undertaking complex excel based analysis to support fundraising topics.
The candidate will have experience with Power BI and will be involved with enhancing the ability of the business to report to stakeholders via Power BI reports and dashboards. As part of this, the candidate will have experience creating and working with large volumes of structured data and using this data for analysis.
The focus of the role is on adding to the existing team’s capability to provide accurate and timely information and analysis to the business which supports important topics such as fundraising and understanding drivers of value.
They will be confident to liaise with people of all levels across the business and will be motivated by the opportunity of taking ownership and responsibility.
This is a hands-on role in a fast-paced environment which offers the opportunity to drive improvements in Fund Performance at a leading and rapidly growing fund manager. The role is highly analytical, requires a keen eye for detail and the ability to work with large data sets in a logical, structured fashion.
Role & Responsibilities
The following responsibilities of the role include but are not limited to:
Technical Knowledge
- Achieve a detailed understanding of the fund’s portfolio investments, Limited Partnership Agreements, Borrowing Facility Agreements, investment pipeline and FX/cash management policies
- Develop a thorough knowledge of 17Capital Metrics & Calculation Methodologies and be able to explain calculation methodologies used in performance analysis to the rest of the business
Modelling and Performance Analytics
- Supporting the quarterly valuations process by maintaining and enhancing the calculation engines and reporting tools in both MS Excel and Power BI
- Co-ordinate with Tech Team to ensure valuations are output automatically and accurately into the data warehouse
- Co-ordinate with Loan Operations function to ensure valuations data is transferred to Investment track record on a timely basis – work with Tech Team to automate this process
- Take ownership of updating the Investment Track Record and releasing to the business to deadline
- Produce bespoke analysis of Investment performance for the business including Senior Leadership and individual investors as required, including to support fundraising
- Build enhanced models for Gross to Net performance analysis of funds
Forecasting
- With other team members, take ownership of the quarterly fund performance forecasting process
- This involves liaising with both the Investment Team for inputs for individual investments and the Client services and Senior Leadership team who are the end users of the outputs
- Enhancing the existing fund forecasting models and data flows to allow for more structured output to the stakeholder within the business and externally
- Liaise with Tech Team and use PowerBI to automate provision of forecasting data to Client Services
Power BI
- Use PowerBI to develop new dashboards and automate reporting of forecasting, track record and gross to net performance outputs
- Be the link between the Technology and Finance teams in the creation of new and informative analysis, Power BI dashboards and models for the business as required
- Work with Tech Team to ensure data flow processes support the production of PowerBI and ensure mappings of data from data warehouse to PowerBI reports are accurate
- Work with Treasury and leverage PowerBI to develop reports which support other areas of the business – such as subscription line and FX hedge monitoring reports
- Support the Investment Risk monitoring function of the business by creating monitoring tools and dashboards for the investment portfolio and identify risks
Data
- Help to shape, document and implement processes with adequate controls to ensure performance team data is captured and transferred between repositories accurately and efficiently in a controlled environment
- Work to ensure all data captured and utilised forms part of a structured data set
- Ongoing collaboration with Fund Controllers to ensure timely provision of fund accounting data to support performance analysis
- Reviewing and re-structuring data, such as gross portfolio and treasury data, for efficient input to excel models and to software solutions
- Challenge and improve current processes around data governance and review in order ensure the business can be confident in the data and analysis produced
Required
- Degree in Maths, Physics or other highly numerical discipline
- Professional experience within Finance and demonstrable knowledge of finance reporting / metrics
- Interest in private markets asset classes and strong desire to work in the sector
- Modelling/advanced user of MS Excel (Power Query, creating models from scratch)
- Power BI experience creating and maintaining dashboards and data management processes
- Interest in the use of technology-based solutions to reduce reliance on excel
- Highly analytical with prowess for working with high volumes of numerical data
Desirable
- Private funds experience
- Module in Finance, or one of CFA, ACA, ACCA, CIMA preferred
- Exposure to other MS Power platform software (Power BI paginated reporting or SSRS, Power Apps)
- Exposure to Power BI semantic models and DAX & M
Individual profile
- Individual accountability and ownership
- Strong teamwork orientation
- Team player with a willingness to learn and engage
- Conscientious, hard working with excellent attention to detail
- Adaptable to changing work demands and ability to work across multiple deals or workstreams concurrently
- Able to manage time effectively and prioritise tasks
- Excellent interpersonal and communication skills
Key Relationships and Stakeholders
Internal
- Client Services
- Investment Professionals
- Fund Controllers and Accountants
- Technology Team
- Senior Management Team
External
- Banks
- FX and Financial Risk management advisor
We can offer you:
- Career development
- Opportunity to learn and grow whilst making a meaningful contribution to the expansion of the 17Capital platform during an exciting time of the firm’s life cycle
- Competitive reward and benefits
17Capital is an equal opportunity employer and does not discriminate based on race, religion, gender, age, sexuality, gender identification, or physical ability. If you have a disability and need an adjustment during the application and hiring process, including support for the interview or onboarding process, please contact recruitment@17capital.com.