Snowflake Data Engineer - Advanced English

Ditech Group; Madrid; Híbrido; EUR 55.000 - 85.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Hybrid work model

2 days in office, 3 days remote

Descripción de la vacante

Databricks is seeking a Data Engineer to design and build scalable data pipelines for analytics and AI workloads in Madrid. You will integrate diverse sources, optimize data models, and prepare datasets for ML and RAG systems, leveraging SQL, Python, Spark, and AWS data services.

You will collaborate with Data & Development teams, ensuring data quality and efficient infrastructure, with a hybrid schedule (2 days in office, 3 days remote).

Formación

• Hands-on data engineering experience with large-scale datasets.
• Experience building data pipelines for analytics and ML workflows.
• Strong SQL and Python programming, with cloud data services exposure.

Responsabilidades

• Design, build, and maintain scalable data pipelines for analytics and ML workloads.
• Model, transform, and optimize data for reporting and insights.
• Collaborate with data scientists, engineers and stakeholders to deliver value.
• Implement data quality, monitoring, and automation using modern tooling.
• Work with Hadoop, Spark, Databricks, Airflow and cloud platforms.

Conocimientos

SQL/PL-SQL

Python (pandas, PySpark)

Apache Spark

ETLs

AWS services

Spanish & English

Educación

Advanced degree in Computer Science

Herramientas

Hadoop

Spark

Databricks

Airflow

Anaconda

Snowflake

Descripción del empleo

• Databricks

The role

• Build data pipelines: integrate diverse sources (HTML, CSV, relational databases, embeddings) using scalable ETLs.
• Modeling and optimization: design analytical models to generate KPIs and efficiently manage large data volumes.
• Enable AI: prepare datasets for ML, LLMs, and RAG systems, integrating AI for natural language queries.
• DataOps and scalability: apply CI/CD, continuous monitoring, and optimize infrastructure.
• Learn as much as you want about the world of alternative investment

What we\'re looking for

• Results-oriented with strong technical ownership.
• Around 3-4 years of experience.
• Relevant experience with SQL / PL-SQL
• Relevant experience with Python (pandas, Pyspark) and Apache spark
• Relevant experience with ETLs & E/R models
• Relevant experience working with Data & Development teams
• Experience with AWS services (EMR, Lambdas,…) or similar Cloud
• Fluency in Spanish and English

This gives extra points

• Basic experience with data science environments
• Basic experience with Vector database and with scraping engines
• Work with multi-country and multi-source data.
• Experience working in with financial data

What we offer

• 25 days of vacation (and your birthday off!)
• Hybrid mode: 2 days in office 3 days in remote
• If interested, please email

Data Engineer - Renowned Company - Travel Required

We are looking for talented Data Engineers with a passion for big-data technologies and building robust data solutions that support advanced analytics.

This is an opportunity to work with modern data technologies, solve complex technical challenges and collaborate with both technical teams and clients.

Key Responsibilities

• Design and build scalable data solutions for advanced analytics.
• Develop and maintain data pipelines and data processing solutions.
• Work with large and complex datasets.
• Apply big-data technologies to solve technical and analytical challenges.
• Develop efficient and reliable solutions using modern programming languages.
• Work with technologies such as Hadoop and Spark .
• Write high-quality code using Python, Java, SQL and/or Scala .
• Support machine-learning and advanced analytics initiatives.
• Collaborate with data scientists, software engineers and other technical teams.
• Communicate technical solutions and ideas effectively with colleagues and clients.
• Continuously evaluate and improve data engineering processes and technologies.

About You

You\'ll ideally have an advanced degree in Computer Science or equivalent technical experience, together with a strong interest in big-data technologies.

You should have:

• Hands-on experience building data solutions for advanced analytics.
• Strong knowledge of big-data technologies such as Hadoop and Spark .
• Strong programming skills in Python, Java, SQL and/or Scala .
• Experience working with large-scale data environments.
• Knowledge of data processing and data pipeline development.
• Familiarity with advanced analytics and machine-learning tools.
• Experience with tools such as Anaconda and Spark .
• Strong analytical and problem-solving abilities.
• Excellent collaboration and communication skills.
• Intellectual curiosity and willingness to work outside your comfort zone.

If you\'re passionate about data engineering, big data and advanced analytics , apply now to discuss the opportunity.

• Experience: 3+ years in Data Engineering, including 2+ years leveraging AWS data analytics solutions.
• Core Technical Stack: Python, SQL, and PySpark / Apache Spark.
• Cloud & Infrastructure: Hands-on expertise with AWS Data Services, Docker, and AWS ECS.
• Orchestration: Experience building and managing data pipelines using Apache Airflow.
• Languages: Professional fluency in both Spanish and English (written and spoken).

