Data Analyst (Junior)

Mitsui Sumitomo Insurance Co. Ltd.; Sydney; Hybrid; AUD 90,000 - 110,000; Full time

Benefits offered by this job

Flexible hybrid working arrangements

Flu shots and skin checks

Life, TPD & Salary Continuance保险

Job summary

Mitsui Sumitomo Insurance Oceania (MSIG) is seeking a Data Analyst on a 12-month fixed-term contract to support our Underwriting and Distribution teams with accurate data, insightful analysis, and reliable reporting. Reporting to the Business Analytics Manager, you will manage data, build dashboards, and contribute to data pipelines, ensuring data integrity across systems while driving efficiency.

Candidates will have strong Excel/SQL/Power BI skills and a practical mindset for automating

Qualifications

• Bachelor's degree in computer science, statistics or mathematics, or related field.
• Minimum 2 years' experience in data cleansing, validation and analysis.
• Experience with underwriting data and distribution partner portfolios is preferred.
• Strong MS Excel, SQL and Power BI skills for dashboards.
• Hands-on data modelling and data pipelines desirable.
• Practical use of Copilot to streamline data modelling and improve pipelines.

Responsibilities

• Data management and accurate data entry for underwriting and MGAs.
• Maintain and validate underwriting data and distribution partner portfolios.
• Ensure data integrity across systems and databases.
• Prepare and deliver reports for internal stakeholders and distribution partners.
• Provide in-depth analysis and interpretation of data and risk measures.
• Drive technology adoption to streamline processes and reporting.
• Identify opportunities for efficiency and accuracy improvements.

Skills

Data cleansing

Data analysis

Attention to detail

Communication

Time management

Copilot for data modelling

Education

Bachelor's degree in computer science, statistics, or mathematics

Tools

MS Excel

SQL

Power BI

Job description

Full-time Contract Entry Level

Description

About Us:

Mitsui Sumitomo Insurance Oceania (MSIG) is a proud branch of Mitsui Sumitomo Insurance Company Limited in Japan and a member of the esteemed MS&AD Insurance Group Holdings, Inc—one of the world's largest general insurance groups. We operate in Australia and New Zealand, providing a diverse range of corporate, commercial, personal, and specialty insurance products.

The Role:

Join our Data Analytics and Processing team as a Data Analyst on a 12-month fixed-term contract (with potential for extension). Reporting to the Business Analytics Manager, you'll play a key role in supporting our Underwriting and Distribution teams by ensuring data accuracy, integrity, and insightful analysis.

What You'll do:

• Data Management
• Perform accurate and timely data entry for underwriting, including managing agency businesses (MGA) across Australia and New Zealand.
• Maintain and validate underwriting data and distribution partner portfolios (MGAs).
• Ensure data integrity across systems and databases.
• Reporting & Analysis
• Prepare and deliver reports for internal stakeholders and distribution partners.
• Provide in-depth analysis and interpretation of data and risk measures.
• Process Improvement
• Drive technology adoption to streamline processes and reporting.
• Identify opportunities for efficiency and accuracy improvements.

What We're Looking For

• Bachelor’s degree in computer science, Statistics, or Mathematics, or related field.
• Minimum 2 years' experience in data cleansing, validation and analysis —insurance industry experience strongly preferred.
• In-depth working experience in MS Excel, SQL, Power BI, including building dashboards for business stakeholders.
• Hands-on experience with data modelling and building data pipelines is highly desirable.
• Practical application skills using Copilot to streamline data modelling, improve pipeline reliability, and accelerate insight generation.
• Strong attention to detail with accuracy and efficiency.
• Excellent communication, interpersonal, and time management skills.
• Must hold a valid work visa or permanent residency to work in Australia.

What We Offer

• A friendly, supportive team environment part of a small local business with a global exposure.
• Flexible hybrid working arrangements.
• Competitive salary and company benefits, including flu shots and skin checks.
• Complimentary Life, TPD & Salary Continuance Insurance.

“If you are interviewed but not successful, we may retain your application details to consider you for future suitable roles, in line with the Privacy Act 1988 (Cth)."