4 February

Head of Data Warehouse Team - Europ Assistance s.r.o.

Europ Assistance s.r.o. is part of the international financial group Generali and Česká pojišťovna and has been setting trends in the assistance services market for more than 50 years. Since 1963, we have been providing services to clients around the world - 24 hours a day, 7 days a week. We are a provider of comprehensive assistance services and insurance claims settlement services.

We are looking for an experienced leader to manage a team of datawarehouse specialists within our EE region. In this role, you will be responsible for the accuracy and timely delivery of regular statistics to business partners as well as for DWH team development.

Key Responsibilities

  • Managing and Expanding Data IT team located in different countries of the Region;
  • Overseeing the integration of data into the enterprise data warehouse, collaboration with department heads to ensure accurate and relevant reporting data;
  • Acting as the main point of contact for communication with EA branches and external suppliers regarding the development and maintenance of the data warehouse;
  • Participation in the development of unified reporting tools, statistics and dashboards across whole EE Unit;
  • Working closely with the IT department to continuously improve automation, efficiency, and the quality of reported information;
  • Overseeing the administration of the MSSQL database, including the design, creation and maintenance of data structures necessary for reporting;
  • Ensuring accurate and timely generation of daily, weekly, and monthly statistics and analyses for all EA departments, as well as reports based on Helpdesk requests;
  • Taking direct responsibility for meeting deadlines for regular statistical reports sent to business partners;
  • Ensuring consistency and correctness of all statistical output.

Requirements

  • Advanced knowledge in Data Warehouse designs and ETL processes.
  • Advanced SQL expertise, stored procedures, query optimization, and performance tuning
  • Experience working in Microsoft Azure environments, including Azure-based SQL solutions (Azure SQL Database/instance (PaaS), Data Factory)
  • Reporting using SQL, including SQL Server Reporting Services (SSRS) and Power BI reporting
  • Process automation using SQL Server Integration Services (SSIS)
  • Additional scripting Power shell, php etc.
  • Fluent in English (spoken and written)

We Offer

  • Work in an experienced and supportive team
  • Real influence on project and team development
  • Flexible working hours and remote work options
  • Training budget and access to educational platforms
  • Benefits package (cafeteria, sports card, etc.)

Benefits

Educational courses, training, Meal tickets / catering allowance, Holidays 5 weeks, Sick days, Contribution to sport / culture / leisure, Cafeteria, Individual schedules of working hours, Corporate events, Bonuses, Flexible start/end of working hours, Contributions to the pension / life insurance, Self-organization of the job, Discount on company products / services

About the Job

Type of Employment:
Full-time work
Type of Contract:
Employment contract
Recommended education:
Secondary education or professional training with a school-leaving exam
Recommended languages:
Czech (Advanced), English (Advanced)