Job Description
We are seeking a highly analytical and technically proficient Automation & Data Analyst to join our team. In this role, you will be at the forefront of transforming our operational workflows through advanced data solutions. Your primary responsibility will be to build and maintain an integrated, automated reporting ecosystem using Google Workspace tools, with a focus on Google Sheets. You will create sophisticated dashboards and automated systems that streamline business intelligence, providing critical insights for both departmental use and executive leadership.
Key Responsibilities:
• Develop and maintain complex automated systems within Google Sheets using advanced formulas, Google Query functions, and custom Google Apps Script.
• Design and implement dynamic, user-friendly dashboards tailored to different stakeholders, including departmental teams (Doers) and executive management (MD).
• Create comprehensive FMS (Financial Management Systems), PMS (Project Management Systems), IMS (Information Management Systems), and MIS (Management Information Systems) reports.
• Write and manage macros, conditional formulas, and data validation rules to ensure data integrity and process efficiency.
• Utilize data analysis skills to interpret trends, identify business insights, and support strategic decision-making.
Skill Requirement
The ideal candidate is a detail-oriented problem-solver with a passion for data, automation, and process optimization. You should be a self-starter who can work independently to translate business needs into functional, automated solutions. Excellent analytical thinking and a keen eye for detail are essential for success in this role.
Required Skills & Qualifications:
• Expertise in all Google Sheets formulas, including complex functions like ARRAYFORMULA, VLOOKUP, INDEX-MATCH, and IMPORTRANGE.
• Advanced proficiency with Google Query (QUERY function) to manipulate and analyze large datasets.
• Practical experience in creating automated workflows using Google Apps Script.
• Strong knowledge of data visualization principles for creating effective dashboards.
• Familiarity with Google Data Studio and the ability to integrate it with Sheets is a significant advantage.
• Excellent analytical and problem-solving skills.
• A Diploma in G Suite courses or relevant certification is highly preferred.
• Minimum of 1 year of relevant experience in data analysis, automation, or a similar role.
• Ability to reliably commute or relocate to Thane, Maharashtra.