Data Analyst

Cultural FitYou 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 impactAnalyse data for ongoing and ad-hoc reports for the management and European branches of AND-E for our European motor portfoliosDevelop a reporting system for European Underwriting in cooperation with the branches and related departments such as Actuarial and Accounting to ensure accurate reportingCreate 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 databasesWhat it takes to succeed in this roleBachelor’s degree in Computer Science, Data Science or a comparable fieldAt least 3-5 years of professional experience as a Data Analyst or in data-driven rolesStrong SQL skills (JOINs, CTEs, window functions, query optimisation)Experience with Redshift or other relational databasesConfident use of Python (Pandas, NumPy) and common visualisation librariesExperience working with large, heterogeneous datasetsExperiene in the insurance industry, preferably motor insurance Very good Excel skills, including Pivot Tables, VBA & macrosFluent English skills; good German skills are an advantageConfidence in international environments and in cross-functional collaborationDetail-oriented and independent working style as well as a proactive mindsetWhy join us?Growth is important to us, that’s why we support your personal and professional developmentCulture of trust, empowerment and constructive feedbackCollaboration with people from different countries and cultures32 days’ annual leave plus 2 days’ additional company holidaysFlexible working hours and generous working from home policyAttractive employee conditions for our car insuranceHealth management and pme Family serviceJob tickets, parking spaces, travel allowanceEmployer’s contributions (pension fund and capital-forming benefits, supplementary health insurance, occupational disability insurance)EGYM WellpassAllowance for lunchFree hot and cold beverages and a weekly fruit basketAbout usAt 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.  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.