Senior Data Engineer

About the role

Roche's Engineering Excellence & Experience team, part of its RDT organization, builds and maintains the engineering platforms used by thousands of colleagues worldwide in a global, highly regulated (GxP) environment. The Senior Data Engineer leads, designs, develops and maintains scalable data pipelines and infrastructure, working with BI developers and business analysts. The position is based in Madrid.

Key responsibilities

• Design, implement and maintain enterprise data models (e.g. Data Vault 2.0, dimensional modeling) and evolve data warehouse schemas with enterprise architects.
• Lead end-to-end design, development and orchestration of batch and streaming pipelines with Talend (or similar ETL/ELT tools), Python and Java.
• Optimize cloud data warehouses such as Snowflake, writing complex SQL scripts, stored procedures and data transformations.
• Define data management practices (metadata, lineage, cataloging, lifecycle) and set up automated data quality, monitoring and alerting.
• Work with BI developers and business analysts to optimize data marts and query layers feeding Tableau, Power BI or similar dashboards.

Required profile

• 5+ years of hands-on experience in data engineering, data warehousing or a related field.
• Proven track record of independently building ETL/ELT processes and optimizing data storage solutions such as data warehouses and data lakes.
• Experience with large-scale data projects and ensuring data quality and reliability.
• Advanced English is a must; exposure to GxP or regulated environments is an advantage.

Required skills

• Expert SQL, Python and Java; Scala and Streamlit are a plus.
• Advanced Snowflake or comparable cloud data warehouse development and tuning.
• Talend or equivalent ETL/ELT tools (Informatica, Matillion, dbt).
• Data modeling, data governance, metadata tracking and data observability tools.