Data Engineer - SQL AWS - Data Platform Migration
Have you dreamed of making an impact in a global environment that values curiosity, innovation, and growth? If this sounds like you, welcome, you’re already an ERNIan 🚀.
Can you imagine modernizing a Data Platform architecture in AWS using advanced SQL? 🚀🚀
Join our expert team to work on a cloud-native Data Platform modernization project, contributing to the migration of legacy pipelines into a new SQL-driven architecture. You will apply your knowledge of advanced SQL, AWS services and data modeling to optimize performance, improve scalability and ensure reliable business data consumption.
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 🤝
• 5+ years of experience in Data Engineering within cloud-native environments.
• Strong expertise in advanced SQL including analytical functions, query tuning and performance optimization.
• Proven experience refactoring or migrating pipelines from Python-based transformations to SQL-driven workloads.
• Hands-on experience with AWS services such as S3, Athena, Redshift and Lambda.
• Solid knowledge of Docker, Git workflows and testing frameworks such as pytest.
You will be responsible for accelerating the migration of legacy Data Lake pipelines into a modern AWS-based architecture. Refactoring Python transformation logic into optimized SQL workloads and implementing Redshift views for business consumption.
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,400.
🏥 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.
🏋️♀️ Gym discounts + 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! 💬
WOULD YOU LIKE TO BECOME AN ERNIan? APPLY NOW! 🚀
- Department
- Data & AI
- Role
- Data Engineer
- Locations
- Madrid, Barcelona
- Remote status
- Hybrid
- Seniority
- Senior
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.