Data Engineer - AWS, DBT & Snowflake - Pharmaceutical Project
🚀Do you want to become an ERNIan? You will find domain tech experts that collaborate in creating challenging solutions allowing you to develop yourself and work in the 🔝 of your technical expertise!
At ERNI, we’re looking for a Data Engineer to join a global initiative in the Pharma sector focused on building reliable, secure, and scalable data ecosystems. You’ll help transform complex operational data into actionable information that empowers business teams to make data-driven decisions. 🚀
At ERNI, you're part of a team, not just a project.
Even when working remotely, we make sure you stay connected and supported.
How do we ensure that? 🤔
From day one, you will have a mentor with you, who will guide you through your entire onboarding and career at ERNI. You’ll have regular 1:1 meetings with them, and recurrently, you’ll work on your development plan to define your short-, medium-, and long-term goals.
What will you do?
- You’ll be part of an international team responsible for developing and maintaining data pipelines and models that enable reliable data availability for analytics and decision-making.
- Designing and building pipelines to move data from Aveva PI Historian and Inmation to Snowflake (via Kafka or S3).
- Implementing TAG mapping between Aveva PI and Snowflake to ensure consistent data modeling.
- Developing and maintaining scalable data models for historian data in Snowflake.Optimizing data flows to ensure performance, security, and scalability across the ecosystem.
- Ensuring data integrity, reliability, and readiness for use by BI and analytics teams.
What are we looking for?
✅ Strong experience as a Data Engineer, with focus on building scalable pipelines and data models.
✅ Proficiency in AWS, Python, DBT, Snowflake, RDBMS, and Kafka.
✅ Proven experience in integrating and optimizing data ingestion and transformation processes.
✅ Knowledge of data modeling best practices and modern ETL architectures.
✅ Ability to work autonomously in a fully remote, global environment.
✅ Excellent communication and collaboration skills for cross-functional teamwork.
✅ Fluent English (spoken & written).
What do we offer?
🏥 Private health and travel insurance.
💯 Full coverage for sick leave + 1 extra day off per month without medical leave.
🧘♀️ Free emotional, legal, and family support.
☕ Snacks, fruit, coffee, and tea at the office.
🍽️ Monthly team lunches paid by the company.
🎉 Special days like "churro therapy" or "calamari sandwich day."
🏋️♀️ Gym discounts + sports compensation.
🧳 Relocation bonus (up to €2,000).
💳 Flexible benefits: meals, transport, childcare, etc.
🤝 Referral bonuses: up to €6,000 per candidate and €5,000 per client.
🖥️ Remote work compensation: hardware + home office expenses.
🌴 23 working days of vacation.
🗣️ Free language courses: English, Spanish, and German.
And the salary...
We will discuss it during the first call. If it’s important to you, feel free to ask! 💬
Also, if yo want to know what makes ERNI unique through the eyes of those who know it best 😎 Take a look at this video:
WOULD YOU LIKE TO BECOME AN ERNIan? APPLY NOW!
- Department
- Data & AI
- Role
- Data Engineer
- Locations
- Madrid, Barcelona
- Remote status
- Hybrid
- Seniority
- Professional
Colleagues
About ERNI Spain
ERNI is a Swiss Software Engineering company leader in building complex, customized software solutions. It’s more than 25 years of using technology to have a positive impact on people's lives.
We build digital solutions that connect the physical world (devices & connectivity) with the digital one (software solutions, connected, or consuming their data). Our teams are focused on prioritize the software lifecycle & to ensure that our code is both clean and secure. Our maturity in building high-impact software solutions approaches us whatever industry looking for quality and sophistication (e.g. Gaming, FMCG or Validation & Inspection..).
Our leadership in the Health-Tech (Diagnostic Medical Devices, Pharma, Health Care and more) and in all industries around Smart Devices (Robots, Cars, 3D Printers, Machinery), in a powerful combination with the way we growth people, let us create a growing, learning and challenging set up for ERNIans.
Already working at ERNI Spain?
Let’s recruit together and find your next colleague.