Data Analyst – Investment Team

The role

The Data Analyst – Investment Team is a vital role within the Blenheim Chalcot portfolio and BCI Finance . A Data Analyst – Investment Team supports investment professionals by analyzing financial, market, and economic data to identify trends, risks, and opportunities. They build models, dashboards, and reports to guide investment decisions, ensuring strategies are data-driven and aligned with performance goals.. You will gain hands-on experience in a fast-paced and progressive environment, where you will support us in building our next generation of GenAI enabled tech businesses.

List of key responsibilities and duties
Run-Off Modelling
-    Build, maintain, and analyse run-off models to assess credit security against borrower loan portfolios.
-    Contribute to quarterly IFRS9 provisioning by updating run-off models.
-    Run scenario and sensitivity analysis for potential new deal structures.
Borrower Data Analysis
-    Conduct loan-level analysis to identify performance trends, portfolio risks, and concentration issues.
-    Support investment memo preparation with credit risk analysis.
-    Update and maintain PowerBI dashboards for ongoing borrower monitoring. Feedback on emerging trends in BCI’s portfolio during monthly monitoring sessions.
Data Management and Platform Building
-    Manage data uploads from borrower excel files into a PostgreSQL database; maintain ongoing data integrity.
-    Help map new borrower data into the existing data framework.
-    Assist in developing Python-based analytics tools for internal use by non-technical team members.

Technical Experience
-    Necessary tools
o    Excel – for complex model building and analysis
o    Python – for in-depth data analysis and development of complex models
o    AI tools (Cursor, ChatGPT, etc.) – used to accelerate analysis and scripting
-    Nice-to-haves
o    SQL (PostgreSQL) – for data extraction, uploads, and structuring
o    PowerBI – for dashboarding and trend analysis
-    *Support in SQL, python and PowerBI will be available in BCI’s India team. A good excel background with some knowledge/experience with python is required.

About you

The ideal candidate will have a track-record in delivering results in a fast-moving business and hence be comfortable with change and uncertainty. Excellent stakeholder management experience is essential to being successful in this role.

List of qualifications, technical and or professional experience 

list of qualifications, technical and or professional experience 

-    Strong quantitative background (STEM or finance-heavy academic background)
-    Solid experience with Excel and financial model logic
-    Working knowledge of Python and/or SQL
-    Basic understanding of credit risk and investment structures
-    Ability and experience working with large datasets

About Blenheim Chalcot
Blenheim Chalcot is one of the leading venture builders in the world. We have been building exciting and disruptive businesses for over 26 years across sectors including FinTech, EdTech, GovTech, Media, Sport, Charity and more. These companies are all GenAI enabled and are some of the most innovative companies in the UK and increasingly around the world.

The BC team in India has been instrumental to the growth and success of Blenheim Chalcot. Established in 2014, Blenheim Chalcot India serves as a pivotal launchpad for those aiming to make a difference in the realm of innovation and entrepreneurship.

Blenheim Chalcot India is driven by a mission to empower visionaries to lead, innovate, and build disruptive solutions. We support our diverse portfolio of ventures and create impactful solutions that shape global trends. We provide a range of services to help new business get off the ground, including technology, growth (marketing and sales), talent, HR, finance, legal and tax, plus so much more!

One of our FinTech  ventures, BCI Finance, is scaling fast and we’re looking to hire high energy, motivated and curious talent to support them on that journey! 
About BCI Finance
BCI Capital, part of Blenheim Chalcot, is a private credit-specialist Investment Manager focused on supporting high-growth fintechs with flexible debt solutions. With a strong track record through its Credit Opportunities Fund, BCI aims to build long-term borrower relationships by offering empathetic, growth-focused funding. The role involves supporting the Loan Operations team with the daily administration and oversight of the existing loan portfolio.
What we can offer you

• Be part of the World’s Leading Digital Venture Builder
• Have the opportunity to be a part of and learn from the incredible diverse talent in BC
• Be exposed to the right mix of challenges, within a culture that promotes continuous learning and development and opportunity to work with Gen AI
• A fun and open, if a little cricket obsessed, atmosphere – we own the Rajasthan Royals IPL team!
• 24 days of annual leave &10 public holiday days
• Private Medical for you and your immediate family & Life Insurance for yourself

Important

At Blenheim Chalcot, we strive to create an environment where differences are not only accepted but greatly valued; where everyone can make the most of their capabilities and potential. We promote meritocracy, competence and the sharing of ideas and opinions. We are driven by data and believe the diversity, agility, generosity, and curiosity of our people is what sets us apart as an organisation. Our strong commitment to a culture of inclusion is evident through our constant focus on recruiting, developing and advancing individuals based on their skills and talent.