Senior Data Analyst - SQL/Python

Description :

Role : Senior Data Analyst

Required : 4+ years of Experience.

Location : Mumbai

Educational Qualifications : Bachelor's degree in mathematics, engineering, statistics or related fields.

Roles and Responsibilities

Key Responsibilities :

• Own end-to-end analytics using SQL and Python affecting customer experience (CX), communications, loan repayments, product journeys affecting customer experience and seller experience
• Translate raw, complex datasets into clear insights, narratives, and actionable recommendations for Product, Operations, and CX teams.
• Partner with product and collections team to redesign repayment flows, customer experience flows and support in improving collection efficiencies by optimizing communication across various channels
• Drive root cause analysis for various incidences and suggest corrective and preventive actions to avoid such incidents in the future.
• Measure effectiveness of proactive communications (SMS, WhatsApp, Email, IVR)
• Run pre/post and A/B analysis on Message content, channel selection, timing and frequency
• Identify communication gaps that result in customer confusion, complaints, or repeat calls.

Technical Skills : SQL (Advanced)

• Write complex, optimized SQL queries including nested queries, CTEs, window functions, and multi-stage aggregations.
• Perform cohort, funnel, and trend analysis on billion-row datasets, optimizing performance.
• Python for Analytics
• Use Python (Pandas, NumPy) for exploratory analysis, feature creation, and deep dives.
• Automate recurring analytical workflows and reporting pipelines.