Senior Data Analyst – Creditas
Senior Data Analyst – Creditas
Gurgaon
Name
*
Email
*
Phone
*
IN
LinkedIn profile
*
Github or other link (Optional)
Upload your Resume
*
Add file
(max 10 MB)
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?
*
Choose
Your Current Organization
*
Total Experience (Years)
*
Data Analytics Experience (Years)
*
Have you led or mentored junior analysts, or managed a small team? (Yes/No)
*
Choose
Rate your SQL proficiency (1-5 scale) on: window functions, CTEs, stored procedures, query optimization
*
Choose
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)
*
Choose
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
*
Choose
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.
*
Submit
Made with
Binary