Data Analyst

MODENA; Jakarta Selatan; On-site; IDR 167.196.000 - 250.795.000; Full time

Job summary

A data-driven company in Jakarta Selatan seeks a Data Analyst to prepare and analyze data for dashboard visualizations and reports. The role demands strong analytical skills, proficiency in Python and SQL, and a minimum of 2 years of related experience. Responsibilities include designing database structures, performing ETL processes, conducting data analysis, and developing dashboards for stakeholders. This position offers a chance to collaborate with cross-functional teams and maintain data quality.

Qualifications

• Minimum of 2 years of experience as a Data Analyst or Data Engineer.
• Proven experience with SQL (Snowflake, PostgreSQL, or equivalent).
• Hands-on experience in ETL/ELT and data pipelines.

Responsibilities

• Develop optimal database structures to support the Data Warehouse.
• Extract, transform and load data into the Data Warehouse.
• Perform data cleansing to ensure integrity and consistency.
• Conduct data analysis using statistical and business intelligence techniques.
• Develop interactive dashboards for business stakeholders.

Skills

Proficiency in Python scripting

Advanced SQL skills

Strong quantitative and analytical capabilities

Experience with data visualization tools

Education

Bachelor’s degree in Computer Science, Information Systems, Mathematics, Statistics, or a related field

Tools

Snowflake

PostgreSQL

Apache Airflow

Power BI

Tableau

Job description

Job Purpose

To prepare and analyze data for the development of dashboard visualizations and corporate reports, in line with company procedures and requirements. This role demands strong analytical skills, proficiency in data tools, and the ability to deliver reports that support effective decision-making at MODENA.

Key Accountability Areas

1. Design Database Structure
   • Develop optimal database structures to support the Data Warehouse.
2. Perform ETL & ELT Processes
   • Extract data from various sources.
   • Transform data to meet analytical requirements.
   • Load data into the prepared Data Warehouse.
   • Maintain and schedule ETL processes using Apache Airflow.
3. Data Cleansing
   • Perform data cleansing to ensure integrity and consistency.
4. Data Analysis
   • Conduct data analysis using statistical and business intelligence techniques.
   • Deliver insights to support strategic business initiatives.
5. Dashboard & Reporting
   • Develop interactive dashboards for business stakeholders.
   • Generate reports tailored to business needs.

Freedom to Act

• Collaborate with key users and cross-functional teams in building and optimizing the Data Warehouse and analytics solutions.
• Responsible for maintaining data quality, consistency, and security.

Qualification Requirements

1. Education: Bachelor’s degree in Computer Science, Information Systems, Mathematics, Statistics, or a related field.
2. Experience:
   • Minimum of 2 years of experience as a Data Analyst or Data Engineer.
   • Proven experience with SQL (Snowflake, PostgreSQL, or equivalent).
   • Hands-on experience in ETL/ELT and data pipelines, especially Apache Airflow.
3. Mandatory Skills:
   • Proficiency in Python scripting.
   • Advanced SQL skills (query optimization, joins, aggregations).
   • Strong knowledge of data cleansing and data validation practices.
   • Experience with data visualization tools (Power BI, Tableau, or equivalent).
   • Strong quantitative and analytical capabilities.
4. Preferred / Nice to Have:
   • Understanding of cloud infrastructure (Azure, AWS, GCP) or data infrastructure (Data Lake, Data Warehouse, Data Mart).
   • Familiarity with modern data stack technologies (Snowflake, Kafka, Airflow, dbt, etc.).
   • Knowledge of additional scripting languages (R, Shell) is a plus.