Senior Data Analyst

Advanced Excel, SQL, and Power BI

• 4 to 5 Years

• Permanent

• Pune

• Work from Office (Mandatory)

• US Shift (Candidates should be flexible to work in Day and Night shifts)

• Immediate to 15 Days

• Analyze large and complex datasets to identify trends, patterns, and business insights.
• Develop, maintain, and automate MIS reports, dashboards, and KPIs.
• Create interactive dashboards and visualizations using Power BI.
• Write efficient SQL queries for data extraction, transformation, and analysis.
• Collaborate with cross-functional teams to understand business requirements and deliver data-driven solutions.
• Evaluate business processes and recommend improvements for operational efficiency.
• Ensure data accuracy, integrity, and reporting consistency.
• Present analytical findings through reports, dashboards, and stakeholder presentations.

• 4 to 5 years of experience in Data Analysis or Business Analysis.
• Strong proficiency in Advanced MS Excel (Pivot Tables, Lookup Functions, Charts, Macros, Automation).
• Hands-on experience with SQL for data extraction and analysis.
• Strong knowledge of Power BI including data modelling, DAX, dashboard creation, and visualization.
• Good understanding of BI architecture and reporting best practices.
• Excellent analytical, problem-solving, and research skills.
• Strong verbal and written communication skills.
• Ability to convert business requirements into actionable insights.

• Experience in the US Mortgage or Collections domain.
• Knowledge of Python or R for data analytics.
• Experience with automation tools such as Power Automate or VBA.
• Bachelor's degree in Mathematics or Computer Science.

• Round 1: Teams Technical Interview
• Round 2: Excel SQL Assessment (Mandatory at Pune Office)
• Round 3: Final Teams Interview

• Work from Office is mandatory.
• Laptop is mandatory for the interview.
• Candidates available to join within 15 days will be preferred.