Sr Data Analyst

Role Overview: As a Data Engineer at MAKO, you will be responsible for building, managing, and optimizing data pipelines and datasets to support business and analytics teams. Your expertise in MS Excel, Python, and data cleaning will be crucial in 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. Qualification Required: - 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. Additional Company Details (if present): MAKO IT Lab, founded in 2013, is a global software development company with a strong presence in the USA, UK, India, and Nepal. The company focuses on creating an empowering environment where individuals can take ownership, contribute innovative ideas, and grow through continuous learning and knowledge sharing. MAKO fosters long-term careers for its employees and encourages curiosity, initiative, and meaningful contributions to the company's journey.,