Logo of Huzzle

Data Analyst

image

Allianz

1mo ago

  • Job
    Full-time
    Junior, Mid & Senior Level
  • Data
  • Munich

AI generated summary

  • You need a degree in a quantitative field, 2-5 years’ experience, strong SQL/Python/VBA skills, BI tool proficiency, Excel expertise, problem-solving abilities, and strong English communication skills.
  • You will manage data collection, automate loading, run queries for reporting, support forecasting and analyses, and collaborate with teams on portfolio and pricing model development.

Requirements

  • University degree data science, statistics, mathematics, analytics, or other quantitative discipline
  • 2 to 5 years of experience solving analytical problems using quantitative approaches, preferably in insurance industry
  • Strong experience in SQL, Python, VBA, Oracle and the main coding languages to manipulate data, draw insights from large data sets and produce reporting
  • Proficiency with one or more business intelligence tools such as PowerBI, MicroStrategy and/or similar
  • Proficiency with Excel and Office package
  • Strong problem solving abilities, including demonstrated tenacity at mining data to discover root causes of results
  • Strong English level of communication, including ability to translate complex analysis and concepts for non-experts
  • Strong communication skills and ability to work with IT, underwriting and actuarial experts

Responsibilities

  • Manage collection, cleaning, standardization, storage of data from different sources and formats into the standardized data model
  • Manage routines to automate the data loading to the DB, including errors checking procedures, maintenance of lookups and mapping files and manage periodical updates in case of mapping errors/modifications
  • Implement and manage codes and queries from the DB, aimed to produce internal automated reporting for:
  • Monitoring the portfolio profitability and KPIs with different levels of granularity, including automated triggers of warning procedures
  • Forecasting, in cooperation with Pricing Actuarial and UW
  • Producing Frequency-Severity Analyses in different dimensions
  • Work closely with the Global Data Manager to secure the alignment between the Data landscape and the business needs
  • Support the development of the Pricing Model(s) from data perspective
  • Work closely with all the Product & Underwriting teams on existing portfolio, new business and future product innovations.

FAQs

What are the key responsibilities of a Data Analyst at Allianz Partners?

The key responsibilities include managing data collection, cleaning, and storage, automating data loading routines, implementing codes and queries for reporting, monitoring portfolio profitability and KPIs, collaborating on forecasting and frequency-severity analyses, and working closely with various teams to support pricing model development and product innovations.

What are the educational qualifications required for this position?

A university degree in data science, statistics, mathematics, analytics, or a related quantitative discipline is required.

How much experience is needed for this role?

A candidate should have 2 to 5 years of experience in solving analytical problems using quantitative approaches, preferably in the insurance industry.

What technical skills are essential for the Data Analyst position?

Strong experience in SQL, Python, VBA, and Oracle is essential, along with proficiency in business intelligence tools like PowerBI or MicroStrategy, and advanced skills in Excel and the Office package.

What languages do I need proficiency in for this role?

Proficiency in English is required, with an emphasis on strong communication skills to explain complex analyses to non-experts.

Is there a focus on personal and professional development?

Yes, Allianz Partners offers a variety of courses and targeted development programs to support personal and professional growth.

Are there benefits related to health and wellbeing?

Yes, caring for health and wellbeing is a key priority, and the company has Work Well programs to provide peace of mind and flexibility in achieving work-life balance.

What is the company’s stance on diversity and inclusion?

Allianz Partners is committed to diversity and inclusion, welcoming applications regardless of ethnicity, cultural background, age, gender, nationality, religion, disability, or sexual orientation.

What type of employment is offered for this position?

This is a full-time, permanent position.

Will I have opportunities for career progression and international mobility?

Yes, the company encourages career progression and international mobility within its global environment.

Our purpose: We secure your future. Our promise is to give confidence in tomorrow.

Finance
Industry
10,001+
Employees
1890
Founded Year

Mission & Purpose

The Allianz Group is one of the world's leading insurers and asset managers with more than 100 million private and corporate customers in more than 70 countries. We are proud to be the Worldwide Insurance Partner of the Olympic & Paralympic Movements from 2021 until 2028 and to be recognized as one of the industry leaders in the Dow Jones Sustainability Index. Caring for our employees, their ambitions, dreams and challenges is what makes us a unique employer. Together we can build an environment where everyone feels empowered and has the confidence to explore, to grow and to shape a better future for our customers and the world around us. Join us and together, let’s care for tomorrow.