Location: Salt Lake Sector V, Kolkata
Salary: INR 6 LPA – INR 8 LPA
Experience: Minimum 5 Years Mandatory in a Data Analyst Role
Mode: Full-time, In-office
About Urban Money
Urban Money is a digital lending platform operated by Hytone Merchants Pvt. Ltd., an RBI-registered NBFC based in Kolkata. We provide fast, simple, and accessible credit solutions through a technology-driven loan process, combining digital onboarding, risk assessment, customer support, collections, and data-driven decision-making.
We are now expanding the Founder's Office team to work directly with Dewesh Agarwal, Founder of Urban Money, on high-priority business, technology, operations, and growth initiatives.
About the Role
We are looking for a highly skilled and detail-oriented Data Analyst with a mandatory minimum of 5 years of hands-on experience in a Data Analyst job profile. The candidate must have strong expertise in MS SQL Server, especially in an Azure environment, and should be highly comfortable working with large datasets, complex SQL queries, stored procedures, MIS reporting, automation, Power BI dashboard creation, and business analytics.
This role requires someone who can work closely with the Founder's Office, technology team, operations, credit, collections, and management to support data-driven decision-making across Urban Money's lending business.
Key Responsibilities
- Manage, analyze, and maintain large datasets across lending, collections, payments, customer, app, and operational systems.
- Write advanced SQL queries using MS SQL Server for reporting, reconciliation, business analysis, and performance tracking.
- Develop, maintain, debug, and optimize stored procedures, views, functions, joins, indexes, and scheduled SQL jobs.
- Work extensively on MS SQL Server hosted in an Azure environment, including database performance monitoring, query optimization, and data accuracy checks.
- Set up Power BI reports and dashboards from scratch, including data connection, data modelling, transformations, measures, visual design, publishing, and scheduled refresh.
- Create management dashboards, operational dashboards, MIS reports, and analytical reports using SQL, Power BI, Excel, Python, and other visualization tools.
- Use advanced Python for data analysis, reporting automation, data cleaning, reconciliation, scheduled reports, and process automation.
- Prepare daily, weekly, and monthly MIS reports for disbursement, collections, lead flow, customer behavior, loan performance, repayment trends, app activity, and team productivity.
- Identify data gaps, inconsistencies, duplicate entries, missing values, and system-level issues, and coordinate with the technology team for resolution.
- Automate repetitive reports, operational trackers, reconciliation reports, and management dashboards.
- Analyze business trends, customer patterns, repayment behavior, campaign performance, and collection efficiency to provide actionable insights.
- Work with APIs, system logs, payment gateway data, app data, and backend databases wherever required for reporting and reconciliation.
- Maintain data integrity, confidentiality, and accuracy across all reporting and analytical processes.
Mandatory Requirements
- Minimum 5 years of mandatory experience in a Data Analyst job profile.
- Strong hands-on knowledge of MS SQL Server.
- Strong experience working with SQL Server in an Azure environment.
- Excellent knowledge of stored procedures, complex queries, joins, views, functions, indexing, query optimization, and database performance improvement.
- Very strong hands-on knowledge of Power BI, including setting up dashboards from scratch.
- Ability to create Power BI dashboards independently, including data source connection, data modelling, Power Query, DAX measures, dashboard design, report publishing, and refresh scheduling.
- Very good knowledge of data visualization tools such as Power BI, Tableau, or similar BI/reporting tools is compulsory.
- Advanced knowledge of Python for automation, data cleaning, data analysis, reconciliation, report generation, and workflow automation is required.
- Strong experience in MIS reporting, dashboards, data cleaning, data validation, and business analytics.
- Experience in automating recurring business reports and management dashboards.
- Ability to handle large datasets and generate accurate business reports.
- Good knowledge of Excel and advanced Excel functions.
- Strong analytical, problem-solving, and logical thinking skills.
- Ability to understand business requirements and convert them into actionable reports, dashboards, and insights.
- Good communication skills and ability to work with management and cross-functional teams.
Preferred Skills
Experience in fintech, NBFC, lending, banking, collections, or app-based business will be strongly preferred.
Experience working with APIs, Postman, webhooks, payment gateway data, or app backend data will be preferred.
Understanding of loan lifecycle, customer onboarding, repayments, collections, and credit reporting will be beneficial.
Candidate Profile
The candidate should be highly analytical, sincere, detail-oriented, and comfortable working in a fast-paced fintech/NBFC environment.
We are looking for someone who does not only prepare reports, but also understands the business meaning behind the data. The right candidate should be able to identify problems, highlight trends, question data inconsistencies, automate reporting processes, automate process flows, and support management with meaningful insights.
This is a high-impact role for someone who wants to work closely with the Founder's Office and contribute directly to business growth, operational efficiency, automation, and data-driven decision-making.
How to Apply
Interested candidates can send their resume along with a brief professional summary to:
[Confidential Information], [HIDDEN TEXT]
Subject line: Application for Data Analyst – Reporting & Automation
