Senior Data Analyst (Advanced Excel with PowerBI) - Gurgaon Location

Sonata Software; Gurugram District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Sonata Software is seeking a Senior Data Analyst in Gurgaon to design and deliver dashboards using Power BI and advanced Excel techniques. You will work with data modeling, preparing reports, and presenting insights to business users.

The role emphasizes accuracy, collaboration, and timely delivery of analytics solutions within a dynamic project environment.

Qualifications

• Proficient in Excel for complex data analysis and automation.
• Strong data modeling and dimensional design capabilities.
• Experience in designing interactive dashboards and reports.

Responsibilities

• Develop Power BI dashboards and reports from raw data.
• Model fact and dimension tables, relationships, and hierarchies.
• Implement aggregations, incremental refresh, and composite models in Power BI.
• Communicate insights effectively to stakeholders.

Skills

Advanced Excel

Data modeling

Dashboard design

Communication skills

Tools

GitHub

Power BI

PowerPoint

Job description

Currently we have an urgent Position for Senior Data Analyst Advanced Excel with Power BI role for one of our projects, location based in Gurgaon.

Kindly find below the details for your Perusal.

Job Location : Gurgaon

Mode of Employment : Permanent (Weekly 4 days WFO) - Shift timing: 7:30 AM IST to 7:30 PM IST

Job Description:

• Financial data and Macros
• Types of Variances
• Data modeling,
• Excel-based reporting
• Good Communication Skills.
• Power Point
• GitHub
• Design and develop interactive dashboards and reports using Power BI
• Handle fact and dimension tables, relationships, and hierarchies
• Implement aggregation tables, incremental refresh, and composite models

About Sonata Software:

Sonata is a global software company, one of the fastest growing in India. It specializes in Platform Engineering, Sonatas proprietary Platformation methodology, providing a framework that assists companies with their digital transformation journeys and helps them build their businesses on platforms that are Open, Connected, Intelligent, and Scalable. Sonata's platform engineering expertise is supported by its capabilities in Cloud and Data, IoT, AI, and Machine Learning, Robotic Process Automation, and Cybersecurity. With its centres in India, the US, Europe, and Australia, Sonata brings Thought leadership, Customer-centricity, and Execution Excellence towards catalysing the business transformation process for its customers around the world. You can read more here: https://www.sonata-software.com/platformation