Data Analyst

Zmater Technologies; Hyderabad; On-site; INR 500,000 - 1,200,000; Full time

Job summary

Zmater Technologies is seeking a detail-oriented Data Analyst with at least 2 years of experience to support business decisions by collecting, cleaning, and analyzing data to drive improvements.

You will build dashboards in Excel/Power BI/Tableau, write SQL queries, and collaborate with Sales, Marketing, Operations, and Finance to translate data into actionable insights while upholding data governance and confidentiality.

Qualifications

• Bachelor's degree in Statistics, Mathematics, Computer Science, Economics, or a related field
• Minimum 2 years of hands-on experience in data analysis
• Strong proficiency in SQL for data extraction and querying
• Advanced knowledge of MS Excel (Pivot Tables, VLOOKUP, macros, etc.)
• Experience with data visualization tools such as Power BI, Tableau, or similar
• Basic to intermediate knowledge of Python or R for data analysis (preferred, not mandatory)
• Strong analytical and problem-solving skills
• Excellent attention to detail and accuracy
• Good communication skills to present technical findings to non-technical stakeholders
• Ability to manage multiple projects and meet deadlines

Responsibilities

• Gather data from multiple sources (databases, CRM, surveys, third-party tools) and ensure data accuracy and integrity
• Clean, organize, and validate data sets for analysis
• Build dashboards and reports using Excel/Power BI/Tableau to track key business metrics
• Perform statistical analysis to identify trends, patterns, and correlations in data
• Write and optimize SQL queries to extract and manipulate data from databases
• Collaborate with cross-functional teams (Sales, Marketing, Operations, Finance) to understand data requirements
• Present findings and actionable insights to management through clear reports and visualizations
• Identify opportunities for process automation and efficiency improvements
• Maintain documentation of data processes, definitions, and reporting standards
• Ensure compliance with data governance and confidentiality policies

Skills

SQL

Excel

Power BI

Tableau

Python

R

Data Visualization

Communication

Problem Solving

Multi-project management

Education

Bachelor's degree in Statistics/Mathematics/CS/Economics

Tools

SQL

Excel

Power BI

Tableau

Python

R

Job description

Job Summary

We are looking for a detail-oriented Data Analyst with a minimum of 2 years of experience to join our team. The ideal candidate will be responsible for collecting, cleaning, analyzing, and interpreting data to support business decisions and drive process improvements.

Key Responsibilities

• Gather data from multiple sources (databases, CRM, surveys, third-party tools) and ensure data accuracy and integrity
• Clean, organize, and validate data sets for analysis
• Build dashboards and reports using Excel/Power BI/Tableau to track key business metrics
• Perform statistical analysis to identify trends, patterns, and correlations in data
• Write and optimize SQL queries to extract and manipulate data from databases
• Collaborate with cross-functional teams (Sales, Marketing, Operations, Finance) to understand data requirements
• Present findings and actionable insights to management through clear reports and visualizations
• Identify opportunities for process automation and efficiency improvements
• Maintain documentation of data processes, definitions, and reporting standards
• Ensure compliance with data governance and confidentiality policies

Required Skills & Qualifications

• Bachelor's degree in Statistics, Mathematics, Computer Science, Economics, or a related field
• Minimum 2 years of hands-on experience in data analysis
• Strong proficiency in SQL for data extraction and querying
• Advanced knowledge of MS Excel (Pivot Tables, VLOOKUP, macros, etc.)
• Experience with data visualization tools such as Power BI, Tableau, or similar
• Basic to intermediate knowledge of Python or R for data analysis (preferred, not mandatory)
• Strong analytical and problem-solving skills
• Excellent attention to detail and accuracy
• Good communication skills to present technical findings to non-technical stakeholders
• Ability to manage multiple projects and meet deadlines

Good to Have

• Experience with ETL tools or data warehousing concepts
• Knowledge of statistical methods (regression, hypothesis testing, etc.)
• Familiarity with Google Analytics or similar web analytics tools
• Exposure to cloud platforms (AWS, Azure, GCP)