Senior Automation Manager

Ipsos; Selayang Municipal Council; On-site; MYR 60,000 - 100,000; Full time

Job summary

An established industry player is seeking a skilled data analytics manager to lead a team in delivering high-quality insights and reports. This role involves project management, team leadership, and the development of automated reporting tools using advanced Excel, VBA, and visualization platforms like Tableau and Power BI. The ideal candidate will have a strong background in data integration and analytics, coupled with excellent communication and negotiation skills. Join a dynamic team that collaborates with global clients to solve complex problems and drive business success in the healthcare sector.

Qualifications

• 3-5 years of experience in data integration and analytics.
• Proficient in Tableau, Power BI, and advanced Excel.
• Strong project management and problem-solving skills.

Responsibilities

• Manage a team to ensure workload balance and client support.
• Design and develop automated reporting tools and dashboards.
• Engage with stakeholders for optimal business outcomes.

Skills

Data integration

Data analytics/statistics

Report automation

Project management

Communication skills

Problem-solving

Interpersonal skills

Negotiation skills

Education

Bachelor's degree in relevant field

Tools

Tableau

Power BI

VBA

Advanced Excel

SPSS

SQL

HTML

JavaScript

CSS

PHP

Job description

Job Description

Roles & Responsibilities:

Job Summary

1. Excellent organizational skill with a capacity to plan, prioritize, multi-task, and delegate effectively.
2. Comfortable working with different teams from various countries of different time zones.
3. 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.
4. Be a people manager to set timely objectives, review objectively, motivate genuinely, and develop their knowledge/skill sets for better self and team advancement.
5. Excellent interpersonal, influencing and negotiation skills with experience engaging and influencing key stakeholders to achieve optimal business outcomes.
6. Ensure team members are consistently maintaining the Ipsos standard and delivering highest quality deliverables.
7. 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.
8. Experience in designing and developing interactive dashboards using Excel, Tableau, PowerBI and/or other cloud-based platforms.
9. Experience in data integration of structured and unstructured data and perform data transformation for the purpose of statistical analysis.
10. Strong interest and knowledge of emerging technology trends and applications in data analytics space.
11. Involved in process-improvement initiatives (e.g. online platform enhancement, new automation tools) and provide necessary coaching to project members.
12. Work with external stakeholders/vendors on contract agreements and other initiatives.
13. Work closely with external stakeholders to provide support on complex operational matters.
14. Any ad-hoc duties/projects as assigned.

Requirement for this position

1. Preferably with at least 3-5 years of experience in dealing with data integration, data analytics/statistics, and report automation.
2. 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.
3. Proficient in Tableau or Power BI or other online dashboarding tools.
4. Good communication and negotiation skills. Ability to interact with all levels effectively.
5. Strong problem-solving skill. Ability to deal with difficult situations objectively.
6. Strong project management skill and multi-tasking ability.
7. Highly proficient in Microsoft Office, Advanced Excel, and VBA.
8. Extensive experience with SPSS is highly preferred.
9. Experience in relational database management systems and SQL.
10. Sound knowledge of web design (HTML, JavaScript, CSS, PHP, and responsive design).
11. A self-starter with strong sense of ownership.
12. Ability to manage and coach a team of young analysts and programmers.

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 5000 clients across the globe by providing research, data, and insights on their target markets. And we’re proud to share we’ve received our Great Place to Work Certification in 2022 & 2023!

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.