Automation Engineer

Actalent; Chennai District; Hybrid; INR 900,000 - 1,500,000; Full time

Job summary

Actalent is seeking an Automation Engineer to lead end-to-end automation projects, building robust Excel VBA solutions and dashboards. You will automate workflows across multiple applications, collaborate with cross-functional teams across time zones, and leverage Power Automate, GCP, BigQuery, Python, Power BI, and Qlik Sense to enable data-driven decisions.

Ideal candidates combine strong technical skills with clear communication and a collaborative mindset, applying automation expertise in a

Qualifications

• Independently manage end-to-end automation projects from requirements to deployment.
• Strong VBA coding skills with debugging and error handling expertise.
• Advanced Excel proficiency: macros, charts, pivot tables, complex formulas, user forms.
• Hands-on experience creating reports and dashboards with Excel and automation tools.
• Experience integrating workflows between Excel and SharePoint, PowerPoint, and Outlook.
• Practical experience with Excel VBA, Power Automate, GCP, BigQuery and Python.
• Dashboard development using Power BI and Qlik Sense.
• Excellent communication and presentation skills for non-technical stakeholders.

Responsibilities

• Own and deliver automation projects end to end across requirements, design, development, testing, deployment.
• Develop, debug, and optimize VBA code with robust error handling.
• Design and maintain Excel tools with macros, charts, pivots, and advanced data handling.
• Create automated reports and dashboards aligned with business needs.
• Identify issues, perform root-cause analysis, and implement solutions.
• Automate workflows using Excel VBA, Power Automate, GCP, BigQuery, Python.
• Develop and maintain dashboards in Power BI and Qlik Sense.
• Integrate Excel with SharePoint, PowerPoint, and Outlook for seamless workflows.
• Collaborate with cross-functional teams across time zones and cultures.
• Prepare demonstrations of tools and dashboards for stakeholders.

Skills

VBA coding

Excel advanced

Dashboard development

Power BI

Qlik Sense

Python

Power Automate

GCP BigQuery

SharePoint integration

Cross-functional collaboration

Tools

SharePoint

Outlook

PowerPoint

Excel VBA

Job description

Job Description

The Automation Engineer independently manages end-to-end automation projects, from requirements gathering and analysis through development, testing, and deployment. This role focuses on building robust Excel VBA solutions, automating workflows across multiple applications, and developing insightful dashboards to support data-driven decision-making. The ideal candidate combines strong technical skills with effective communication and a collaborative mindset to work seamlessly with cross-functional teams and stakeholders across time zones.

Job Title: Automation Engineer

The Automation Engineer independently manages end-to-end automation projects, from requirements gathering and analysis through development, testing, and deployment. This role focuses on building robust Excel VBA solutions, automating workflows across multiple applications, and developing insightful dashboards to support data-driven decision-making. The ideal candidate combines strong technical skills with effective communication and a collaborative mindset to work seamlessly with cross-functional teams and stakeholders across time zones.

Responsibilities

• Own and deliver automation projects end to end, including requirements gathering, analysis, design, development, testing, deployment, and implementation.
• Develop, write, debug, and optimize VBA code, including the effective use of objects, methods, and events for robust automation solutions.
• Design, build, and maintain Excel-based tools using macros, charts, pivot tables, complex formulas, functions, user forms, and advanced data handling techniques.
• Create automated reports and dashboards, ensuring they are accurate, user-friendly, and aligned with business requirements.
• Identify issues in existing processes or tools, perform root-cause analysis, and propose and implement effective solutions.
• Automate workflows and processes using Excel VBA, Power Automate, GCP, BigQuery, and Python, ensuring scalability and maintainability.
• Develop and maintain dashboards in Power BI and Qlik Sense to visualize key metrics and support decision-making.
• Integrate and automate interactions between Excel and other applications such as SharePoint, PowerPoint, and Outlook.
• Collaborate closely with cross-functional teams and stakeholders to understand requirements, provide regular updates, and ensure successful project outcomes.
• Adapt to working with diverse cultures and across different time zones, maintaining clear communication and coordination.
• Prepare and deliver clear presentations and demonstrations of developed tools, dashboards, and automation solutions.
• Leverage experience in the automotive OEM domain, if applicable, to better understand industry-specific processes and requirements.

Essential Skills

• Proven ability to manage and deliver automation projects independently from requirement gathering through deployment and implementation.
• Strong expertise in writing, debugging, error handling, and optimizing VBA code, including working with objects, methods, and events.
• Advanced proficiency in Excel, including macros, charts, pivot tables, complex formulas, functions, user forms, and data handling.
• Hands-on experience in report creation and dashboard development using Excel and automation tools.
• Ability to understand customer requirements and work effectively in a concept-to-design model.
• Strong problem-solving skills with the ability to identify issues, analyze root causes, and propose practical solutions.
• Experience integrating and automating workflows between Excel and other applications such as SharePoint, PowerPoint, and Outlook.
• Practical experience in automation using Excel VBA, Power Automate, GCP, BigQuery, and Python.
• Experience in dashboard development using Power BI and Qlik Sense.
• Excellent communication and presentation skills, with the ability to explain technical solutions to non-technical stakeholders.
• Demonstrated ability to work collaboratively within cross-functional teams and across different time zones and cultures.

Additional Skills & Qualifications

• Experience working in an automotive OEM environment is an advantage.
• Knowledge of Python and SQL for data processing, automation, and integration with other systems.
• Proactive and collaborative approach to working with cross-functional teams.
• Strong desire to continuously improve automation solutions and contribute to process optimization.

Work Environment

The role involves working in a highly collaborative, cross-functional environment that spans multiple time zones and cultures. You will use a modern technology stack that includes Excel VBA, Power Automate, GCP, BigQuery, Python, Power BI, Qlik Sense, and integrations with applications such as SharePoint, PowerPoint, and Outlook. The position emphasizes clear communication, regular interaction with stakeholders, and active participation in team discussions and presentations. Work is primarily focused on digital tools and data-driven solutions, with an emphasis on accuracy, reliability, and continuous improvement.

Diversity, Equity & Inclusion

At Actalent, Diversity And Inclusion Are a Bridge Towards The Equity And Success Of Our People. DE&I Is Embedded Into Our Culture Through

• Hiring diverse talent
• Maintaining an inclusive environment through persistent self-reflection
• Building a culture of care, engagement, and recognition with clear outcomes
• Ensuring growth opportunities for our people

Actalent is an equal opportunity employer.

About Actalent

Actalent is a global leader in engineering and sciences services. For more than 40 years, weve helped visionary companies advance their goals. Headquartered in the United States, our teams span 150 offices across North America, EMEA, and APACwith four delivery centers in India led by 1,000+ extraordinary employees who connect their passion with purpose every day. Our Bangalore, Hyderabad, Pune, and Chennai delivery centers are hubs of engineering expertise, with core capabilities in mechanical and electrical engineering, systems and software, and manufacturing engineering. Our teams deliver work across multiple industries including transportation, consumer and industrial products, and life sciences. We serve more than 4,500 clients, including many Fortune 500 brands. Learn more about how we can work together at actalentservices.com.