Data Analyst
Aditya Birla Capital · Maharashtra, India
- On site
- Full-time
- ₹600,000 / year
- Maharashtra, India
Job highlights
- Develop and manage MIS reports and dashboards.
- Ensure accurate data for decision-making.
- Analyze business performance and sales trends.
- Automate reporting processes.
- Support cross-functional teams with data.
About the role
Data Analyst
To support the secured lending business by developing, managing, and optimizing MIS reports, dashboards, and performance trackers. The role will ensure timely and accurate data availability for decision-making across sales, credit, collections, and product teams.
Key Responsibilities
- MIS Development & Reporting: Prepare daily, weekly, and monthly business MIS reports on disbursements, lead funnel, sourcing performance, TAT, and productivity metrics. Track business KPIs and SLAs across sales, credit, and operations.
- Data Management & Accuracy: Maintain databases with high accuracy. Ensure data integrity and consistency across multiple sources (CRM, LMS, core systems).
- Business Performance Analysis: Analyze sales trends, geography/branch-wise performance, and product-level insights. Assist in preparing dashboards and presentations for leadership reviews.
- Automation & Efficiency: Automate repetitive reports and processes using Excel Macros, Power Query, or Python (if applicable). Collaborate with the IT/Data team to streamline data fetching and storage.
- Cross-Functional Support: Coordinate with product, credit, risk, and collections teams to align on reporting requirements. Support ad-hoc data requirements for business planning, audits, or regulatory submissions.
Key skills/competency
- Data Analysis
- MIS Reporting
- Dashboard Development
- Data Management
- Excel Macros
- Power Query
- Python (Optional)
- KPI Tracking
- Business Acumen
- Cross-Functional Collaboration
Skills & topics
- Data Analyst
- MIS Reporting
- Data Management
- Business Analysis
- Excel Macros
- Power Query
- Python
- KPI Tracking
- Secured Lending
- Financial Services
How to get hired
- Tailor your resume: Highlight data analysis, MIS reporting, and automation skills relevant to Aditya Birla Capital's needs.
- Showcase relevant experience: Emphasize past successes in data management, business analysis, and cross-functional collaboration.
- Prepare for technical questions: Be ready to discuss your experience with Excel, Power Query, and potentially Python for data manipulation.
- Demonstrate business understanding: Articulate how your analytical skills can drive business decisions in a lending environment.
Technical preparation
Master Excel functions and Power Query.,Practice writing efficient SQL queries.,Learn Python for data manipulation.,Familiarize with BI tools like Tableau.
Behavioral questions
Describe a time you improved a process.,How do you handle data inconsistencies?,Tell me about collaborating with teams.,How do you prioritize reporting tasks?
Frequently asked questions
- What are the primary responsibilities of a Data Analyst at Aditya Birla Capital?
- The Data Analyst at Aditya Birla Capital is responsible for developing, managing, and optimizing MIS reports, dashboards, and performance trackers to support the secured lending business. This includes ensuring timely and accurate data for decision-making across sales, credit, collections, and product teams, analyzing trends, and automating reporting processes.
- What technical skills are essential for the Data Analyst role at Aditya Birla Capital?
- Essential technical skills include strong proficiency in MIS reporting, data management, and business performance analysis. Experience with Excel Macros and Power Query is crucial for automation. Familiarity with Python is a plus. Understanding of CRM, LMS, and core systems is also beneficial.
- How does a Data Analyst contribute to Aditya Birla Capital's secured lending business?
- The Data Analyst provides critical data insights and reporting that enable informed decisions across various departments like sales, credit, and collections. By tracking KPIs, analyzing trends, and ensuring data accuracy, they help optimize performance and support strategic business planning within the secured lending operations.
- What kind of data sources will I work with as a Data Analyst at Aditya Birla Capital?
- As a Data Analyst, you will work with data from various sources including CRM, LMS (Loan Management System), and core banking or lending systems. The role emphasizes maintaining data integrity and consistency across these multiple platforms.
- How can I best prepare my application for the Data Analyst position at Aditya Birla Capital?
- To prepare your application, ensure your resume clearly highlights your experience in data analysis, MIS development, and any automation tools like Excel Macros or Power Query. Quantify your achievements where possible and tailor your application to showcase how your skills align with the needs of the secured lending business.