IT - Metrics Analyst - Data Visualization

eTeam; Kuala Lumpur; On-site; MYR 48,000 - 72,000; Full time

Job summary

A data analytics firm in Kuala Lumpur seeks an analyst to develop innovative data visualization dashboards using advanced tools like Tableau. The role requires proficiency in SQL and advanced Excel to integrate data effectively. Responsibilities include collaborating with stakeholders for reporting requirements, designing and building comprehensive reports and dashboards, and ensuring data accuracy and integrity. Ideal candidates should possess strong interpersonal skills and a background in business intelligence.

Qualifications

• Mastery in data visualization tool (advanced tableau) is essential.
• At least 1 year of experience using SQL with complex functions required.
• Proficiency in advanced Excel functions is necessary.

Responsibilities

• Collaborate with stakeholders to gather reporting requirements.
• Design and build reports and dashboards for various data sets.
• Prepare technical documentation and specifications.

Skills

Data visualization tool (advanced tableau)

Advanced Excel (pivot table, macros, PowerPivot, Power Query, Power View)

SQL queries with advanced functions

Job description

Primary Skill Set

• Master in data visualization tool (advanced tableau)
• Knowledge in advanced excel (pivot table calculation, macros, PowerPivot, power query, power view)
• At least 1 year experience in SQL queries with advanced functions (e.g., Inner/Outer Joins, Union, Intersect, Lead)

Job Description

The analyst is responsible to develop data visualization dashboards (Business Intelligence) with clear and compelling information. The analyst needs to have a good background of SQL query and advanced excel to blend and integrate the data in the visualization tool. The analyst ensures source data that is accurate, congruent, and reliable, and ensures the information is easily available and comprehensible to users for direct consumption or integration with other systems. The analyst may perform analysis for a wide range of data in different databases and various formats. The analyst works closely with customers to determine business requirement and priorities. The analyst supports the Service Management Manager in completing overall responsibilities of the team.

Job Responsibilities

• Partner with stakeholders/customers across CES to gather reporting requirements, understand needs, priorities, and advise on optimal design choice
• Design and build reports and dashboards for CES across a wide array of data sets
• Design and build executive reports and dashboards for leadership
• Coordinate and manage testing of reporting
• Produce operational reports for service consumption based on agreed data sets and cadence
• Prepare technical documentation and specifications (e.g.: data definition, data source, and data flow diagram)
• Managing the information flow for the organization including the integrity and availability of data
• Adhere and enforce data standards, maintain common data dictionaries
• Champion continuous improvements to ensure services are delivered at a pacesetter's cost
• Ensure timely communication to key customers
• Ensure a safe and secure operating environment
• Comply with corporate and S&C policies and report all violations
• Be familiar with DR/BCP plans and in the event of an incident, take charge in executing plans

Nice to Have Skill Set

• Problem Management - Planning and design, work within the timeline, monitor and steward closure.
• Customer Relationship Management - Maintain relationship with customers, apply user centered design.
• Agile - Basic understanding of agile methodology (e.g.: MVP, scrum and Kanban)

Soft Skill Set

• Interpersonal Skills
• Communication Skills
• Presentation Skills