Data Analyst

About the job

Role Overview: As a Data Analyst in the Treasury Mid office at Propelld, you will be responsible for gathering, analyzing, and presenting data-driven insights to optimize product offerings, streamline operations, and enhance the customer experience. You should have 2-3 years of experience, strong proficiency in Excel, and a solid understanding of financial numbers and treasury operations. 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, 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. Qualifications Required: - Preferred is MBA/CA/CFA - Bachelor's degree in Mathematics, Statistics, Economics, Finance, Computer Science, or a related field. - 2-3 years of experience as a Treasury / Data Analyst, ideally in a fintech or NBFC environment. - 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, 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.

Requirements

• Excel
• SQL
• Tableau
• Data Analysis
• Financial Operations

Qualifications

• MBA
• CA
• CFA
• Bachelor's in Mathematics
• Bachelor's in Statistics
• Bachelor's in Economics
• Bachelor's in Finance
• Bachelor's in Computer Science

Preferred Technologies

• Excel
• SQL
• Tableau
• Data Analysis
• Financial Operations