Data Engineer - Security Insights And Automation

Roche & Company; Madrid; Presencial; EUR 70.000 - 90.000; Jornada completa

Descripción de la vacante

Roche is seeking a Data Engineer for Security Insights and Automation to design and maintain scalable data pipelines within the DataOne ecosystem. You will build ETL/ELT processes, optimize storage, ensure data quality, and collaborate with data scientists to deliver robust data products in a data mesh environment.

Key responsibilities include end-to-end pipeline engineering, transforming security telemetry for predictive modeling, and enabling executive-level insights through Tableau and

Formación

• Experience handling big-sized data engineering projects and large-scale data systems.
• Proven track record building ETL/ELT processes and optimizing data warehouses/datalakes.
• Experience ensuring data quality, reliability, and monitoring data systems.
• Strong SQL & Snowflake expertise; data modeling and performance tuning.

Responsabilidades

• Data Architecture & Pipeline Engineering: design, build, and maintain scalable pipelines using Talend, dbt, and Python.
• Security Intelligence: transform telemetry and vulnerability data for predictive modeling and risk scoring.
• Stakeholder Management: collaborate with business units and data scientists to meet data needs.
• Visualization & Insights: support Tableau and ThoughtSpot visualizations with optimized data schemas.
• System Optimization: optimize Snowflake tables and schemas; lead large-scale data engineering initiatives.

Conocimientos

SQL

Snowflake

Python

dbt

Talend

Tableau

ThoughtSpot

API integration

Herramientas

Talend

dbt

Gitlab

Tableau

ThoughtSpot

Snowflake

Descripción del empleo

Data Engineer - Security Insights and Automation

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 Security Insights and Automation Data Engineer is responsible for leading, designing, developing, and maintaining scalable and robust data pipelines and infrastructure within the Roche's DataOne ecosystem. 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 data scientists and analysts to meet their specific data requirements, implementing decentralized Data Products following Data Mesh principles, utilizing strong programming skills in Python, expert SQL knowledge, and proficiency in big data technologies like Snowflake.

Job Responsibilities:

Data Architecture & Pipeline Engineering: Leads the design, build, and maintenance of scalable end-to-end data pipelines using Talend, dbt, and Python. Ensure all architectures are scalable, secure, and aligned with the Data Mesh standards. .

Security Intelligence Support: Transform raw security telemetry and vulnerability data into high-quality feature sets for predictive modeling, anomaly detection, and automated risk scoring. .

Stakeholder Management: Engages directly with broader business units and data scientists to thoroughly understand and meet their data needs. Communicates effectively with both technical and non-technical stakeholders.

Visualization & Insights: Support the mastery of Tableau and ThoughtSpot by ensuring underlying data structures and schemas are optimized for intuitive executive narratives and self-service analytical apps.

System Optimization: Solve complex data ingestion problems and perform expert-level Snowflake table optimizations and schema designs. Leads high-impact, large-scale data engineering initiatives by implementing robust strategies and integrating complex, diverse infrastructures to ensure seamless organizational data flow.

Qualifications Education / Experience

Demonstrated experience handling big-sized 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

Expert SQL & Snowflake: Advanced proficiency in designing Snowflake data structures, schemas, and performance optimizations.

Advanced Programming: Expert-level Python or Scala for data engineering and Gitlab for version control and orchestration.

Modern Data Stack: Hands-on experience with dbt for transformation and Talend for integration.

Data Mesh & AI/ML: Solid understanding of decentralized Data Mesh principles and preparing data for AI/ML initiatives (e.g., feature engineering).

BI Tooling: Technical capability to support advanced visualizations in Tableau and ThoughtSpot.

API Integration: Expertise in consuming and exposing APIs to integrate security insights across the enterprise ecosystem

Additional Qualifications Exceptional communication and collaboration skills, with the proven ability to engage effectively with both technical audiences (like data scientists) and non-technical business stakeholders.

Who we are

A healthier future drives us to innovate. Together, more than 100'000 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.