Data Analyst

At AND-E, we're redefining the future of mobility insurance. As part of the global MS&AD Group and in close partnership with Toyota, we aim to make tomorrow's journeys simpler, safer, and smarter. Our expertise spans over 30 markets in Europe and South Africa, providing tailored insurance solutions for Toyota and Lexus customers and various white-label partners. In Germany, our offerings include motor insurance, commercial fleet coverage, payment protection insurance, and support for Japanese businesses operating abroad.Lesen Sie den Überblick über dieses Stellenangebot, um zu verstehen, welche Fähigkeiten, einschließlich relevanter Soft Skills und Softwarepaket-Kenntnisse, erforderlich sind.Our commitment extends beyond business: at AND-E we support our people to grow, make a difference for customers, and help shape the future of connected mobility protection.You love diving deep into data, preparing complex information in a clear and comprehensible way, and want to actively shape how data-driven decisions are made in European Underwriting? Then this role might be exactly right for you.As part of our European Underwriting team, you will work closely with our European branches as well as departments such as Actuarial, Accounting, and Data Warehouse. Your goal: ensuring transparency and quality in our motor portfolios – through clean, well-structured data, clear reports, and sound analyses. How you'll make an impact Analyse data for ongoing and ad-hoc reports for the management and European branches of AND-E for our European motor portfolios Develop a reporting system for European Underwriting in cooperation with the branches and related departments such as Actuarial and Accounting to ensure accurate reporting Create reports and presentations for the Underwriting and Pricing Committee Work closely with the Data Warehouse team to understand and reconcile data for reporting Produce visualisations and reports (using tools such as Tableau, Power BI, and SQL) and present results to both technical and non-technical stakeholders in a clear, actionable way ETL of data Automation of reports and data modelling Connect BI tools to SQL databases Bachelor's degree in Computer Science, Data Science or a comparable field At least 3-5 years of professional experience as a Data Analyst or in data-driven roles Strong SQL skills (JOINs, CTEs, window functions, query optimisation) Experience with Redshift or other relational databases Confident use of Python (Pandas, NumPy) and common visualisation libraries Experience working with large, heterogeneous datasets Experiene in the insurance industry, preferably motor insurance Very good Excel skills, including Pivot Tables, VBA & macros Fluent English skills; good German skills are an advantage Confidence in international environments and in cross-functional xgcbozq collaboration Detail-oriented and independent working style as well as a proactive mindset Growth is important to us, that's why we support your personal and professional development Culture of trust, empowerment and constructive feedback Collaboration with people from different countries and cultures 32 days' annual leave plus 2 days' additional company holidays Flexible working hours and generous working from home policy Attractive employee conditions for our car insurance Health management and pme Family service Job tickets, parking spaces, travel allowance Employer's contributions (pension fund and capital-forming benefits, supplementary health insurance, occupational disability insurance) EGYM Wellpass Financial subsidy as a small wish-fulfiller Free hot and cold beverages and a weekly fruit basket