Senior Data Analyst

Overview

We are looking for a Senior Data Analyst to join a healthcare content and communications company in Andheri, Mumbai. In this full-time role, you will work with large datasets to provide insights that support business decisions and help improve processes. You will also collaborate with various teams and mentor junior analysts.

Key Responsibilities

• Lead the collection, cleaning, validation, and organization of large, complex datasets from multiple sources to ensure accuracy and reliability
• Perform advanced data analysis using Excel, SQL, and BI tools to extract actionable insights
• Design, develop, and maintain dynamic dashboards, automated reports, and KPI tracking systems for senior management and stakeholders
• Identify trends, patterns, and performance gaps through in-depth analysis and provide strategic recommendations
• Collaborate with cross-functional teams to understand business objectives and translate them into data-driven solutions
• Develop and optimize automated reporting systems, macros, and data models to improve efficiency and reduce manual effort
• Conduct regular data audits and implement best practices to maintain data governance, integrity, and consistency
• Lead the development of forecasting models, predictive analysis, and scenario planning tools
• Mentor and guide junior data analysts, reviewing their work to ensure analytical accuracy
• Present insights and strategic recommendations to leadership teams clearly and effectively

Requirements

• Minimum 5 years of experience in data analysis or business intelligence
• Advanced proficiency in Microsoft Excel, including Pivot Tables, XLOOKUP/VLOOKUP, Power Query, Power Pivot, Macros, and VBA
• Strong hands-on experience with SQL for data extraction and manipulation
• Experience with data visualization tools such as Power BI, Tableau, or similar platforms
• Strong analytical and problem-solving skills with the ability to interpret complex datasets
• Knowledge of statistical analysis, predictive modeling, and forecasting techniques
• Excellent communication and presentation skills with the ability to influence decision-making
• Strong leadership and mentoring abilities
• Bachelor's degree in Statistics, Mathematics, Economics, Computer Science, Business Analytics, or a related field; a Master's degree is preferred but not mandatory

Nice to Have

• Experience with Python, R, or other analytical tools
• Understanding of data warehousing concepts and ETL processes