Senior Data Engineer Bayer’s Vegetable R&D Engineering and Automation Hub

Job title:

Senior Data Engineer Bayer’s Vegetable R&D Engineering and Automation Hub

Company:

Bayer

Job description

At Bayer we’re visionaries, driven to solve the world’s toughest challenges and striving for a world where ,Health for all, Hunger for none’ is no longer a dream, but a real possibility. We’re doing it with energy, curiosity and sheer dedication, always learning from unique perspectives of those around us, expanding our thinking, growing our capabilities and redefining ‘impossible’. There are so many reasons to join us. If you’re hungry to build a varied and meaningful career in a community of brilliant and diverse minds to make a real difference, there’s only one choice.Senior Data Engineer Bayer’s Vegetable R&D Engineering and Automation HubPosition Overview:We are seeking a talented and highly motivated individual with a strong technical engineering background and relevant experience to join Bayer’s Vegetable R&D Engineering and Automation Hub as a Senior Data Engineer. The Engineering and Automation Hub carries out a mission to create data-driven end-to-end digital workflows that improve operational efficiency and support predictive breeding for the R&D organization.The ideal candidate will have strong expertise in working with Big Data technologies like Google BigQuery and experience implementing ETL processes to manage data pipelines efficiently. You will play a crucial role in developing and maintaining key projects in the Vegetable R&D portfolio. This involves collaborating with a diverse group of global cross-functional scientists, engineers, developers, plant breeders, and IT teams.YOUR TASKS AND RESPONSIBILITIES

• Developing, and troubleshooting SQL queries on Google BigQuery, as well as designing scalable ETL pipelines using technologies like Metaflow and Python.
• Oversee database management by optimizing SQL queries, implementing effective indexing strategies, and conducting regular performance tuning to enhance overall efficiency and responsiveness.
• Establish materialized views for performance optimization, and create data quality checks and validation procedures to ensure data integrity
• Monitor, troubleshoot, and document data pipeline issues, implementing error handling and recovery mechanisms as needed.
• Develop comprehensive data archiving and retention policies that balance storage efficiency, compliance requirements, and cost-effectiveness, utilizing tiered storage solutions and automated lifecycle management techniques.
• Write clean, maintainable code following team standards, Bayer, and industry best practices. This includes writing comprehensive unit tests, participating in code reviews, and engaging in agile scrum development practices.

WHO YOU ARE (Education/Experience)

• Bachelor’s degree in computer science, software engineering, or a related discipline plus minimum of 5 years of experience
• Proven experience building large-scale data pipelines for production applications.
• History of working in Agile Scrum teams

SKILLS (Technical & Soft)

• Strong expertise working with Google BigQuery, with advanced skills in SQL optimization, database performance tuning, data modeling, and using materialized views for enhanced efficiency.
• Proven experience building ETL pipelines using AWS data services (e.g., RDS, Lambda, Step Functions) and orchestration frameworks like Metaflow or Airflow.
• Familiarity with data streaming patterns and technologies like Apache Kafka.
• Proficient in writing unit tests using frameworks (e.g Pytest).
• Experience with version control systems (e.g., GitHub) and working with CI/CD pipelines (GitHub Actions).
• Excellent verbal and written communication skills, with the ability to work independently and collaboratively.
• Strong attention to detail and commitment to code quality.

YOUR APPLICATIONThis is your opportunity to tackle the world’s biggest challenges with us: Maintaining our health, feeding growing populations and slowing the rate of climate change. You have a voice, ideas and perspectives and we want to hear them. Because our success begins with you. Be part of something big. Be Bayer.Bayer welcomes applications from all individuals, regardless of race, national origin, gender, age, physical characteristics, social origin, disability, union membership, religion, family status, pregnancy, sexual orientation, gender identity, gender expression or any unlawful criterion under applicable law. We are committed to treating all applicants fairly and avoiding discrimination.Location:Spain : Cataluña : BarcelonaDivision:Enabling FunctionsReference Code:835672

Expected salary

Location

Barcelona

Job date

Sat, 01 Feb 2025 05:42:37 GMT

To help us track our recruitment effort, please indicate in your email/cover letter where (vacanciesin.eu) you saw this job posting.