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

About the job

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

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 accessibility@flex.com 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).