Senior Data Engineer

1609 Roche Farma, S.A.; Madrid; On-site; EUR 70,000 - 90,000; Full time

Job summary

Roche is seeking a Senior Data Engineer to design, build, and maintain scalable data pipelines and infrastructure. You will work with BI developers and analysts to deliver data solutions using Python, SQL, Java, and Snowflake in a regulated environment.

You will lead ETL/ELT efforts, ensure data quality and governance, and collaborate across globally distributed teams to enable advanced analytics and reporting with tools like Tableau, PowerBI, and Looker.

Qualifications

• 5+ years in data engineering or data warehousing with large-scale systems.
• Proficiency in SQL, Python, Java; Spark knowledge a plus.
• Experience with Snowflake or similar cloud data warehouses.
• Experience building ETL/ELT pipelines with Talend or equivalents.
• Strong data governance, metadata, and observability familiar.
• English advanced; other languages welcomed; exposure to regulated environments (GxP) a plus.

Responsibilities

• Design, implement, and maintain enterprise data models and data warehouses.
• Lead end-to-end batch and streaming data pipelines using Talend, Python, Java.
• Optimize Snowflake data warehouses for performance and cost.
• Define data management practices, metadata, data lineage, and quality frameworks.
• Collaborate with BI developers to optimize data marts for Tableau/PowerBI/Looker.

Skills

SQL

Python

Java

Scala

Data modeling

Data Vault 2.0

ETL/ELT

Snowflake

Data warehousing

Data pipelines

Education

Bachelor's degree in Computer Science or related field

Tools

Talend

Informatica

Matillion

dbt

Tableau

PowerBI

Looker

Job description

At Roche you can show up as yourself, embraced for the unique qualities you bring. Our culture encourages personal expression, open dialogue, and genuine connections, where you are valued, accepted and respected for who you are, allowing you to thrive both personally and professionally. This is how we aim to prevent, stop and cure diseases and ensure everyone has access to healthcare today and for generations to come. Join Roche, where every voice matters.

The Position

The Senior Data Engineer is responsible for leading, designing, developing, and maintaining scalable and robust data pipelines and infrastructure. This role involves independently building ETL/ELT processes, optimizing data storage solutions (such as data warehouses and data lakes), ensuring data quality and reliability, and monitoring data systems. You will collaborate closely with BI developers and business analysts to meet their specific data requirements, utilizing strong programming skills in Python, expert SQL knowledge, and proficiency in modern cloud data platforms such as Snowflake. The Engineering Excellence & Experience team, part of Roche's RDT organization, owns and evolves the engineering tooling landscape that supports software development across Roche. We are responsible for the platforms that thousands of colleagues rely on every day to plan, build, test and release software – including the Atlassian suite (Jira, Confluence), codebeamer, OpenPDM and AllureTestOps – in a global and highly regulated (GxP) environment. Our mission is to make it easy for engineering teams to do their best work: we run these platforms reliably at enterprise scale, we simplify and standardize how they are used, and we continuously improve the developer experience through automation and AI-enabled solutions. The team also drives strategic initiatives such as the migration of Jira from Data Center to Cloud and the rationalization of the wider engineering tooling portfolio. You will join a distributed, international team that combines deep hands-on platform engineering with close partnership with business stakeholders, Product Owners and software compliance colleagues.

Responsibilities

• Design, implement, and maintain enterprise data models using scalable methodologies (e.g., DataVault 2.0, dimensional modeling), and partner with enterprise architects to evolve data warehouse schemas, ensuring agility, auditability, and ease of expansion.
• Lead the end-to-end design, development, and orchestration of robust batch and streaming data pipelines using Talend (or similar enterprise ETL/ELT tools), Python and Java (e.g., custom Talend routines, components, or services).
• Optimize cloud data warehouses (such as Snowflake) for high performance, storage efficiency, and cost governance, writing complex, high-performance SQL scripts, stored procedures, and data transformations.
• Define and enforce data management practices (metadata management, data lineage, data cataloging, lifecycle management) and implement automated data quality, monitoring, and alerting frameworks that ensure data reliability and compliance with enterprise security standards.
• Collaborate directly with BI developers and business analysts to optimize data marts and query layers feeding into Tableau dashboards or similar data visualization platforms (e.g., PowerBI, Looker).

Qualifications

• Education / Experience
  5+ years of hands-on experience in data engineering, data warehousing or a related field. Demonstrated experience handling large data engineering projects and managing complex, large-scale data systems. Proven track record of independently building ETL/ELT processes and optimizing data storage solutions such as data warehouses and data lakes. Experience ensuring data quality, reliability, and monitoring data systems.
• Technical Skills
  Proficiency in programming languages such as SQL, Python, Java, or Scala, with high proficiency in Python for data processing, scripting, and pipeline automation. Familiarity with the Streamlit framework is a plus. Strong, expert knowledge of cloud data platforms and big data tools, including advanced SQL and in-depth development and performance tuning in Snowflake or comparable modern cloud data warehouses. Advanced capability to solve complex data ingestion and processing problems, and to optimize data flows for enhanced system performance.
• Data Modeling:
  Proven, hands-on experience designing data architectures. Experience with DataVault2.0 is highly valued, along with standard dimensional and relational modeling techniques.
• ETL/ELT Tools:
  Extensive production experience building and deploying data pipelines with Talend or equivalent data integration platforms (e.g., Informatica, Matillion, dbt).
• Data Visualization & BI:
  Practical experience supporting and integrating data layers for Tableau or similar self-service analytics tools.
• Data Management:
  Proven familiarity with data governance principles, data cleansing, metadata tracking, and data observability tools.
• Additional Qualifications
  Exceptional communication and collaboration skills, with the proven ability to engage effectively with both technical audiences (like BI developers and data analysts) and non-technical business stakeholders. Exposure to GxP or other regulated environments will be an advantage. English advanced level is a must. Any other language will be welcomed.

Who we are

A healthier future drives us to innovate. Together, more than 100000 employees across the globe are dedicated to advance science, ensuring everyone has access to healthcare today and for generations to come. Our efforts result in more than 26 million people treated with our medicines and over 30 billion tests conducted using our Diagnostics products. We empower each other to explore new possibilities, foster creativity, and keep our ambitions high, so we can deliver life-changing healthcare solutions that make a global impact. Let's build a healthier future, together.

Roche is an Equal Opportunity Employer. We believe it's urgent to deliver medical solutions right now – even as we develop innovations for the future. We are passionate about transforming patients’ lives. We are courageous in both decision and action. And we believe that good business means a better world. That is why we come to work each day. We commit ourselves to scientific rigor, unassailable ethics, and access to medical innovations for all. We do this today to build a better tomorrow. We are proud of who we are, what we do, and how we do it. We are many, working as one across functions, across companies, and across the world. We are Roche.