Analytics Engineer: Data Warehousing & SQL Architect Jakarta

Suitmedia; Daerah Khusus Ibukota Jakarta; On-site; IDR 583,430,571 - 916,819,470; Full time

Job summary

A dynamic agency in Jakarta is seeking an Analytics Engineer to transform raw data into reliable datamarts. This role involves designing and implementing scalable SQL solutions and requires a Bachelor's degree in a quantitative field along with 3+ years of relevant experience. Ideal candidates will possess exceptional SQL skills and have a strong grasp of data architecture and optimization techniques. The position offers an opportunity to work in a fast-paced environment that empowers clients with high-quality data.

Qualifications

• Minimum of 3 years of professional experience as an Analytics Engineer, Data Engineer, or similar.
• Expert-level proficiency in SQL, including advanced concepts such as window functions and indexing.
• Experience with dimensional data modeling (star/snowflake schema).

Responsibilities

• Design, develop, and implement scalable SQL-based datamarts and data pipelines.
• Optimize complex SQL queries and data structures for performance and efficiency.
• Collaborate with analysts and stakeholders to understand data requirements.

Skills

SQL expertise

Data architecture

Data modeling

ETL/ELT tools

Analytical skills

Communication skills

Education

Bachelor's degree in Computer Science, Informatics Engineering, Statistics, Mathematics, or a related field

Tools

Snowflake

BigQuery

AWS Redshift

ETL/ELT tools (e.g., Airflow, dbt, Fivetran)

Git

Job description

A dynamic agency in Jakarta is seeking an Analytics Engineer to transform raw data into reliable datamarts. This role involves designing and implementing scalable SQL solutions and requires a Bachelor's degree in a quantitative field along with 3+ years of relevant experience. Ideal candidates will possess exceptional SQL skills and have a strong grasp of data architecture and optimization techniques. The position offers an opportunity to work in a fast-paced environment that empowers clients with high-quality data.