Data Engineer

Intact Insurance Europe; Comunidad de Madrid; Presencial; EUR 42.000 - 64.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Flexible work arrangements

Time-off benefits

Professional development

Descripción de la vacante

Intact Insurance Europe is seeking a data analyst who will develop and maintain MI reporting, building insights to support decision making and business growth across Europe. You will work in the Change & Continuous Improvement team to translate requirements into robust BI solutions using Power BI, SQL and data modelling.

Collaborating with IT and business units, you will drive automation, ensure data quality, and deliver dashboards and KPIs that reveal trends and opportunities while maintaining

Formación

• Strong experience with Power BI, DAX, Power Query and SQL.
• Expertise in data modelling, reporting and KPI development.
• Ability to translate business requirements into impactful reporting solutions.
• Strong stakeholder management and communication skills.
• Experience driving continuous improvement and reporting automation.

Responsabilidades

• Develop, maintain and continuously improve Power BI dashboards, reports and data visualizations.
• Analyse financial and business data to identify trends, anomalies and opportunities.
• Collaborate with stakeholders to define reporting needs and KPIs.
• Lead data and reporting projects and support forecasting/portfolio mix analysis.
• Produce regular or ad hoc reports to meet internal demand and ensure clarity for audiences.

Conocimientos

Power BI

SQL

DAX

Power Query

Data modelling

KPI development

Herramientas

Python

Tableau

Power Automate

Qlik

Descripción del empleo

Our employees are at the heart of what we do: helping people, businesses and society prosper in good times and be resilient in bad times. When you join our team, you are bringing this purpose to life alongside a passionate community.

Feel empowered to learn and grow while being valued for who you are. At Intact Insurance, we commit to supporting you in reaching your goals with tools, opportunities, and flexibility. It’s our promise to you.

Who we are

At Intact Insurance, we are experts at what we do in protecting what makes businesses unique. Our deep understanding of the specialty insurance market is the foundation for our customized solutions, backed by targeted risk control and claims services. Our employees are passionate about providing insurance coverage that’s aligned to our targeted customer groups.

Across Europe, our footprint includes offices in France, Spain, Belgium and the Netherlands, supported by a dedicated team of around 300 professionals.

The opportunity

This job involves developing and delivering Management Information (MI), providing key trends and better MI developments whilst supporting best practice. The role involves producing intelligence/insights to better serve decision making and outcomes to help grow Intact Insurance Europe.

You will work within Intact Insurance Europe Change & Continuous Improvement team to help shape the needs and requirements of the business to support better MI and data quality. You will be responsible for reviewing existing reporting, providing recommendations on potential technical enhancements and new MI solutions. The role strongly focuses on the development, maintenance and continuous improvement of reporting solutions and involves forming and maintaining a strong relationship within organizational functions to capture all data and MI needs and priorities to provide a clear picture of business performance.

You will be responsible for delivery of identified improvements for MI, insight/analytics, to defining solutions and implementing sustainable delivery. This includes driving reporting solutions from data preparation and validation through modelling, visualization, implementation and ongoing maintenance. The role is key to driving consistency across our business to improve efficiency & ensure that the right work is done in the right place with the right controls & at the right cost.

Specific remit aligns to:

• The role connects with the business through MI and aims to influence various functions across Intact Insurance Europe in their decision making, ensuring the right business outcomes from data visualization
• The individual will have a strong knowledge of information management and analysis background, working with the various functions to gain understanding of the various Intact Insurance business units
• The role is responsible for the accurate production and delivery of existing BAU reports– this includes regular review and refinement to ensure fit for purpose, as well as identifying opportunities for automation and continuous improvement.
• The individual will work with necessary IT functions where required to enable better technology and capabilities, to help unify data from a variety of both internal and external sources

Your role will evidence a culture of continuous improvement, supporting standardization to allow for informed decision making at exec level. This will require you to understand the people aspects of change– from change readiness to the way people receive the change and the strategies needed to ensure that people adopt the new ways of working.

In this role you will collaborate closely with the Sales, Underwriting, Operations, Finance and HR leadership.

You will also interact with business stakeholders across all functions & branches (across jurisdictions). You will provide operational expertise and consultancy capability to drive and deliver operational effectiveness and benefits in line with strategic and operational plans.

This role requires an experienced business-focused Data analyst with a proven track record of optimized delivery aligned to operational effectiveness. The ability to combine strong analytical and BI capabilities with practical, hands-on approach to delivering reporting solutions, influence key stakeholders to secure buy in and develop the plans required to execute targeted outcomes will be key to success.

