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

Flextronics - The Flex Company; Chennai District; On-site; INR 600,000 - 1,200,000; Full time

Job summary

Flex is seeking an Automation Engineer in Chennai to build automation solutions, reporting, and API integrations using Python, VBA, SQL, RPA, Power Automate, Power Apps, Tableau and Power BI to enhance operational efficiency.

The role covers MIS reporting, dashboards, data visualization, and AI-enabled workflows, with collaboration across teams and potential night shifts as needed.

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

Responsibilities

• Gathers business requirements and develops automation solutions using VBA, RPA, SQL, and Microsoft Office tools.
• Develops, tests, deploys, and maintains automation applications and reporting solutions.
• Creates and maintains SQL queries for data extraction, transformation, and reporting.
• Prepares and distributes reports, dashboards, and analyses.
• Collaborates with cross-functional teams to identify automation opportunities and process improvements.
• Supports API integrations and AI-assisted automation initiatives.
• Monitors automation performance and resolves issues via root cause analysis.
• Documents solutions, SOPs, and technical processes.
• Provides guidance and training to team members when needed.
• Contributes to continuous improvement of automation, reporting, API, and AI solutions.

Skills

Python programming

SQL

Excel / VBA

RPA / Power Automate

Power Apps

Tableau

Power BI

REST APIs / JSON/XML

AI‑assisted automation / OpenAI APIs

Stakeholder management / communication

Education

Bachelor’s or Master’s in Engineering

Tools

Tableau

Power BI

Power Apps

REST APIs / Web Services

.NET

SharePoint

JSON / XML payloads

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

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.

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

Through the collective strength of ~150,000 team members across 30 countries and responsible, sustainable operations, 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 with Flex offers the opportunity to make a difference, invest in your growth, and build great products for our customers that improve people’s lives. Together, let’s create the extraordinary! Join our talent community to learn more about job opportunities, company news and events.