Data Engineer - PySpark & AWS - Pharma

ERNI; Cataluña; Hybrid; EUR 45,000 - 70,000; Full time

Benefits offered by this job

Certifications paid

Private health insurance

Sick leave coverage

Emotional support services

Gym discounts

Flexible remuneration

Referral bonuses

Vacation days

Language courses

Job summary

ERNI in Spain's Catalonia region seeks a data engineer to transform pharmaceutical data into scalable, automated solutions. You will work on data extraction and transformation pipelines using PySpark and AWS, ensuring clean, accessible data for business decisions.

Join a supportive, hybrid team with mentors, growth opportunities, and a strong focus on training, certifications, and wellbeing. You will collaborate with cross-functional stakeholders to deliver reliable data solutions across complex

Qualifications

• 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.

Responsibilities

• Enhance and automate existing data extraction and transformation pipelines using PySpark and AWS.
• Collaborate with technical teams and business stakeholders to deliver reliable, maintainable data solutions.
• Assist in identifying and structuring data from complex legacy systems.

Skills

Data Engineering

PySpark

AWS (S3/Glue)

Data quality & integration

Code maintenance

English communication

Tools

ETL pipelines

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!