Bosch Group
Intern, Sales Logistics Customer Service Data Analyst
Job Description
Company Description
Robert Bosch (South East Asia) Pte Ltd is a regional subsidiary of the Bosch Group, representing the Group’s interests in Southeast Asia where it is present in all ASEAN member countries. Business operations in these countries report to Robert Bosch (South East Asia) Pte Ltd, located in Singapore. Bosch has been present in Southeast Asia since 1919, with diversified businesses in the company’s four business sectors – Mobility Solutions, Industrial Technology, Consumer Goods, and Energy and Building Technology. Bosch’s strategic objective is to improve quality of life with products and services that are innovative and spark enthusiasm. In short, Bosch creates technology that is “Invented for life.”
At Bosch, we care. For you, our business, and our environment.
Let’s turn visions into reality. At Bosch,we shape the future by inventing high-quality technologies and services that spark enthusiasm and enrich people’s lives. Our areas of activity are every bit as diverse as our outstanding Bosch teams around the world. Their creativity is the key to innovation through connected living, mobility or industry. Our responsibility goes far beyond business. We’re independent of stock markets and bound to the purpose of the Robert Bosch Foundation; our success directly benefits society, the environment, and future generations. Our promise to our associates is rock-solid: we grow together, we enjoy our work, and we inspire each other. Join in and feel the difference.
Let’s be remarkable.
Job Description
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.
Qualifications
- Able to work full time for a period of 7 months (03.06.2024 to 31.12.2024)
- Undergraduate studies in Data Analytics / Business Analytics / Supply Chain
- Good knowledge on operation and self-driven
- Strong time management and organizing skills
- Excellent verbal and written communication skills
- Meticulous in task execution
- Works well under pressure, with a high degree of adaptability and flexibility in a fast-paced, rapidly changing environment
- Extensive knowledge on MS Excel, prefer with knowledge on macros
- Experience on PowerBI/SQL/Python Script is a must
Additional Information
- Candidate should fulfil the visa requirements for employment in Singapore
- Applicant must be enrolled throughout internship period, or plan to pursue further studies
- For foreign students studying overseas, you must be eligible for the Work Holiday Programme (WHP)
