Analytics Engineer

About Amber (amberstudent.com):

Long-term accommodation booking platform for students (think booking.com for student housing). Amber helps 80M+ students worldwide, find and book full-time accommodations near their universities, without the hassle of negotiation, non-standardized and cumbersome paperwork, and broken payment process. We are the largest and fastest-growing student housing platform globally, with 1M+ units listed in 6 countries and across 100+ cities. We are growing rapidly and targeting $2Bn in annual gross bookings value by 2024.

If you are passionate about making international mobility and living seamless and accessible, then - Join us in building the future of student housing!

(We are amongst the fastest growing companies in the Asia Pacific as per Financial Times https://www.ft.com/high-growth-asia-pacific-ranking-2022)

Key Responsibilities: 

As a Data Engineer:

• Design, develop, and optimize our data pipelines and ETL processes.

• Maintain and enhance our Redshift data warehouse, ensuring efficient query performance,        scalability,glue and uptime.

• Collaborate with cross functional teams to integrate data from various sources into our warehouse.

• Monitor Redshift upmetrics, improve query execution times, and reduce errors to ensure high availability and reliability. Implement best practices for data governance, security, and data quality.

As a Data Analyst:

•  Translate complex data into actionable insights for stakeholders across departments.

•  Create dashboards and reports to visualize key performance indicators (KPIs) and business metrics.

•  Perform ad hoc data analysis to support business decisions.

•  Analyze data trends and provide recommendations to optimize business strategies and operations.

•  Work closely with leadership to ensure data driven decisions are made in alignment with business goals.

Requirements: 

Experience: 2-3 years in Data Engineering and/or Data Analytics roles.

Skills Required: 

Skills in Data Engineering:

•  Proficiency in SQL, ETL pipelines, and database management.

•  Strong experience with cloud based data warehouses, particularly Amazon Redshift.

•  Familiarity with data orchestration tools like Airflow or DBT.

•  Knowledge of Python or similar programming languages for data processing.

Skills in Data Analytics:

• Strong analytical skills with experience in data modeling and visualization tools (e.g., Tableau, Power BI, or Looker).

• Ability to derive actionable insights from large datasets.

• Experience working with key business metrics and KPIs.

• Bonus: Experience with AWS services, Spark, or other big data tools.

• Excellent problem solving skills and the ability to adapt to a fast paced environment.

• Strong communication skills to work cross-functionally with technical and nontechnical teams.

Why Join Us?

Impact: You’ll play a key role in driving data centric decisions across the organization.

Growth: Opportunities to develop your skills and take on leadership responsibilities as we grow.

Culture: A dynamic, supportive, and inclusive environment where collaboration is key.