Data Engineer (Fixed Term Contract)

The Company:From our roots in Ireland, CarTrawler has grown into the leading B2B technology provider of car rental and mobility solutions to the global travel industry. If you’ve ever booked a flight and seen the option to rent a car, that was probably us; but it’s our people that make everything we do possible – and we’re growing!
At CarTrawler, you’ll find more than just a job. You’ll find flexibility, meaningful impact, and a culture built by the people who live it every day. Our culture is built on high performance, genuine connection, and a shared commitment to making an impact, without sacrificing personal wellbeing. With flexible working models, meaningful time off, and dedicated growth opportunities, we enable people to do great work and feel good doing it. 
We have a hybrid working policy with two mandatory days a week in our Dublin office, you have the freedom to design a routine that supports your productivity and personal life. The office offers ample car parking, a heavily subsidized (KC Peaches) canteen, convenient proximity to the Luas, and access to EV charging stations.
Role Purpose:We are seeking a Data Engineer on a 6 month fixed term contract to develop and maintain our Snowflake data warehouse and data marts, designing and optimizing ETL processes and data models to ensure accuracy and scalability. The role requires strong skills in SQL, Python, and stored procedures, with hands-on use of Snowflake, Airflow MWAA, Soda, and DBT. Working closely with Data Engineering and wider P&T teams, you will build secure, high-performing data solutions that support business-critical initiatives. 

Responsibilities & Accountabilities

• Build & Optimize Data Pipelines: Design, construct, and maintain robust, scalable ETL/ELT pipelines using dbt and Airflow to integrate new data sources and manage changes to SQL jobs.  
• Troubleshooting issues with existing SQL/ETL processes and data loads to drive to solution. 
• Design and build extensible data models and integration solutions using various tools such as Snowflake functionality, Airflow, Soda, DBT, AWS s3.  
• Implement and enforce best practices for data quality, testing, and documentation to ensure data is accurate, consistent, and trustworthy.  
• Continuously optimize our Snowflake data warehouse, refining data models and architecture to improve query performance, scalability, and cost-efficiency. 

Skills & Experience Required

• 3+ years of experience in a Data Engineering or similar role. 
• Hands-on experience with building data pipelines, data models and implementing data quality. 
• Experience accessing and manipulating structured and semi-structured data(JSON) in various cloud data environments. Any of the following technologies Snowflake, Redshift, Hadoop, Spark, Cloud Storage, AWS, consuming data from APIs. 
• Expert proficiency in Python(or scala) for data manipulation and scripting, advanced SQL and database stored procedures for complex querying and data modelling. 
• Experience with orchestration and monitoring tools such as Airflow 
• Solid understanding of ETL/ELT design patterns, data modelling principles and database architecture.  
• Experience of full stack development, implementing continuous integration and automated tests e.g.  GitHub, Jenkins 
• Proven ability to work creatively and analytically in a fast-paced, problem-solving environment. 
• Excellent communication (verbal and written) and interpersonal skills. 
• Proven ability to communicate complex analysis in a clear, precise, and actionable manner 

Research shows that individuals from underrepresented backgrounds often hesitate to apply for roles unless they meet every single qualification, while others may apply when they meet only a portion of the criteria. If you believe you have the skills and potential to succeed in this role, even if you don't meet every listed requirement, we encourage you to apply. We'd love to hear from you and explore whether you could be a great fit.