Senior Data Analyst

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.