Data Engineer, CarTrawler
6 Month Fixed Term Contract
2-5 days a week in office
Car rental & mobility solutions
Be an early applicant
Car rental & mobility solutions
201-500 employees
Be an early applicant
2-5 days a week in office
201-500 employees
Company mission
To enable the world's leading brands in travel to offer better transport services to their customers.
Role
Who you are
- 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
What the job involves
- 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
- 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
Our take
CarTrawler provides car rental and mobility solutions to travel industry players, enabling them to supplement their revenue and improve the experiences of their customers. It runs what is essentially a B2B marketplace for car rentals, through which airlines and travel agents can offer their clients end-to-end travel options.
Like many of its travel industry peers, the company has felt the pinch in recent years due to the after-effects of the pandemic and the cost-of-living crisis. Despite this, CarTrawler has remained positive that it can capture further success in the new-look economy. It has continued to pursue new partnerships and expand its North American presence, already boasting a network of key players including United Airlines, easyJet, Uber, Emirates and Hotels.com.
Freddie
Company Specialist at Welcome to the Jungle
Insights
3% employee growth in 12 months
Company
Funding (1 round)
May 2020
$118.4m
GROWTH EQUITY VC
Total funding: $118.4m
Company benefits
- 25 days annual leave, plus company days
- “Friday Unplugged” – last Friday of every month we have a half-day mental health break day
- Maternity & paternity leave, wedding leave & parents leave
- Bespoke career pathing platform
- Online behavioural & technical academy
- Diversity, Inclusion & Belonging seminars
- Hybrid working model
- Modern, open plan offices just a stone’s throw from Dublin City Centre
- Chill Out Room – designed to give our employees a relaxation space during their work day
- Free weekly yoga classes, VHI online fitness classes, weekly tennis, running and 5-a-side football
- Charity runs
- Pension scheme
- Comprehensive VHI health insurance
- In-house health screenings
- Optional flu vaccinations
- Income protection & life assurance
- New mothers’ lactation room
- We have several employee cohorts across the business that you can become a part of, such as Sports and Social Club, Corporate Social Responsibility Committee, Engagement Champion Network, etc
- Travel Tax Saver Schemes for rail and bus
- On-demand ride-hailing app with discounts exclusively for CarTrawler employees
- Bike to Work scheme and secure bike storage
Company HQ
Farranboley, Dublin, Ireland
Leadership
Peter O'Donovan
(CEO)Previously the COO of Cartrawler, CPO at Paddy Power and Betfair and Non-Exec Director at Mick's Garage.
Salary benchmarks
We don't have enough data yet to provide salary benchmarks for this role.
Submit your salary to help other candidates with crowdsourced salary estimates.
Share this job
View 7 more jobs at CarTrawler