Total 3 Internship service centre manager job vacancies in singapore changi

In this role you are required:
1. Checking in passengers and ensuring all travel documents are valid for travel
2. Service ambassador to assist and guide passengers on the use of Self- Service Kiosk and Auto Bag Drops
3. Gate handling duties including communicating with airline crews and coordinating departure and arrival activities with various departments
4. Assisting passenger who require special assistance like wheelchair and escorting services
5. Any other Ad-hoc duties assigned by your supervisor

You are best equipped for this role if you are:
1. Able to read, write and communicate in English
2. Able to commit for 6 months. Please indicate your period of availability in your resume.
3. Able to multi-task in a fast-paced environment
4. A team player with good communication skills and analytical skills
5. Comfortable with rotating shift work

• Main support towards on-going projects related to marketing automotive services in the Asia-pacific region
• Market research of automotive trends and technology to form a strategy of product services offerings for Asia-pacific region
• Benchmark existing services programs and methodologies and propose recommended improvements to identify growth areas
• Support in the definition of online training strategies and development of training modules for China, Australia and ASEAN
• Monitor and evaluate training and helpdesk program’s effectiveness, success and ROI periodically and report on them
• Handles regional reporting for Technical Services Portfolio

1.    To perform Data Analysis and Reporting

• Analyse and generate reports of Asia Pacific data on Customer Backlog (CBL) 
• Work with Sales Logistics Customer Interface Team to ensure data quality and track the progress of CBL   
• Perform data validation, identify the root cause and resolves issues to improve the order fulfilment rate and overall impact on customer service level 
• Write complex SQL queries to extract, transform, and aggregate data from large databases efficiently. 
• Utilize Common Table Expressions (CTEs) to create temporary result sets and simplify query readability. 
• Leverage Window functions to perform advanced analytical operations, such as ranking, partitioning, and aggregations, within SQL queries.
• Optimize SQL queries for performance by using appropriate indexing strategies and query execution plans.
• Employ various JOIN operations (INNER JOIN, LEFT JOIN, FULL OUTER JOIN) to merge data from multiple database tables efficiently.
• Create subqueries and correlated subqueries when necessary to retrieve specific subsets of data.
• Implement conditional logic and CASE statements within SQL queries to handle complex data transformations.
• Continuously optimize SQL queries for performance, scalability, and maintainability. 
• Monitor and tune database performance to ensure efficient data retrieval.

2.    To build and enhance dashboards to support Process Automation

• Build and enhance Power BI dashboards with existing databases (SQL database, etc.) on different Order To Cash (O2C) topics.
• Maintain and improve current Power BI dashboards, including enhancing SQL scripts in databases and DAX measures in Power BI.
• Provide technical support to resolve data-related issues and troubleshoot problems in dashboards, and reports.
• Develop Python scripts to streamline and automate manual data transformation processes. 
• Identify repetitive data preparation tasks and create reusable Python scripts to perform data cleansing, formatting, and aggregation. 
• Continuously optimize and enhance Python scripts for performance, scalability, and efficiency.

3.    Cross-Functional Collaboration

• Collaborate and align with central departments/stakeholders to support in achieving sales target
• Manage multiple projects simultaneously, ensuring timely delivery of data analysis and reporting solutions. 
• Collaborate with project stakeholders to define project scope, objectives, and deliverables.