Senior Data Analyst – Creditas

Gurgaon

Name *

Email *

Phone *

LinkedIn profile *

Github or other link (Optional)

Upload your Resume *

Your Current Salary (Please indicate total CTC per annum) *

Your Expected Salary (Total CTC per annum) *

Are you currently interviewing elsewhere? Any other offers in hand? *

What excites you about this role? *

How soon can you join us? Enter your notice period in days. *

Are you currently based in or willing to relocate to Gurgaon for a work-from-office role? *

Your Current Organization *

Total Experience (Years) *

Data Analytics Experience (Years) *

Have you led or mentored junior analysts, or managed a small team? (Yes/No) *

Rate your SQL proficiency (1-5 scale) on: window functions, CTEs, stored procedures, query optimization *

You have a 50-million-row transactions table and a report is timing out. Walk me through your first three steps to diagnose and fix it. *

Write a SQL snippet (pseudocode is fine) to find customers whose latest transaction amount is higher than their average transaction amount, using a window function. *

Rate proficiency (1-5) on: pandas/numpy, automation scripting, dashboarding libraries (Plotly/Dash/Streamlit) *

Describe a recurring manual reporting task you automated using Python. What was the before/after time impact? *

Which dashboarding library/tool have you used most extensively in production — Streamlit, Dash, Plotly, Power BI, Tableau, or other? *

Rate proficiency (1-5) on: pivot tables, advanced formulas (INDEX/MATCH, array formulas), macros/VBA *

Give one example of an Excel-based report or process you fully automated, and roughly how many hours/week it saved. *

Tell us about a time your analysis led to a business decision that wasn't what stakeholders initially expected or wanted to hear. How did you handle it? *

A monthly collections report suddenly shows a 30% drop in recovery rate. Before alerting anyone, what are the first two things you'd check? *

Describe a project you owned end-to-end with minimal supervision — from problem definition to final delivery. *

Made withBinary