Lead Data Analyst

Role Overview: You will be responsible for identifying key metrics related to employee performance, engagement, retention, and satisfaction. You will analyze and report on data by collecting, cleaning, and organizing large datasets from various sources to identify trends and insights. Additionally, you will create advanced Excel models, dashboards, and reports to provide business insights. Furthermore, you will develop interactive dashboards and reports in Power BI to support strategic decision-making, and present complex data in visually compelling formats for stakeholders. You will also utilize Python for data processing, statistical analysis, and automation of repetitive tasks by writing scripts to integrate and analyze data from multiple systems and APIs. Collaboration with cross-functional teams to understand their data needs and deliver tailored solutions will be an essential part of your role. You will be expected to communicate findings effectively to both technical and non-technical audiences, as well as identify opportunities for process optimization and automation. It is crucial to stay updated with the latest tools, trends, and best practices in data analytics and visualization. Key Responsibilities: - Identify key metrics related to employee performance, engagement, retention, and satisfaction - Collect, clean, and organize large datasets from various sources to identify trends and insights - Create advanced Excel models, dashboards, and reports to provide business insights - Develop interactive dashboards and reports in Power BI to support strategic decision-making - Use Python for data processing, statistical analysis, and automation of repetitive tasks - Write scripts to integrate and analyze data from multiple systems and APIs - Collaborate with cross-functional teams to understand their data needs and deliver tailored solutions - Communicate findings effectively to both technical and non-technical audiences - Identify opportunities for process optimization and automation - Stay updated with the latest tools, trends, and best practices in data analytics and visualization Qualifications Required: - Bachelors / masters degree - Technical Proficiency in Advanced Excel skills (Pivot Tables, Macros, VBA, Power Query, etc.) - Hands-on experience with Power BI (DAX, Power Query, and data modeling) - Proficiency in Python for data analysis (Pandas, NumPy, Matplotlib, Seaborn, etc.) - Analytical Skills including strong problem-solving skills and attention to detail - Ability to interpret huge data and provide actionable recommendations - Soft Skills such as excellent communication and presentation skills, and strong organizational and time management abilities Additional Details: This role requires skills in VB Macros, Python, Power BI, and Advanced Excel.,