Some Data Engineer responsibilities include but are not limited to:

• Improve data quality and reliability through analysing raw data, developing and maintaining datasets and reporting solutions.
• Play key role in development of Annual Operating plan and Business Reviews with accurate, timely reporting and insights.
• Develop, maintain and continuously improve Power BI Dashboards, reports and data visualizations, ensuring they provide relevant and actionable information for business reporting.
• Analyse financial and business data and information using proven statistical and other analytical techniques to identify trends, anomalies, gaps and opportunities
• Partner with stakeholders to define reporting needs and develop dashboards and KPIs.
• Lead data and reporting projects, both part of company-wide initiatives and as part of the team, as well as standalone projects.
• Support forecasting “as if” analysis and Portfolio Mix selection.
• Produce regular or ad hoc reports to meet the needs of internal customers and stakeholders, within agreed timescales.
• Ensure information, analysis and interpretation is clear, unambiguous, comprehensible and appropriate for the audience and business purpose.
• Drive reporting automation and process improvements using data, AI and emerging technologies.
• Collaborate with IT and Data teams to improve reporting capabilities and data integration.
• Support the continuous improvement of data, reporting and analytics capabilities.

Functional / technical skills:

• Strong experience with Power BI, DAX, Power Query and SQL
• Expertise in data modelling, reporting and KPI development
• Ability to translate business requirements into impactful reporting solutions
• Strong stakeholder management and communication skills
• Experience driving continuous improvement and reporting automation

Desirable Skills:

• Python, R, Microsoft Power Automate, Tableau or Qlik
• Experience working with financial, insurance or underwriting data
• Exposure to AI, robotics or advanced automation solutions

Why choose Intact

We live our Values:

We are committed to acting with the highest of ethical standards through our five core values: integrity, respect, customer driven, excellence and social responsibility.

Our commitment to Diversity:

Founded in our values, we see diversity as a strength and aspire to create an environment where everyone can be themselves, grow and succeed. Together, we will stand up for what’s right to build an inclusive society.

Manage your Time:

What you accomplish matters more than hours in the office. We are committed to creating a positive and supportive environment in which you perform your best. Our Time-Off and Flexible Work Arrangement options help foster a healthy work-life balance. What you accomplish matters more than hours in the office. We are committed to creating a positive and supportive environment in which you perform your best. Our Time-Off and Flexible Work Arrangement options help foster a healthy work-life balance.

About Intact

As part of Intact Financial Corporation (IFC) – Canada’s largest Property & Casualty insurer, with nearly CAD$24 billion in annual direct premiums and a global team of 31,000 employees – we bring global strength, deep expertise, and a strong focus on customers.

Intact Insurance Europe is part of IFC’s Global Specialty Lines business (GSL) which represents 3,500 professionals dedicated to more than 20 niche segments. GSL operates across North America, the UK, and Europe, and benefits from a strong international network covering over 150 territories – with clear profitable growth ambitions to reach $10 billion in operating DPW by 2030, performing at a sub-90 operating combined ratio.

Intact Insurance (Europe) S.A. is committed to ensuring that your privacy is protected, as the data controller, we take the necessary measures to ensure the security and confidentiality of the personal information it holds or processes in compliance with the General Data Protection Regulation (EU) of 27 April 2016 ("GDPR") and the Ley Orgánica 3/2018, de 5 de diciembre, de Protección de Datos Personales y garantía de los derechos digitales. The data you provide will be processed as part of our candidate selection process. The legal basis for this processing is our legitimate interest in considering your application. Unless you object, your CV will be kept for two years after our last contact with you. We may kept your data for the duration of the employment contract in the event of recruitment. Once your employment has ceased, your personal data will be only retained for as long as is necessary to satisfy any legal, accounting or reporting obligations. Intact Group companies and third-party partners may be recipients of your personal data when required. Sometimes your personal information may be sent to other parties outside of the European Economic Area (EEA) in connection with the purposes set out above. We will take all reasonable steps to ensure that your personal information is treated securely and in compliance with data protection regulations.

In accordance with data protection laws, you have the right to access and obtain a copy of the data concerning you, object to the processing, have it rectified or deleted. All you have to do is write to the Intact Insurance (Europe) Data Protection Officer to the following address Intact Insurance (Europe) S.A. Edif. Torre Europa, Pº