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 Roches 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. Data Vault 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. Power BI 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 Data Vault 2.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 integral impact.
Lets build a healthier future together.
Roche is an Equal Opportunity Employer.
Required Experience:
Senior IC
📌 Senior Data Engineer (Madrid)
🏢 Roche
📍 Madrid
Postulate a este anuncio
Muestra tus habilidades a la empresa, rellenar el formulario y deja un toque personal en la carta, ayudará el reclutador en la elección del candidato.