EXL logo

Data Analyst

EXL
4 days ago
Full-time
On-site
Gurgaon, Haryana, India
Data Science & Analytics
Description

The candidate having 4 years of hands-on experience in designing, developing, and publishing interactive Power BI dashboards and reports. They have strong expertise in DAX, Power Query, and data storytelling, with advanced SQL skills including joins, window functions, and performance optimization. Their background includes digital marketing analytics, with mandatory experience in Adobe Analytics, enabling them to translate raw marketing data into actionable insights.

They have worked extensively in client-facing roles, gathering business requirements, building data models, and converting business needs into technical specifications with clear timelines. Their experience spans quantitative analysis, data modeling, reporting, and data warehousing, with additional exposure to Power Automate. Known for effective communication and stakeholder engagement, they are well-positioned to deliver end-to-end BI solutions that drive decision-making and business growth.

 


Responsibilities
  • Develop and maintain BI solutions using Power BI, SQL, and Adobe Analytics to deliver actionable insights.
  • Design and publish dashboards/reports with strong focus on data storytelling, visualizations, and usability.
  • Write and optimize advanced SQL queries for data extraction, transformation, and performance improvement.
  • Leverage Adobe Analytics for digital marketing data analysis and reporting.
  • Gather business requirements from stakeholders and translate them into technical specifications and data models.
  • Consult with clients and stakeholders in a client-facing role, ensuring clear communication and alignment on deliverables.
  • Perform quantitative analysis and data modeling, supporting reporting, warehousing, and database architecture.
  • Collaborate on automation solutions (Power Automate exposure is a plus) to streamline BI workflows.
  • Ensure timely delivery of BI projects by establishing clear timelines and managing expectations.


Qualifications

1. 4+ years of extensive experience in prototyping, designing, developing, and publishing Power BI Reports and dashboards

2. In depth knowledge of DAX, Power Query, Visualizations and Story Telling

3. Strong expertise in advanced SQL query writing (joins, window functions, performance optimization)

4. Prior experience in Digital/Marketing Analytics

5.Experience with Adobe Analytics is mandatory

6. Experience identifying business requirements in the context of BI and creating data models to transform raw data into relevant insights.

7. Experience converting business needs into technical specifications and establishing timelines for job completion.

8. Proven experience in quantitative analysis, data modelling, reporting, data warehousing, database architecture

9. Experience with Power Automate is a plus

10. Effective communication and should have worked in a client facing role