Data Analyst

Job Title : Data Analyst

Location : Ahmedabad

Shift Time : 2 : 00 PM – 11 : 00 PM)

Employment Type : Full-Time | Work from Office

Experience : 2 - 4 years of experience

About the Role :

We are looking for an experienced Data Analyst to join our analytics and reporting team. The ideal candidate will be skilled in Power BI, Power Query, SQL, Python, and Advanced Excel, with a passion for transforming raw data into actionable business insights. You’ll collaborate with cross-functional teams to support data-driven decision-making and process improvements across business units.

Key Responsibilities :

Design, develop, and maintain interactive Power BI dashboards and reports that effectively communicate insights and trends to stakeholders.

Perform data cleaning, transformation, and modeling using Power Query and DAX to ensure high-quality, reliable reporting.

Build and maintain efficient data models (star schema) to support performance and scalability in Power BI.

Utilize Advanced Excel for data preparation, formula-based analysis, and workflow automation.

Connect and manage data sources including Excel, SharePoint, SQL databases, and web APIs .

Manage data refresh schedules , workspaces, and permissions in the Power BI Service environment.

Troubleshoot data inconsistencies and create logical data transformation flows for complex datasets.

Collaborate with business teams to gather requirements and translate them into technical specifications and reports.

(Highly Desirable) Use SQL for querying, extracting, and optimizing data for analytics.

(Optional but Valued) Leverage Python (Pandas, NumPy) for data manipulation, automation, and predictive analytics.

Contribute to continuous improvement initiatives and recommend process automation where possible.

Required Skills & Competencies :

Proficiency in Power Query for data transformation, integration, and automation.

Strong understanding of data modeling fundamentals — including relationships, measures, and hierarchies.

Intermediate DAX skills (CALCULATE, time intelligence, filter context).

Expert-level Excel skills , including advanced formulas, pivot tables, and data validation.

Hands-on experience with Power BI ecosystem (Power BI Desktop, Service, and Gateway).

SQL proficiency for data extraction, joins, aggregations, and optimization.

Strong analytical and problem-solving skills with attention to data accuracy.

Excellent communication and collaboration skills with the ability to explain insights clearly to non-technical stakeholders.

Preferred Qualifications :

Bachelor’s degree in Computer Science, Information Technology, Statistics, Data Analytics, or a related field.

2+ years of professional experience in data analysis, business intelligence, or a similar role.

Experience working with US-based stakeholders or clients (preferred).