MYSG Junior Data Analyst (Contract-based)

The Magnum Ice Cream Company; Kuala Lumpur; On-site; MYR 72,000 - 110,000; Full time

Benefits offered by this job

Competitive pay

Flexible work

Wellbeing support

Paid time off

Learning & development

Job summary

The Magnum Ice Cream Company is seeking a data analytics professional to support the Malaysia and Singapore business through data management, reporting, analytics, and process improvement.

You will transform raw data into reliable datasets, build dashboards, and develop data models to drive insights and decisions across the regional operation.

Qualifications

• Bachelor’s degree in a quantitative field such as Data Science, Statistics or related.
• At least 1 year of experience in data analytics, BI, data prep, or dashboard development.
• Strong Excel and Power Query skills for cleaning, transforming and consolidating data.
• Knowledge of SQL or Python; Power Automate experience is a plus.

Responsibilities

• Support Ice Cream Malaysia and Singapore with data management and reporting.
• Prepare, clean and transform raw data into structured datasets for analysis.
• Develop and maintain data-transformation workflows using Power Query, SQL or Python.
• Build data quality checks and reconcile source data with reporting outputs.
• Develop dashboards and analytical tools from approved designs.
• Perform descriptive analysis and translate findings into visuals for decision making.

Skills

Data analytics

Power Query

Excel

SQL

Python

Data visualization

Education

Bachelor’s degree in Data Science/Statistics/Analytics/CS/IS

Tools

Power Automate

Job description

Life tastes better with ice cream

With 19.000 expert ice cream colleagues and iconic brands like Wall’s, Cornetto and Ben & Jerry’s, loved in 76 countries, we are the world’s largest Ice Cream company leading the industry.

We create iconic ice cream brands that are part of everyday life, bringing moments of joy to millions of people around the world. Everybody loves ice cream. And as the world’s biggest pure‑play ice cream company, we have the scale and ambition to make a real difference.

What Truly Sets Us Apart Is How We Work.

We move fast and keep things simple. We turn ideas into action, trust people to take ownership, and work as one team to win together with integrity. Our culture is high‑performance, collaborative and focused on getting things done.

We’re curious and ready for what’s next. We embrace digital, use data to make better decisions, and keep learning, including how AI can help us work smarter and serve consumers better.

the role

You will be responsible for supporting the Ice Cream Malaysia and Singapore business through data management, reporting, analytics, and process improvement.

What You'll Be Responsible For

• Develop a practical understanding of Ice Cream Malaysia and Singapore business processes, data sources, customer and product hierarchies and approved performance measures
• Prepare, clean and transform raw data from approved sources into structured, reliable and reusable datasets for reporting and analysis.
• Develop and maintain repeatable data-transformation workflows using Power Query/M, SQL, Python or other approved tools, while consistently applying documented business rules and calculation logic.
• Build data quality, validation and reconciliation checks to identify missing records, duplicates, mapping errors, unusual movements and source-to-output differences, working with the Reporting Executive to resolve source-data issues.
• Support the development and enhancement of data models, dashboards, reports and analytical tools based on clearly defined business requirements and approved solution designs.
• Perform descriptive and diagnostic analysis to identify performance trends, gaps, drivers, risks and opportunities and translate findings into clear visualizations and decision-support outputs.
• Develop low-to-medium-complexity automation and process improvements that reduce manual effort, improve data accuracy and shorten reporting or analysis turnaround time.
• Conduct unit testing, support UAT, resolve identified defects, maintain technical documentation and present completed datasets, analysis and proposed improvements for review before deployment or stakeholder communication.

We're Looking For Someone Who

Rather than an exhaustive check list, focus on what really matters.

• Has a bachelor’s degree in Data Science, Statistics, Business Analytics, Computer Science, Information Systems or another related quantitative field.
• Has at least one year of experience in data analytics, business intelligence, data preparation, or dashboard development and can operate confidently in a
• Brings strong skills in Microsoft Excel and Power Query, including data cleaning, transformation, consolidation, formulas, PivotTables and structured dataset preparation
• Is knowledgeable in SQL or Python for data extraction, transformation and analysis; exposure to Power Automate or similar automation tools is an added advantage
• Understands data-quality principles, including validation, reconciliation, duplicate handling, mapping controls and maintaining consistent business rules.
• Brings strong analytical and problem-solving skills, with the ability to identify patterns, investigate data issues and present findings clearly
• Thinks end-to‑end and takes ownerships for results
• Is comfortable working in a fast‑moving, evolving organisation
• Values collaboration, clarity and low-ego ways of working

What You'll Get

Alongside meaningful work and strong development, we offer a reward package that typically includes

• Market-competitive pay and performance related rewards
• Flexible ways of working
• Support for health, wellbeing and life outside of work
• Time off to rest and recharge
• Ongoing learning and development opportunities

#TMICC

Why join us?

This is a place for people who are passionate about ice cream and are growth obsessed - both for the business and for themselves. People who act like an owner and drive our business end-to‑end. People who are driven by success to deliver more than we ever thought we could!

You’ll thrive here if you value an inclusive culture, with low ego and hierarchy - and if you’re excited to continuously learn and challenge how we work, using digital, data, and new thinking to push us forward.

• Roles with real accountability and visible impact
• Free to move fast, experiment and challenge how things are done
• Continuous learning and development as the business grows
• Reward linked to performance and contribution.

Your career here is shaped by what you deliver, as you work across functions and markets and grow with the business.

If you are an individual with a disability and require assistance at any time during our recruitment process, please let your Talent Acquisition Partner know.

Additional Information

The Magnum Ice Cream Company is an Equal Opportunity Employer. We embrace diversity and are committed to creating an inclusive environment where everyone can do their best work regardless of age, disability, gender identity, race, religion, sexual orientation, or any other protected characteristic. We encourage people with all backgrounds to apply including Aboriginal and Torres Strait Islander Peoples, and Māori and Pacific Peoples.