Analytics Engineer

We’ve been experiencing hyper-growth the past year, becoming Indonesia’s 7th Unicorn Startup and the first Investment Fintech Unicorn in South East Asia 2,5 years after Ajaib first launched. With the global financial technology market expected to grow gradually, we aim to make stock trading accessible for millennials through our mobile-first approach.  In 2022, we opened our new head office in the Indonesia Stock Exchange Building, and we’re just getting started!

The three principles, or what we call as 3DNAs became the foundation and set the guideline for the Magician belief system: Everyone is an owner, Growth Mindset, and A Will to Win.

Description

• Are you passionate about transforming raw data into actionable insights and ensuring data governance? We’re looking for an Analytics Engineer to join our innovative team at Ajaib!

Every team has its specialty and uniqueness, and our Technology team is no exception! In addition, our Technology team has its DNA that makes our team different and excels at what they do.

Impact Driven: We are driven to create products that not only focus on user experience but also make a social impact as a bigger purpose.

Craftsmanship: To us, building a product is an art. We carefully craft every detail of it and ensure we have a strong sense of ownership.

Pushing Boundaries: The comfort zone is not a place we want to stay in. We keep innovating to keep our minds sharp.

Responsibilities

• Build and maintain robust data models to power business metrics.
• Design and implement data quality checks.
• Optimize data transformations using DBT and ensure smooth operations in BigQuery.
• Apply dimensional modeling techniques to build scalable data warehouse solutions.
• Collaborate with data engineers and business teams to align data infrastructure with business goals.

What You’ll Work With

• Data Modeling & Quality: DBT, BigQuery
• Programming Languages & configuration: SQL, Python, YAML
• Visualization: Metabase
• Version Control: GitHub

Requirements

• Data Modeling: Experience with designing and implementing dimensional models.

• SQL: Mastery of SQL for complex queries and performance tuning.
• Python: Skilled in Python scripting for data transformations and automation.

Nice to have

• Experience with CI/CD tools like GitHub Actions or Jenkins.
• Advanced Python programming skills.
• Semantic Layer: Knowledge of semantic layer tools to make data accessible and meaningful.
• Data Quality: Hands-on experience for building data quality.