Data Analyst - Treasury (Mid Office)
Department: Treasury - Debt & Lending Alliances
Location: Propelld Corporate Office, HSR Bangalore, India
Experience: Freshers (with a note for 2-3 years of experience in the summary)
Job Type: Full-Time
About Propelld
Propelld is a leading fintech NBFC focused on providing innovative financial solutions in the education sector. We are data-driven, using cutting-edge analytics to offer personalized loan products and services to our clients.
Job Summary
We are seeking a skilled Data Analyst for our Treasury mid-office team. While the initial posting indicates 'Freshers', the summary clarifies a preference for candidates with 2-3 years of experience, strong proficiency in Excel, and a solid understanding of financial numbers and treasury operations. The ideal candidate will be instrumental in gathering, analyzing, and presenting data-driven insights to optimize product offerings, streamline operations, and enhance the customer experience within our Bengaluru office.
Key Responsibilities
- Perform data collection, cleaning, and analysis of large datasets from multiple sources, including loan performance, customer data, financial transactions, and treasury operations.
- Utilize Excel for advanced data analysis, including pivot tables, VLOOKUPs, macros, and complex formulas to generate insights.
- Build and maintain automated reports and interactive dashboards to track key financial metrics using Excel and Tableau.
- Support decision-making processes by providing actionable insights and trends derived from data, particularly focusing on financial and treasury-related information.
- Collaborate with product, marketing, and operations teams to improve business performance through data-backed recommendations.
- Conduct A/B testing and statistical analysis to evaluate the impact of business experiments and initiatives.
- Use SQL for querying databases to extract and manipulate data efficiently.
- Ensure the accuracy, consistency, and quality of data through validation and best practices, with a specific focus on treasury and financial data.
- Present findings to both technical and non-technical stakeholders, including senior management.
Skills & Qualifications
- Preferred Education: MBA/CA/CFA
- Required Education: Bachelor's degree in Mathematics, Statistics, Economics, Finance, Computer Science, or a related field.
- Strong expertise in Excel for data analysis and reporting, including advanced functions like pivot tables, macros, and formula-based analysis, especially with financial and treasury data.
- Experience with SQL for data extraction and manipulation.
- Familiarity with data visualization tools such as Tableau or Power BI.
- Analytical mindset with the ability to interpret complex datasets and provide actionable insights, particularly in financial contexts.
- Experience with financial numbers and treasury operations is a primary requirement.
- Strong attention to detail and commitment to data accuracy.
- Excellent communication skills for presenting data-driven insights to cross-functional teams.
What We Offer
- A fast-paced work environment in a growing fintech company in Bengaluru.
- Competitive salary and comprehensive benefits.
- Learning and growth opportunities within a collaborative, inclusive team culture.