Data Warehouse Engineer

Are you passionate about building great products? Do you want to redefine the way travellers explore the world? Are you looking to work with one of the coolest technology companies in the region? Keen to be part of this growth journey with a bunch of amazing people? Then Pelago is the place for you

We are looking for an ambitious and motivated **Data Warehouse Engineer **who is excited about staying on the cutting edge of Technology and always keen on innovating new ways to drive the business performance through data and insights.

**WHO ARE WE?**

Pelago is an Itinerary focused Travel Marketplace that makes every aspect of a Trip - from Discovery & Organising to Booking & Experiencing - easy, fun and personalised

Backed by Singapore Airlines, the company is currently in pre-launch stage, and well-positioned to disrupt the $250 Billion travel experiences industry.

We are a team of diverse, passionate, empowered, inclusive, authentic and open individuals who share the same values and strive towards a common goal

**WHAT CAN WE OFFER YOU?**
- A unique opportunity to take ownership of building business with products and data insights that deliver real value to travellers.
- Platforms to solve real customer problems concerning travel planning & booking with innovative products/services.
- An amazing peer group to work with, and ability to learn from the similarly great minds around you.
- An opportunity to be an integral part of shaping the company’s growth and culture with a diverse, fun, and dynamic environment with colleagues from different parts of the world.
- Competitive compensation and benefits - including work flexibility, insurance, and more

**WHAT WILL YOU DO?**

We are looking for an experienced Data Warehouse Engineer to create and manage the data warehouse for Pelago. You will be responsible for designing data pipelines to collate and store data from multiple databases to the Data Warehouse. This data will serve as the single source of truth for all analytical and engineering needs - generating analytic reports, decision making, data science etc. You will be a part of the wider Engineering team.
- Act as the owner of the data Warehouse
- Modeling, maintenance and security of the Data Warehouse including determining data storage needs and data mappings
- Build out scalable and reliable ETL pipelines and processes to ingest data from a large number and variety of data sources
- Executing ETL performance tuning and data integration maintenance
- Work closely with data scientists and analysts to ensure data availability for all use cases such as data science, dashboarding, reporting, etc.

**WHAT EXPERTISE YOU NEED TO HAVE?**
- A degree or higher in Computer Science, Electronics or Electrical Engineering, Software Engineering, Information Technology or other related technical disciplines
- Deep expertise with SQL on analytics (OLAP) databases (preferably Redshift, Snowflake, or similar database)
- Experience in transforming data model requirements into Data solutions
- Experience with robust and efficient cloud-based data warehouse/data lake operation
- Deep understanding of databases and best engineering practices - include handling and logging errors, monitoring the system, understanding how to scale up, and knowledge of database administration
- Experience working with Event Streaming platforms like Kafka (preferred), Kinesis etc. is a plus
- Passionate about data, new data technologies, and discovering new and interesting solutions to the company’s data needs
- Excellent communication skills to communicate with the product development engineers to coordinate development of data pipelines, and or any new features that can be built on top of the results of data analysis
- Experience coding in Python