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

flextronics; Chennai District; On-site; INR 900,000 - 1,500,000; Full time

Benefits offered by this job

Health Insurance

PTO

Job summary

Flex is seeking an Automation Engineer for its Chennai location to develop automation solutions, dashboards, and AI-enabled workflows that enhance operational efficiency. The role focuses on VBA, RPA, SQL, Python, and office automation within a fast‑paced manufacturing environment.

You will work on API integrations and MIS reporting, with Tableau and Power BI for analytics, reporting to the Senior Manager. Day shift with night shift flexibility may be required.

Qualifications

• 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.
• Experience in developing Power Apps solutions and low‑code apps.
• Strong SQL skills for data extraction, transformation, and reporting.
• Strong Python programming and automation scripting skills.
• Experience in MIS reporting and data visualization with Tableau/Power BI.

Responsibilities

• Gather requirements and develop automation solutions using VBA, RPA, SQL and Office tools.
• Develop, test, deploy, and maintain automation apps and reporting solutions.
• Create and maintain SQL queries for data extraction and reporting.
• Prepare and distribute reports, dashboards and analyses.
• Collaborate with cross‑functional teams to identify automation opportunities.
• Support API integrations and AI‑assisted automation initiatives.
• Monitor performance and diagnose issues; document solutions and SOPs.

Skills

Excel/VBA

Python

SQL

RPA

Power Automate

Power Apps

Tableau

Power BI

MIS reporting

REST APIs

JSON/XML

AI‑assisted automation

Python automation

Data visualization

Education

Bachelor’s or master’s in engineering or equivalent degree

Tools

Power Automate

Power Apps

Tableau

Power BI

REST APIs

JSON/XML

OpenAI APIs

.NET

SharePoint

Job description

Flex is the diversified manufacturing partner of choice that helps market‑leading brands design, build and deliver innovative products that improve the world.

A career at Flex offers the opportunity to make a difference and invest in your growth in a respectful, inclusive, and collaborative environment. If you are excited about a role but don't meet every bullet point, we encourage you to apply and join us to create the extraordinary.

Job Summary

Job Description

Flex intends to Spin off its Cloud and Power Infrastructure segment into a new, independent publicly traded company, whichwe’recalling SpinCo, until the name is unveiled. The spin is planned for Q1 2027. If the intended spin occurs, this role will support SpinCo,which will focus on critical digital infrastructure, delivering end-to-end power and thermal management solutions for AI data centers and other mission‑critical applications.

To support our extraordinary teams who build great products and contribute to our growth, we’re looking to add an Automation Engineer located in Chennai location.

Automation & Reporting Engineer with good experience in Python, VBA, SQL, RPA, Power Automate, Power Apps, Tableau, Power BI, MIS Reporting, and Microsoft Office automation.

The role focuses on developing automation solutions, business applications, reports, dashboards, API integrations, and AI-enabled workflows to improve operational efficiency and modernize business processes..

Reports to the Senior Manager, and the role involves,

What a typical day looks like:

• 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.

The experience we’re looking to add to our team:

• 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 in 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.

• Knowledge of .NET, SharePoint, and web‑based applications is preferred.

• Familiarity with AI‑assisted automation, OpenAI APIs, Cloud Copilots, and Large Language Models (LLMs).

• Strong analytical, problem‑solving, communication, and stakeholder management skills.

• Day shift and flexible to work in Night shift if needed.

Preferred Skills (Good to have)

• 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 is an advantage.

Here are a few examples of what you will get for the great work you provide:

• Health Insurance

• PTO

NK99

Job Category

Production Engineering

Required Skills:

Optional Skills:

Flex pays for all costs associated with the application, interview or offer process, a candidate will not be asked for any payment related to these costs.

Flex is an Equal Opportunity Employer and employment selection decisions are based on merit, qualifications, and abilities. We do not discriminate based on: age, race, religion, color, sex, national origin, marital status, sexual orientation, gender identity, veteran status, disability, pregnancy status, or any other status protected by law. We're happy to provide reasonable accommodations to those with a disability for assistance in the application process. Please email [e-mail] and we'll discuss your specific situation and next steps (NOTE: this email does not accept or consider resumes or applications. This is only for disability assistance. To be considered for a position at Flex, you must complete the application process first).