Data Engineer - AWS & Snowflake - Pharma sector

ERNI - Swiss Software Engineering; Barcelona, Madrid; Hybrid; EUR 60,000 - 95,000; Full time

Job summary

ERNI in Spain is seeking a senior Data & Analytics engineer to design and maintain scalable cloud data platforms. You will apply Python, SQL, AWS data services, Snowflake, dbt and Airflow to deliver reliable data solutions that power analytics and BI.

This hybrid role values mentorship and teamwork, with a structured onboarding and ongoing development. Expect 40-hour weeks, two in-office days, and opportunities to influence architecture decisions.

Qualifications

• Strong experience with Python and SQL.
• Hands-on experience with AWS data services, Snowflake, dbt, and Apache Airflow.
• Knowledge of data warehousing, data modeling, and cloud based architectures.
• Experience working with Git and CI/CD practices.
• Experience building and maintaining ETL/ELT pipelines.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT pipelines using AWS services and Airflow.
• Optimize data models in Snowflake and dbt and ensure data quality.
• Collaborate with analysts and data teams to deliver trusted datasets for analytics and BI.
• Mentor teammates and participate in architectural decisions.

Skills

Python

SQL

Git

CI/CD

Data Warehousing

Data Modeling

Cloud Architecture

ETL/ELT

Tools

AWS data services

Snowflake

dbt

Apache Airflow

Job description

Ready to build scalable cloud data platforms that power analytics and business intelligence??

Join our expert team to work on a Data & Analytics project, contributing to the development of scalable cloud data platforms and modern data pipelines. You will apply your knowledge of AWS, Snowflake, dbt, Apache Airflow, Python, and SQL to deliver reliable, high quality data solutions that support analytics initiatives.

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.

At ERNI, we highly value experience and technical knowledge. As a senior profile, you will have the space to continue growing, whether by deepening your technical skills or having greater influence on project decisions, with autonomy and the opportunity to share knowledge with other experts.

And if you are interested in mentoring, there is also space for that: supporting other ERNIans while still focusing on the technical excellence that sets us apart.

What you will bring

• Strong experience with Python and SQL.
• Hands on experience with AWS data services, Snowflake, dbt, and Apache Airflow.
• Knowledge of data warehousing, data modeling, and cloud based architectures.
• Experience working with Git and CI/CD practices.
• Experience building and maintaining ETL/ELT pipelines.

You will be responsible for designing, developing, and maintaining scalable ETL and ELT pipelines using AWS services while building reliable workflows with Apache Airflow. You will optimize data models in Snowflake and dbt, implement data quality and monitoring practices, and collaborate with analysts and data teams to deliver trusted datasets for analytics and business intelligence.

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.

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:

And the salary?

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