Senior Automation Manager / Automation Manager

Ipsos; Kuala Lumpur; On-site; MYR 90,000 - 180,000; Full time

Job summary

A global research firm in Kuala Lumpur is seeking a skilled team leader for data integration and analytics. This role involves managing a team, designing report automation processes, and developing dashboards using tools like Tableau and Power BI. The ideal candidate should possess strong communication skills, a deep understanding of data visualization, and proficiency in advanced Excel and VBA. This position offers the opportunity to work in a dynamic environment focused on delivering high-quality insights for clients.

Qualifications

• 3-5 years of experience in data integration and report automation.
• Good understanding of data visualization and effective graphic design.
• Proficient in Tableau or Power BI and other online dashboarding tools.
• Strong project management and multi-tasking abilities.
• Excellent communication and negotiation skills.
• Project management expertise and people leadership skills.
• Advanced Excel and VBA proficiency.
• Experience with SPSS is highly preferred.
• Experience with relational databases and SQL.
• Knowledge of web design basics (HTML/JavaScript/CSS/PHP).
• Self-starter with ownership mindset and ability to coach early-career analysts.

Responsibilities

• Manage team of programmers and analysts for optimal workload distribution.
• Design and develop PowerPoint report automation and analytical tools.
• Engage stakeholders to achieve desired business outcomes.
• Develop and maintain interactive dashboards using data visualization tools.
• Design and develop PowerPoint report automation, automated checks, and analytic tools (VBA/Excel).
• Build interactive dashboards using Excel, Tableau, Power BI, or cloud platforms.
• Integrate structured and unstructured data for statistical analysis.
• Drive process improvements and new automation tools; provide coaching.
• Collaborate with external stakeholders/vendors on contracts and initiatives.
• Provide support on complex operational matters.

Skills

Data integration

Data analytics

Report automation

Team management

Communication skills

Problem-solving

Project management

Data visualization

Web design basics

Analytical thinking

Tools

Tableau

Power BI

Advanced Excel

VBA

SPSS

SQL

HTML

JavaScript

CSS

PHP

Job description

Job Description

• Excellent organizational skill with a capacity to plan, prioritize, multi-task, and delegate effectively.
• Comfortable working with different teams from various countries of different time zones.
• Ability to manage a team of programmers/analysts to ensure balance of workload and sufficient support to the client-servicing teams. Involved in project management and coordination works.
• Be a people manager to set timely objectives, review objectively, motivate genuinely, and develop their knowledge/skill sets for better self and team advancement.
• Excellent interpersonal, influencing and negotiation skills with experience engaging and influencing key stakeholders to achieve optimal business outcomes.
• Ensure team members are consistently maintaining the Ipsos standard and delivering highest quality deliverables.
• Highly experienced in designing and developing PowerPoint report automation program, automated checking process and analytical tools with the use of VBA, advanced Excel functions, and/or other programming languages.
• Experience in designing and developing interactive dashboards using Excel, Tableau, PowerBI and/or other cloud-based platforms.
• Experience in data integration of structured and unstructured data and perform data transformation for the purpose of statistical analysis.
• Strong interest and knowledge of emerging technology trends and applications in data analytics space.
• Involved in process‑improvement initiatives (e.g. online platform enhancement, new automation tools) and provide necessary coaching to project members.
• Work with external stakeholders/vendors on contract agreements and other initiatives.
• Work closely with external stakeholders to provide support on complex operational matters.
• Any ad‑hoc duties/projects as assigned.

Requirements for this position

• Preferably with at least 3-5 years of experience in dealing with data integration, data analytics/ statistics, and report automation.
• Good understanding of data visualization and able to act as a subject‑matter expert on the effective use of graphics/design in relation to data representation.
• Proficient in Tableau or Power BI or other online dashboarding tools.
• Good communication and negotiation skills. Ability to interact with all levels effectively.
• Strong problem‑solving skill. Ability to deal with difficult situations objectively.
• Strong project management skill and multi‑tasking ability.
• Highly proficient in Microsoft Office, Advanced Excel, and VBA.
• Extensive experience with SPSS is highly preferred.
• Experience in relational database management systems and SQL.
• Sound knowledge of web design (HTML, JavaScript, CSS, PHP, and responsive design).
• A self‑starter with strong sense of ownership.
• Ability to manage and coach a team of young analysts.

About Us

Ipsos is one of the world’s largest research companies and currently the only one primarily managed by researchers, ranking as a #1 full‑service research organization for four consecutive years. With over 75 different data‑driven solutions, and presence in 90 markets, Ipsos brings together research, implementation, methodological, and subject‑matter experts from around the world, combining thematic and technical experts to deliver top‑quality research and insights. Simply speaking, we help the biggest companies solve some of their biggest problems, serving more than 5,000 clients across the globe by providing research, data, and insights on their target markets. And we are proud of our continuous efforts in making Ipsos the best place to work!

About The Team

The Healthcare Service Line works with pharmaceutical, bio‑tech, medical device manufacturers and technology companies throughout the project lifecycle from early stage strategy, to launch of a new product, to product optimization. In addition to custom research, the healthcare Service Line also works on therapeutic centers of expertise in Oncology, Autoimmune, Virology and more.