Job Description

About Melodica Music Academy:

Melodica Music Academy is a renowned institution dedicated to the promotion of music and fostering a creative environment for music enthusiasts. We take pride in offering high-quality music education and nurturing talent. Our mission is to inspire the world through the power of music, and we are currently seeking a Senior Front Desk Officer to contribute to this mission.

Responsibilities and Duties:

• Design and automate reports and dashboards to showcase and analyze KPIs (sales, revenue, attendance, students) based on different parameters and reporting levels.
• Maintain and develop current reporting databases according to latest requirements and KPIs.
• Analyze sales based on product or category type.
• Report schedule patterns and identify opportunities for extra bookings and classes.
• Analyze top performers across the Group, across all levels (teachers, front desk officers, sales assistants).
• Comparison for sales, teaching hours and attendance amongst all branches.
• Reporting and analyzing conversion, retention and dropout rate.
• Liaise with Recruitment and HR Teams to maintain and update employee database used for reporting.
• Coordinate with different departments across the Group (HR, Finance, Education, Call Centre, Branches, etc.) in order to maintain the most accurate reporting database.
• Coordinate with all users in order to explain reporting process and clarify any related queries.
• Provide daily/weekly/monthly/quarterly/yearly insights to Management Team.

Qualifications and Skills:

• Power BI Visualization
• ETL
• Data Modeling
• Power Query and DAX
• Advanced Excel
• Power Automate is a plus
• Immediate joiners will be given preference

Job Type: Full-time

Application Question(s):

• Are you an immediate joiner?

Experience:

• Data Analyst: 3 years (Required)