Senior ETL Developer - Data Migration Specialist

beBeeDataMigration; Madrid; Presencial; EUR 45.000 - 65.000; Jornada completa

Descripción de la vacante

A dynamic data solutions provider based in Madrid is looking for an ETL Developer to enhance data migration and integration efforts across insurance systems. You'll design robust ETL processes, optimize data workflows, and work closely with stakeholders to ensure seamless data transitions. The ideal candidate has significant ETL experience, advanced SQL skills, and a collaborative approach to problem-solving. This role offers opportunities for professional development and engagement in a supportive work culture.

Servicios

Social and sporting activities

Inclusive work environment

Formación

• 3-5+ years as an ETL Developer focused on data migration projects.
• Proficient in leading ETL tools and advanced SQL querying.
• Understanding of data warehousing and relational database design.

Responsabilidades

• Design and maintain ETL processes for data migration.
• Analyze source system data and collaborate on technical solutions.
• Develop and execute test plans for ETL workflows.

Conocimientos

ETL Development

Data Migration

SQL

Collaboration

Data Quality Assurance

Herramientas

Informatica PowerCenter

Talend

Azure Data Factory

AWS Glue

SQL Server Integration Services (SSIS)

Python

Bash

Oracle DB

SQL Server

PostgreSQL

Descripción del empleo

Overview

Job Title : ETL Developer

We are seeking a highly skilled and motivated ETL Developer to join our Data Management team. In this role, you will play a key part in the successful delivery of data migration and data integration solutions across core insurance systems.

Responsibilities

• Design, develop, and maintain robust ETL processes to support data migration and / or data integration from legacy systems to modern core insurance platforms.
• Analyze and profile source system data to understand structures, relationships, and quality issues across insurance-related domains such as policies, claims, billing, and customer information.
• Collaborate with Business Analysts and Data Architects to interpret data mapping specifications and convert business requirements into efficient technical solutions.
• Implement complex data transformations, cleansing routines, and validation rules to ensure high-quality and consistent data in the target environment.
• Develop, execute, and document comprehensive test plans for ETL workflows, including unit testing, integration testing, and support during User Acceptance Testing (UAT).
• Optimize ETL performance for handling large volumes of insurance data and ensure scalability and efficiency of the data pipeline.
• Troubleshoot and resolve data migration issues, discrepancies, and ETL performance bottlenecks across different phases of the project.
• Build and maintain stored procedures, views, and advanced SQL queries to support both migration and reporting needs.
• Work closely with DBAs, infrastructure teams, and application developers to ensure seamless integration and data flow across systems.
• Contribute to project delivery by adhering to timelines, maintaining high-quality technical documentation, and participating in project planning and reviews.

Required Skills

• Proven experience as an ETL Developer (typically 3–5+ years), with a strong focus on data migration projects.
• Proficiency in one or more leading ETL tools such as Informatica PowerCenter, Talend, Azure Data Factory, AWS Glue, or SQL Server Integration Services (SSIS).
• Solid understanding of data warehousing principles, dimensional modeling, and relational database design.
• Advanced SQL skills for data querying, transformation, and validation across various RDBMS platforms (e.g., Oracle, SQL Server, DB2, PostgreSQL).
• Experience with scripting languages (e.g., Python, Bash, Perl) for automation tasks and implementing complex data transformations is highly desirable.
• Familiarity with insurance industry data domains (e.g., policies, claims, underwriting, billing, client data) and business processes is a strong advantage.
• Knowledge of data quality frameworks, cleansing techniques, and best practices in data validation.
• Ability to interpret data mapping specifications and implement corresponding ETL logic efficiently.
• Strong analytical and troubleshooting skills with a high level of attention to detail.
• Excellent interpersonal and communication skills, with the ability to collaborate effectively with cross-functional teams.
• Experience with cloud platforms (e.g., Oracle Cloud Infrastructure, AWS, Azure, or Google Cloud Platform) and their associated data services is a plus.

Why Join Us?

Our company blends hands-on insurance expertise with fresh thinking from the worlds of technology consulting, financial services, ecommerce and beyond. We combine the agility of a start up with the security and scale of a corporate. The result is a pragmatic-yet-pioneering approach that we\'ve used to help clients reimagine central market systems, launch self-service digital insurance products, automate regulatory reporting requirements and more.

Our people are truly valued and encouraged to enjoy a host of social and sporting activities available. Quiz nights, tennis tournaments, football matches and a range of other events take place throughout the year.

Here at our company, we are proud to be an Inclusive Employer. We provide an environment of mutual respect with zero tolerance to discrimination of any kind regardless of age, disability, gender identity, marital / family status, race, religion, sex or sexual orientation.