Data Analytics Engineer

PT Ako Media Asia; Jakarta Barat; On-site; IDR 200.000.000 - 300.000.000; Full time

Job summary

A leading tech company in Indonesia is seeking a Data Analytics Engineer to enhance data processes and support AI initiatives. The role requires a Bachelor's degree in Data Science or a related field, along with at least 1 year of experience in data engineering. Key skills include SQL, Power Query, and relational database design. This position offers opportunities to work on innovative projects in a dynamic environment.

Qualifications

• 1 year of experience in analytics engineering, data engineering, or advanced data analytics.
• Strong skills in SQL, Power Query, and Excel data transformation.
• Experience designing relational databases or cloud-based data warehouses.
• Familiarity with BI tools (Power BI, Tableau) and ETL tools.
• Knowledge of Python or R for data manipulation is a plus.
• Understanding of AI/ML concepts for analytics is an advantage.
• Understanding of software engineering best practices.
• Strong problem-solving and stakeholder communication skills.

Responsibilities

• Consolidate, clean, and prepare datasets from existing Excel sources.
• Build and maintain ETL/ELT pipelines for data preparation and integration.
• Design scalable data models optimized for dashboard performance.
• Develop a roadmap to migrate from Excel to a structured database.
• Design data input mechanisms for process-driven data.
• Collaborate with business units for new data capture methods.
• Prepare datasets for AI-powered queries.
• Translate business KPIs into structured data models.
• Communicate technical solutions in business-friendly language.

Skills

SQL

Power Query

Excel data transformation

Relational databases design

BI tools (Power BI, Tableau)

Python or R for data manipulation

AI/ML concepts for analytics

Software engineering best practices

Problem-solving

Stakeholder communication

Education

Bachelor’s degree in Data Science, Computer Science, Information Systems

Tools

SQL Server

MySQL

PostgreSQL

ETL tools

Job description

Consolidate, clean, and prepare datasets from existing Excel sources into analytics-ready formats.

Build and maintain ETL/ELT pipelines to automate data preparation and integration.

Design and document scalable data models optimized for dashboard performance and AI readiness.

Develop the roadmap to migrate from Excel-based data to a structured database or cloud data warehouse.

Design data input and collection mechanisms to capture structured, process-driven data at the source.

Collaborate with business units to integrate new data capture methods into daily workflows.

3. Analytics & AI Enablement

Prepare datasets and metadata to support AI-powered natural language queries.

Translate business KPIs into structured data models and calculation logic.

Work closely with developers to ensure dashboards and automation tools are fed with accurate, consistent data.

Act as the link between Process Improvement Design and Development teams.

Communicate technical solutions in business-friendly language.

Guide stakeholders through the adoption of new data processes and tools.

Requirements:

1. Bachelor’s degree in Data Science, Computer Science, Information Systems, or related field.
2. 1 year of experience in analytics engineering, data engineering, or advanced data analytics.
3. Strong skills in SQL, Power Query, and Excel data transformation.
4. Experience designing relational databases or cloud-based data warehouses (SQL Server, MySQL, PostgreSQL).
5. Familiarity with BI tools (Power BI, Tableau) and ETL tools.
6. Knowledge of Python or R for data manipulation is a plus.
7. Understanding of AI/ML concepts for analytics (NLP, predictive modeling) is an advantage.
8. Understanding of software engineering best practices and version control.
9. Strong problem-solving and stakeholder communication skills.

What is your expected monthly basic salary?

Which of the following qualifications do you have?

How many years' experience do you have as a Data Analytics Engineer?

How many years' experience do you have using SQL queries?

SALT is a Digital Transformation Company focusing on Marketing Technology, offering services such as Digital Technology Platform Development, Website/Mobile Apps Development, CRM, Chatbot (Machine Learning), Data Science, Technology Consulting, UX/UI, and Design Systems.

Our goal is to be the leading and most innovative technology company in Indonesia, serving clients from large companies to enterprises.

We have helped clients develop sustainable marketing ecosystem platforms to improve revenue and operational efficiency. Our staff are highly trained professionals with international and local experience.