Position:
-
Data Analyst – Investment Team
Company:
-
Blenheim Chalcot India (for its FinTech venture BCI Finance)
Location:
-
Mumbai, India
Job type:
-
Full-time
Job mode:
-
Onsite
Job requisition id:
-
Not specified
Years of experience:
-
0 to 3 years
Company description
-
Blenheim Chalcot is widely recognized as a global leader in building and scaling innovative ventures.
-
With over 26 years of entrepreneurial success, they’ve developed a diverse portfolio of companies spanning FinTech, EdTech, GovTech, Media, Sports, and more.
-
Their ventures are strongly powered by GenAI, reflecting their commitment to staying at the forefront of digital innovation.
-
Blenheim Chalcot India, launched in 2014, plays a key role in the global operations, supporting ventures with critical services like tech, HR, legal, marketing, finance, talent, and tax.
-
The company aims to empower ambitious professionals to lead and deliver market-disrupting products and services.
-
BCI Finance, one of Blenheim Chalcot’s FinTech entities, specializes in private credit solutions for high-growth fintech businesses.
-
They operate a Credit Opportunities Fund and focus on providing strategic, growth-oriented funding with a long-term borrower relationship approach.
Profile overview:
-
The Data Analyst – Investment Team role supports Blenheim Chalcot’s FinTech investment operations by enabling data-driven decisions through detailed financial and risk analysis.
-
This position involves hands-on modeling and data interpretation to aid the investment lifecycle, especially credit and loan analytics.
-
The analyst will develop run-off models, perform scenario testing, and build dashboards for ongoing monitoring of borrower performance.
-
They will contribute to internal financial processes such as IFRS9 provisioning and provide insights that directly influence investment strategy.
-
A core part of the job includes maintaining a PostgreSQL database, uploading borrower data, and ensuring accuracy across analytics workflows.
-
The analyst also helps automate reports and visualizations with Python and PowerBI, simplifying access to data insights for internal stakeholders.
-
Support will be provided by the India team for complex SQL, Python, and dashboarding tasks, making the position accessible to those with strong Excel and some coding familiarity.
Qualifications:
-
Candidates should come from a strong academic background in finance, mathematics, statistics, or engineering.
-
Proficiency in Microsoft Excel is essential, particularly in modeling and complex formula use.
-
A working knowledge of Python is expected; familiarity with SQL and PowerBI will be an added advantage.
-
The role suits candidates who understand credit risk fundamentals and investment analysis.
-
The ideal applicant will have experience working with large, structured or semi-structured datasets.
-
Prior exposure to financial modeling, trend identification, and automated reporting tools is helpful.
-
Communication and stakeholder collaboration skills are important, as the role involves close coordination with investment professionals.
Additional info:
-
This role sits within a high-paced and ambitious environment with constant exposure to business leadership and investment strategy.
-
Analysts will learn directly from senior finance and investment professionals, contributing meaningfully to deal evaluation and portfolio oversight.
-
The culture is dynamic and collaborative, with access to cutting-edge GenAI tools for boosting productivity and insight generation.
-
Blenheim Chalcot offers 24 days of annual leave along with 10 public holidays, plus private health insurance for employees and their immediate families.
-
Employees also benefit from life insurance, a fun work culture, and unique experiences such as being part of the Rajasthan Royals IPL franchise ecosystem.
-
The organization actively promotes diversity, equity, and inclusion, and values people for their potential, ideas, and skills over background or demographics.
-
Internal mobility, continuous upskilling, and leadership grooming are strongly encouraged as part of the learning culture.
Run-Off Modelling Responsibilities:
-
Construct and update run-off models to measure credit coverage against loan portfolios.
-
Participate in quarterly IFRS9-related activities by feeding updated data into forecasting models.
-
Run sensitivity analysis and evaluate what-if scenarios for upcoming investment structures or modified deal terms.
Borrower Data Analysis Duties:
-
Analyze granular loan data to discover patterns in borrower performance, detect early warning signals, and highlight risk concentrations.
-
Contribute to credit risk sections of investment memos prepared for the senior decision-makers.
-
Maintain PowerBI dashboards with current borrower insights, allowing the team to monitor investments more effectively.
-
Provide periodic updates and feedback based on borrower trends in monthly meetings.
Data Platform and System Management:
-
Regularly upload financial datasets received from borrowers (mostly Excel) into a central PostgreSQL system.
-
Verify and maintain data integrity during each update cycle, ensuring historical consistency and avoiding duplication.
-
Support efforts to map new borrower data into the existing platform with attention to schema and business rules.
-
Contribute to Python-based tool development for internal use by investment professionals with limited technical expertise.
Tools and Tech Stack:
-
Essential Tools:
-
Excel: Used for advanced data modeling, forecasting, and analytical tasks.
-
Python: Applied in developing analytical tools and executing financial simulations.
-
GenAI tools: Including ChatGPT, Cursor, and others to speed up analysis and automate scripting.
-
-
Nice to Have Skills:
-
SQL (especially PostgreSQL): To query data, prepare tables, and manage data structures.
-
PowerBI: For creating insightful dashboards and visualizing key trends.
-
-
Team Support:
-
Dedicated team members in India are available to assist with technical tasks involving SQL, Python, and PowerBI.
-
While full technical mastery is not required, familiarity with data workflows and automation tools will help you succeed.
-
Ideal Candidate Attributes:
-
Capable of adjusting quickly to changing tasks and emerging challenges in an agile work setting.
-
Brings a problem-solving mindset and takes initiative to explore better solutions or methods.
-
Communicates clearly with both technical and non-technical teams, translating insights into business recommendations.
-
Comfortable navigating complex datasets and extracting meaningful conclusions that support investment activities.
-
Eager to learn and adapt, especially in using AI-driven tools and automating workflows.
Please click here to apply.
Comments
Post a Comment
Please feel free to share your thoughts and discuss.