Nice-to-Have Skills

• Data Processing & Streaming: Apache Kafka, Databricks, and dbt (data build tool).
• BI & Development: QlikView / Qlik Sense and Java programming.
• Methodology: Experience working in Agile/Scrum environments.

Are you a Data Engineer seeking a new interesting challenge ?

If your answer is yes, it\'s your lucky day so keep reading, it can be just what you\'re looking for !

We are looking for a dynamic, proactive and talented person to join our team and perform the following tasks :

• Design, build, and maintain scalable, automated data pipelines using Python and SQL to integrate diverse internal and external data sources into the Snowflake Data Cloud.
• Model, transform, and structure complex datasets to optimize data accessibility, performance, and storage efficiency.
• Develop and maintain robust API integrations and connectors to ensure seamless data flow across enterprise systems.
• Implement testing, monitoring, and validation frameworks to guarantee high data integrity, reliability, and accuracy across all pipelines.
• Monitor, troubleshoot, and optimize data pipeline performance and Snowflake resources while enforcing robust security and access controls.

WHAT TECHNOLOGIES WILL YOU USE?

• Python
• SQL
• Snowflake
• Databricks
• Airflow
• Minimum 3 years of experience as a Data Engineer or in similar roles, designing, building, and maintaining scalable data pipelines and ETL/ELT solutions.
• Hands-on experience with Python, SQL, Snowflake, and cloud-based data platforms, with a strong focus on data modeling, integration, quality, and performance optimization.
• English: Professional working proficiency.

WHERE AND WHEN?

• Workplace: TCS Madrid
• Work Schedule: Business Hours
• Permanent contract - We offer indefinite contracts from the first day.
• Pay and benefits - Competitive salary and a flexible compensation plan adapted to your needs (Ticket restaurant plan, Childcare Ticket, Transport Ticket and Health Insurance).
• Work from home - We offer you a financial support every month for your working from home expenses . In addition, in the first month we will give you a bonus to help you to set up your workplace
• Opportunity knocks - Being a part of a growing company, we want to support your path with a career development plan and annual performance-based compensation reviews .
• Learn as you grow - Starting with a fantastic onboarding program , TCS has robust learning platforms that will allow you to learn and grow personal as professionally.
• Bring your buddy - If you have referred a friend for an open position under the BYB Scheme and she/he is hired you\'ll receive a very attractive cash award.
• Connect globally - Work with people from all over the world . You can feel the multicultural workforce .
• Benefit from being a TCSer ️ – By being part of the TCS Spain family you can enjoy benefits, offers and corporate discounts on the best brands .
• And so on - Appreciations, incentives, Team Building activities, diversity and inclusion programs, sustainability activities, corporative events. This has only just begun!

WHO ARE WE?

Tata Consultancy Services (TCS) is an Information Technology (IT) company founded in 1968 as part of the Indian Tata Group and is one of the top 3 technology companies globally

With a presence in 55 countries and more than 590,000 employees , TCS is considered one of the 10 best companies to work for worldwide in 2026 according to the Top Employers Institute

TCS Spain started operations in 2001 and currently has a diverse workforce that collaborates with the main Spanish and multinational companies

In 2026, TCS Spain has been recognized as a Top Employer , named one of the 100 Best Companies to Work for in Spain by Forbes , and ranked among the most attractive employers for Generation Z by Joinrs

Among the portfolio of services, TCS has information technology services , asset-based solutions , global consulting , engineering and industrial services , digital solutions and services , application maintenance and development , quality assurance and testing services , IT infrastructure and BPS

Responsible for development , TCS Spain is committed to inclusion, diversity and sustainability , and promotes flexibility policies that support wellbeing and work-life balance

WELCOME, WE ARE WAITING FOR YOU!

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
• 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\u2019s 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º de la Castellana, 95 – Planta Madrid (SPAIN) or send an email to the following address We will ask you to confirm your identity if we need to, we have one month from receiving your request to tell you what action we have taken.

Mandatory Skills

• 3+ years of Data Engineering experience
• 2+ years of Data Analytics experience on AWS
• Python
• SQL
• AWS Data Services
• Airflow (Data Pipeline Orchestration)
• Docker & ECS
• Spanish and English communication skills

Preferred Skills

• Kafka
• dbt
• Databricks
• Java
• QlikView / Qlik Sense
• Agile / Scrum