Data Engineer - PySpark & AWS - Pharma

ERNI; Madrid; Hybrid; EUR 45,000 - 70,000; Full time

Benefits offered by this job

Certifications reimbursement

Private health insurance

Sick leave coverage

Counseling support

Gym discounts

Flexible remuneration

Referral bonuses

23 vacation days

Language courses

Job summary

ERNI is seeking a Data Engineer to transform complex pharmaceutical data into scalable, automated solutions. You will leverage PySpark and AWS to enhance ETL pipelines from legacy systems, ensuring data is well-structured and accessible for business needs.

The role emphasizes collaboration with a supportive team, onboarding mentorship, and a hybrid work model with 2 days in the office. Strong English communication is required.

Qualifications

• Hands-on experience in Data Engineering and ETL pipelines.
• Proficiency in PySpark for data processing.
• Experience with AWS data services (S3, Glue).
• Fluent English and ability to translate business requirements into technical solutions.

Responsibilities

• Enhance and automate data extraction and transformation pipelines using PySpark and AWS.
• Develop, maintain and optimize ETL pipelines from legacy systems.
• Collaborate with technical teams and business stakeholders to deliver reliable data solutions.

Skills

Data engineering

PySpark

AWS data services

Data quality & security

Code maintenance

English fluency

Tools

Git

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!