Data Analyst at Amrit Cement in Ahmedabad

Key Responsibilities

Reporting & Automation

• Automate Google Sheets workflows using:

o QUERY()

o IMPORTRANGE()

o Google Apps Script

o Python

• Build and maintain automated reports and data pipelines within Google Sheets and PowerBI.

• Create auto-refresh MIS and business reporting systems for Sales and Revenue teams.

• Reduce manual reporting efforts through process automation.

Data Management & ETL

• Perform ETL/ELT operations across multiple business tools and data sources.

• Extract, clean, transform, and validate large datasets for reporting and analysis.

• Ensure data accuracy, consistency, and integrity across systems.

Dashboarding & Analytics

• Design and maintain Power BI dashboards for sales, revenue, and business performance tracking.

• Build advanced Power BI data models and backend structures.

• Develop DAX measures, calculated columns, and KPIs.

• Generate actionable insights to support strategic business decisions.

Business Support

• Work closely with Sales and Revenue teams to understand reporting requirements.

• Support CRM-based reporting and performance tracking.

• Collaborate with stakeholders to improve reporting efficiency and visibility.