Automation Engineer (Python/VBA + RPA + MS Office Automation)

Overview

Automation & Reporting Engineer responsible for developing automation solutions, business applications, reports, dashboards, API integrations, and AI-enabled workflows to improve operational efficiency and modernize business processes. The role reports to the Senior Manager.

What you'll do

• Gather business requirements and develop automation solutions using VBA, RPA, SQL, and Microsoft Office tools.
• Develop, test, deploy, and maintain automation applications and reporting solutions.
• Create and maintain SQL queries for data extraction, transformation, and reporting.
• Prepare and distribute reports, dashboards, and business analyses.
• Work with cross-functional teams to identify automation opportunities and process improvements.
• Support API integrations and AI-assisted automation initiatives.
• Monitor automation performance and resolve issues through root cause analysis.
• Document solutions, SOPs, and technical processes.
• Provide guidance and training to team members when needed.
• Contribute to continuous improvement of automation, reporting, API, and AI solutions.

What you'll need

• Bachelor’s or master’s in engineering or equivalent degree.
• 3-5 years of experience as an Automation engineer.
• Advanced proficiency in Excel / VBA and Microsoft Office automation.
• Hands-on experience with RPA / Power Automate for workflow automation and business process optimization.
• Experience developing Power Apps solutions, forms, and low-code business applications.
• Strong knowledge of SQL for database querying, data extraction, transformation, and reporting.
• Strong knowledge of Python programming, including automation scripting, data processing, API integration, reporting, and application development.
• Experience in MIS reporting, dashboard creation, and data visualization.
• Hands-on experience with Tableau and Power BI for analytics, dashboard development, and business intelligence reporting.
• Experience integrating REST APIs, JSON/XML payloads, authentication, and web services.
• Strong analytical, problem-solving, communication, and stakeholder management skills.

Nice to have

• Knowledge of .NET, SharePoint, and web-based applications.
• Familiarity with AI-assisted automation, OpenAI APIs, Cloud Copilots, and Large Language Models (LLMs).
• Experience with MS Office Automation / Business process automation, Python automation, REST APIs, JSON/XML, authentication, and integration testing.
• Exposure to AI-enabled solutions, cloud copilots, and OpenAI APIs.
• Experience in manufacturing or BPO environments.

Details

• Location: Chennai, India.
• Day shift; flexible to work in night shift if needed.