Senior Data Analyst

Mako IT Lab; Chennai District; On-site; INR 1,200,000 - 2,500,000; Full time

Job summary

Mako IT Lab in Chennai, India seeks an experienced Data Engineer to build, manage, and optimize data pipelines and datasets. The role emphasizes strong MS Excel skills, Python programming, and handling large datasets, supporting business and analytics teams with reliable, high-quality data.

Responsibilities include designing pipelines, performing data cleaning and transformations, and creating advanced Excel reports.

Qualifications

• Strong experience in MS Excel (advanced formulas, Pivot Tables, Power Query).
• Strong knowledge of Python (Pandas, NumPy, data manipulation).
• Hands-on experience with data handling, transformation, and cleaning.
• Good knowledge of SQL (writing complex queries, joins, indexing).
• Experience working with large datasets and structured/unstructured data.
• Familiarity with ETL tools/processes.

Responsibilities

• Design and maintain data pipelines and workflows.
• Perform data cleaning, transformation, and validation of large datasets.
• Create advanced reports using MS Excel (Pivot Tables, VLOOKUP, XLOOKUP, Power Query).
• Write and maintain Python scripts for data automation and processing.
• Optimize data storage and retrieval processes.
• Ensure data accuracy, consistency, and integrity across multiple sources.
• Collaborate with business analysts and stakeholders to understand data requirements.
• Support ETL and data warehousing processes.

Skills

MS Excel advanced formulas

Pivot Tables

Power Query

Python (Pandas/NumPy)

SQL queries

Data cleaning and transformation

Handling large datasets

ETL processes

Tools

AWS

Azure

GCP

Power BI

Tableau

Apache Spark

Git

Job description

Job Summary:

We are looking for an experienced and detail-oriented Data Engineer to build, manage, and optimize data pipelines and datasets. The ideal candidate should have strong expertise in MS Excel, solid knowledge of Python, and hands‑on experience in data cleaning, transformation, and handling large datasets. This role will support business and analytics teams by delivering reliable and high‑quality data.

Key Responsibilities:

• Design and maintain data pipelines and workflows.
• Perform data cleaning, transformation, and validation of large datasets.
• Create advanced reports using MS Excel (Pivot Tables, VLOOKUP, XLOOKUP, Power Query).
• Write and maintain Python scripts for data automation and processing.
• Optimize data storage and retrieval processes.
• Ensure data accuracy, consistency, and integrity across multiple sources.
• Collaborate with business analysts and stakeholders to understand data requirements.
• Support ETL and data warehousing processes.

Required Skills:

• Strong experience in MS Excel (advanced formulas, Pivot Tables, Power Query).
• Strong knowledge of Python (Pandas, NumPy, data manipulation).
• Hands‑on experience with data handling, transformation, and cleaning.
• Good knowledge of SQL (writing complex queries, joins, indexing).
• Experience working with large datasets and structured/unstructured data.
• Familiarity with ETL tools/processes.

Good to Have:

• Experience with cloud platforms like AWS / Azure / GCP.
• Familiarity with data visualization tools like Power BI, Tableau.
• Knowledge of Apache Spark or similar big data tools.
• Experience with version control tools like Git.