Senior Spreadsheet Developer| Amrit and Co | Chennai

Company Name: Amrit and Co

Position : Senior Spreadsheet Developer & Automation Expert (Excel Google Sheets & Claude AI)

Employment Type : Full-Time

Location : Kosapet Chennai

Experience : 3 5 Years

Salary : Up to 35000 per month

Amrit and Co is a progressive Chartered Accountancy (CA) firm focused on modernizing internal operations through technology-driven solutions. We are developing an advanced Management Information System (MIS) and File Management System (FMS) to streamline client deliverables improve resource productivity automate workflows and enhance financial reporting.

We are looking for a skilled and innovative Senior Spreadsheet Developer & Automation Expert to lead the design and implementation of intelligent spreadsheet solutions dashboards workflow automation and low-code applications.

This role is ideal for a highly experienced spreadsheet and automation professional who can architect scalable business solutions using Microsoft Excel Google Sheets Google Apps Script Google AppSheet and Claude AI. The selected candidate will play a key role in digitizing accounting workflows improving operational efficiency and building automated reporting systems.

• Design and develop automated MIS dashboards using Microsoft Excel and Google Sheets.

• Build systems to monitor GST Income Tax Audit compliance billable hours fee ageing and operational performance.

• Develop and maintain an efficient File Management System (FMS) for client documentation and workflow tracking.

• Build custom mobile and web applications using Google AppSheet integrated with Google Sheets.

• Develop user-friendly applications for workflow approvals task management and operational reporting.

• Develop automation using Google Apps Script (JavaScript) and Excel VBA.

• Automate repetitive tasks data entry report generation and spreadsheet synchronization using IMPORTRANGE and related functions.

• Configure automated email and WhatsApp reminders for statutory deadlines and client follow-ups.

• Utilize Claude AI to accelerate coding debug scripts optimize spreadsheet logic and rapidly prototype automation solutions.

• Leverage AI tools to improve productivity and enhance workflow efficiency.

• Create interactive dashboards using Pivot Tables Charts Slicers and Dynamic Reports.

• Transform complex datasets into executive-level reports and actionable business insights.

• Ensure spreadsheet performance data accuracy security and version control.

• Optimize large datasets to prevent system slowdowns and crashes.

• Train internal teams on newly developed systems and provide ongoing technical support.

• Bachelors Degree in Computer Science Information Technology Commerce Engineering or a related field.

• Relevant certifications in Excel Google Workspace Automation or AppSheet are an added advantage.

• Minimum 3 5 years of experience in spreadsheet development dashboard creation workflow automation or business process optimization.

• Prior experience with Chartered Accountancy (CA) CPA Audit Taxation or Financial Consulting firms will be highly preferred.

• Advanced proficiency in Microsoft Excel and Google Sheets.

• Strong knowledge of:

  • XLOOKUP

  • INDEX & MATCH

  • Pivot Tables

  • Power Query

  • Dynamic Arrays

  • Advanced Nested Formulas

  • Conditional Formatting

  • Data Validation

• Hands-on experience with:

  • Google Apps Script (JavaScript)

  • Excel VBA

  • Google AppSheet

• Strong understanding of workflow automation and system integration.

• Practical experience using Claude AI for:

  • Code generation

  • Script debugging

  • Spreadsheet optimization

  • Workflow design

  • Rapid prototyping

• Expertise in building executive dashboards business reports and interactive visualizations using charts and slicers.

• Strong analytical and problem-solving skills.

• Ability to identify manual processes and automate them efficiently.

• High attention to detail data accuracy and confidentiality.

• Good understanding of accounting workflows and financial reporting.

• Strong organizational and time management skills.

• Excellent communication and collaboration abilities.

• Self-motivated with the ability to work independently and manage multiple projects.

• Be part of a progressive CA firm embracing digital transformation.

• Work on innovative automation projects using modern spreadsheet technologies and AI.

• Opportunity to design and implement impactful business systems.

• Collaborative work environment with continuous learning and professional growth.

• Play a key role in improving operational efficiency through technology and automation.