> Markdown version of [/jobs/ext/1494465-security-insights-and-automation-data-engineer](https://www.wearedevelopers.com/jobs/ext/1494465-security-insights-and-automation-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Security Insights and Automation Data Engineer - **Company:** Roche - **Location:** Madrid, Spain - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Artificial Intelligence, Big Data, Program Optimization, Computer Programming, Data Architecture, Information Engineering, Extract Transform Load (ETL), Data Structures, Data Systems, Data Warehousing, Python (Programming Language), Performance Tuning, Standard Sql, Security Information and Event Management, SQL Databases, Data Streaming, Tableau (Software), Talend, Business Intelligence Development Studio, Data Storage Technologies, Feature Engineering, Data Ingestion, Snowflake, Gitlab, Data Lakes, Software Version Control, Data Pipelines - **Published:** July 30, 2026 - **Apply:** https://www.jobleads.com/es/job/e4bda225d6db7ff1eca33ce64711a5244 ## About the Role * 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, Exceptional communication and collaboration skills, with the proven ability to engage effectively with both technical audiences (like data scientists) and non-technical business stakeholders. ## Description 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., * 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. ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [WeAreDevelopers LIVE - Modern DevOps for IoT Devices and More](https://www.wearedevelopers.com/videos/1805-wearedevelopers-live-modern-devops-for-iot-devices-and-more) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [Enabling automated 1-click customer deployments with built-in quality and security](https://www.wearedevelopers.com/videos/83-enabling-automated-1-click-customer-deployments-with-built-in-quality-and-security) - [Data Governance in the Era of AI](https://www.wearedevelopers.com/videos/1622-data-governance-in-the-era-of-ai) ## Related Articles - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)