Senior Data Engineer

Philip Morris; Madrid; Presencial; EUR 35.000 - 65.000; Jornada completa

Descripción de la vacante

Una empresa innovadora está buscando un ingeniero de datos para liderar la transformación hacia productos sin humo. En este papel, tendrás la oportunidad de establecer estándares de ingeniería de datos, diseñar sistemas complejos y crear flujos de trabajo ETL automatizados. Con un enfoque en la calidad de los datos y la integración de diversas fuentes, contribuirás a un futuro más saludable. Ofrecemos un entorno de trabajo flexible, atención médica privada y beneficios adicionales, lo que te permitirá avanzar en tu carrera mientras impactas positivamente en el mundo.

Servicios

Atención médica y dental privada

Seguro de vida

Tarjeta de almuerzo Sodexo

Modelo de trabajo híbrido

Programa multisport

Cafetería con diversos beneficios

Estacionamiento gratuito para bicicletas y coches

Formación

• 3-5 years of experience in data warehouse projects and ETL processes.
• Proficiency in SQL and understanding of Snowflake architecture.

Responsabilidades

• Setting data engineering standards and overseeing complex data systems.
• Designing automated pipelines for ETL from various data sources.

Conocimientos

ETL Processes

Data Warehousing

SQL

Basic AWS Services

Python

CI/CD frameworks

Educación

Bachelor's degree in Computer Science

Bachelor's degree in Information Technology

Herramientas

Snowflake

AWS EC2

AWS Lambda

Bitbucket

Jenkins

Descripción del empleo

MAKE HISTORY WITH US! At PMI, we've chosen to do something incredible. We're totally transforming our business and building our future on smoke-free products with the power to deliver a smoke-free future. With huge change comes huge opportunity. So, wherever you join us, you'll enjoy the freedom to dream up and deliver better, brighter solutions and the space to move your career forward in endlessly different directions.

Roles and Responsibilities:

• Setting data engineering standards and best practices.
• 3-5 years' experience working in data warehouse projects.
• Overseeing the architecture and development of complex data systems.
• Knowledge of data quality, data lineage, and compliance requirements.
• Effectively communicating technical details to non-technical stakeholders.
• Responsible for designing automated pipelines that handle the ETL of data from various sources into storage systems.
• Manage a DWH (Snowflake), ensuring it's optimized for performance and data integrity.
• Integrating data from diverse sources, such as APIs, DBs, and flat files, ensuring smooth integration and consistent data quality.

Required Skills:

• ETL Processes: Proficiency in designing and implementing ETL (Extract, Transform, Load) workflows.
• Data Warehousing: Deep understanding of Snowflake's architecture, including data type, collation, virtual warehouses, micro-partitions, and clustering.
• SQL: Advanced SQL skills for querying, data manipulation, and performance tuning.
• Basic AWS Services: Understanding of EC2, Lambda, and other relevant services for data engineering.
• Python: For scripting, automation, and data manipulation.
• Experience in creating pipelines using established CI/CD frameworks in the cloud (e.g., AWS specific CI/CD skills that include Bitbucket, Jenkins, ...).

Degree Requirements:

• At least a bachelor's degree in computer science, information technology, or a related field.

WHAT WE OFFER YOU?

• Private medical and dental care, life insurance.
• Lunch Sodexo card to be used in the canteen or outside.
• Office or hybrid working model with flexible working arrangements.
• Multisport program.
• Cafeteria with various benefits.
• Free bike and car parking for all employees.

Please note that only online applications will be taken into consideration.