Data Engineer - Pyspark & Aws - Pharma

Erni Spain; Madrid; Hybrid; EUR 48,000 - 70,000; Full time

Benefits offered by this job

Certification support up to €1,500

Private health insurance

Sick leave coverage

Emotional, legal and family support

Gym discounts

Flexible remuneration

Referral bonuses

23 vacation days

Language courses

Job summary

ERNI Spain is seeking a Data Engineer to transform complex pharmaceutical data into scalable, automated solutions. You will work on data extraction, transformation, and pipeline automation using PySpark and AWS, ensuring data is structured and accessible for business needs.

The role emphasizes collaboration, mentorship, and ongoing learning within a hybrid work model, with opportunities for training, certifications, and flexible remuneration. English fluency is essential.

Qualifications

• Hands-on data engineering experience building, maintaining, and improving ETL pipelines.
• Strong proficiency in PySpark for data processing, extraction and transformation.
• Proficiency with AWS data services (S3, Glue) and understanding of data quality, security, and performance optimization.

Responsibilities

• You will enhance and automate existing data extraction and transformation pipelines using PySpark and AWS, processing complex data from legacy systems.
• Develop parsing logic, automate data identification and structuring, and collaborate with technical teams and stakeholders to deliver reliable data solutions.

Skills

Data Engineering

PySpark

English communication

Analytical thinking

Tools

AWS (S3/Glue)

Job description

Can you imagine transforming complex pharmaceutical data into scalable and automated solutions?

Join our expert team to work on solutions in the Pharma sector, focused on improving and automating data extraction and transformation processes from complex legacy systems. You will apply your knowledge of PySpark, AWS and data engineering to enhance existing data pipelines, automate manual processes and ensure that data is accurately structured and accessible for business needs.

At ERNI, you are never just a number. Even if you work on an external project, you will feel part of the team and always supported.

How do we make this happen?

With people. Besides your team and manager, you will have several support figures like a godparent, who will help you with the practical and administrative aspects of daily life during your first 6 months.

And the second most important person after you, your mentor, who will guide you through your entire onboarding and career at ERNI. You will have regular 1:1 meetings with them, and recurrently, you will work on your development plan to define your short-, medium-, and long-term goals.

We strongly encourage growth and continuous training. Each person has an individual development plan, mentoring, and access to internal technical communities. We aim for you to learn, experiment, and evolve within an environment where teamwork and support from more senior colleagues are key.

What you will bring

• Hands-on experience in Data Engineering, including developing, maintaining and improving ETL pipelines.
• Strong proficiency in PySpark for data processing, extraction and transformation.
• Hands-on experience with AWS data services such as S3 and Glue
• Knowledge of data quality, data integration, security and performance optimization.
• Ability to understand, maintain and enhance existing code and data processing solutions.
• Strong communication skills, fluent English and the ability to translate business requirements into technical data solutions.

You will be responsible for enhancing and automating existing data extraction and transformation pipelines using PySpark and AWS, focusing on processing complex data from legacy systems. You will develop and improve parsing logic, automate the identification and structuring of data, reduce manual interventions and collaborate with technical teams and business stakeholders to deliver reliable, maintainable data solutions.

What if the project ends?

We work on a wide variety of projects, technologies, and sectors, allowing you to keep growing in different environments. If a project ends or you feel ready for a new challenge, we will find another one that aligns with your professional development.

Our working model

We ask you to be available for key meetings. Need to leave for a doctor's appointment or to pick up your child from school? No problem. We trust you to deliver quality work within your 40-hour workweek.

Our model is hybrid: we usually go to the office 2 days a week, though this depends on the project and team, but we love seeing each other's faces; the best stories always happen in the office!

You will also enjoy:

• We cover your certifications and reward technical achievements up to €1,500.
• Private health insurance.
• Full coverage for sick leave
• Free emotional, legal, and family support.
• Gym discounts or sports compensation.
• Flexible remuneration: meals, transport, childcare, etc.
• Referral bonuses: up to €6,000 per candidate and €5,000 per client.
• 23 working days of vacation.
• Free language courses: English, Spanish, Catalan and German.

And the salary?

We will discuss it during the first call. If it is important to you, feel free to ask!