Job Summary

We are hiring an experienced Analyst / Senior Data Analyst Business Analysis with 4 to 5 years of experience in data analysis and business intelligence. The ideal candidate should possess robust analytical skills, expertise in Advanced Excel, SQL, and Power BI, and experience working with large datasets to generate business insights. Candidates with experience in the US Mortgage or Collections domain will be preferred.

Experience
4 to 5 Years

Employment Type
Permanent

Work Location
Pune

Work Mode
Work from Office (Mandatory)

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

Notice Period
Immediate to 15 Days

Key Responsibilities
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.

Required Skills
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.
Solid 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.

Preferred Skills
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.

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

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

📌 Senior Data Analyst Pune (India)
🏢 Honeybee Tech Solutions
📍 India