ETL Developer
16 hours ago
Madrid
Background Digital innovation is reshaping the insurance industry - We’re making it happen.Charles Taylor InsureTech was established to help insurance businesses drive change through the delivery of technology enabled solutions. We don’t have a one-size-fits-all approach or prescriptive methodology. We work consultatively with our clients to revitalise their operations, reinvent established processes and implement future-ready solutions that deliver measurable benefit and improve data-driven decision making. Charles Taylor is a global provider of professional services and technology solutions dedicated to enabling the global insurance market to do its business fundamentally better. Dating back to 1884, Charles Taylor now is currently in more than 120 locations spread across 30 countries in Europe, the Americas, Asia Pacific, the Middle East and Africa. Charles Taylor believes that it holds a distinctive position in its markets in that it is able to provide professional services and technology solutions in order to support every stage of the insurance lifecycle and every aspect of the insurance operating model. Charles Taylor serves a diversified blue-chip international customer base that includes national and international insurance companies, mutuals, captives, MGAs, Lloyd's syndicates and reinsurers, along with brokers, distributors and corporate insureds. Charles Taylor has three distinct business areas – Claims Services, InsureTech and Insurance Management. Charles Taylor was recently acquired by an investment company managed and controlled by Lovell Minnick Partners LLC. Lovell Minnick is a US Private Equity firm that invests in the global financial services industry, including related technology and business services companies, with a focus on helping to build long term value for clients, employees and shareholders.The acquisition will support the continuation of Charles Taylor's successful growth strategy, with a focus on expanding client relationships, broadening specialist capabilities and the range of services and technology solutions, deepening geographic coverage, and reinvesting in quality of service and technology. For more information, please visit ___ For more information, please visit The Role Charles Taylor InsureTech is seeking a highly skilled and motivated Senior 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. You will be responsible for designing and implementing robust ETL processes, ensuring the accurate and efficient movement of large volumes of data from legacy platforms to modern target systems, while also supporting downstream data consumption for reporting and analytics. The ideal candidate brings deep hands-on experience with ETL tools, strong SQL and scripting skills, and a passion for clean, reliable, and high-quality data. You will work closely with Business Analysts, Data Architects, and Technical Leads to translate complex business and data requirements into scalable, high-performance ETL solutions. Key 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., • Bachelor’s degree in Computer Science, Information Technology, or a related field—or equivalent practical experience., • Fluency in English, both written and spoken, is required. Why join Charles Taylor InsureTech? The Charles Taylor InsureTech team blends hands-on insurance expertise with fresh thinking from the worlds of technology consulting, financial services, ecommerce and beyond. As a newly established business which is part of Charles Taylor, 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. We are very proud of the fact that nine out of ten of our people recommend Charles Taylor as a place to work. We pride ourselves on having a positive work environment where our people are empowered to make the best decisions and where learning is valued highly and shared across our business. We are very committed to ensuring our people are given continuous learning and development. As well as structured induction programmes and job training, we provide study support for relevant professional qualifications and have a Core Learning & Development Curriculum. Charles Taylor is a fun and inclusive place to work where 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 Equal Opportunity Employer Here at Charles Taylor 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. Our external partnerships and the dedicated work we do in promoting a transparent and fair recruitment and selection process all contribute to the successful, inclusive and diverse culture and environment which we are proud to be a part of at Charles Taylor.
Waiters
Sales & Marketing
Chef & Cook
Retail
Salon & Beauty
Construction & Trades
Accounting & Finance
Animal Care
Art, Media, Design
Bar Staff
Barista
Child Care
Cleaning
Driver & Delivery
Education
Engineering
Entertainment
Events & Promotion
Fashion
Healthcare
Information Technology
Kitchen Porter
Legal
Management
Manufacturing
Office & Admin
Security
Sports & Wellness
Other
Page 2