Data Enginner & Analyst

PT Samudera Caraka Jasa; Jakarta Utara; On-site; IDR 200.000.000 - 300.000.000; Full time

Job summary

A logistics and data integration company located in Indonesia is looking for a Data Engineer to develop and maintain ETL/ELT pipelines and manage business intelligence dashboards using Power BI. The ideal candidate will have a Bachelor's degree in a relevant field and 3–5 years of experience in data engineering or business intelligence. Responsibilities include integrating external data sources, ensuring data quality, and conducting analyses to provide actionable insights to senior management. Remote working options are available.

Qualifications

• 3–5 years of experience in data engineering, analytics, or business intelligence.
• Experience in integration of external data sources (APIs, logistics platforms).
• Knowledge of freight forwarding services and related KPIs is an advantage.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines.
• Lead the design and development of business intelligence dashboards.
• Conduct deep-dive analyses on operational efficiency and financial performance.

Skills

SQL Proficiency

Data Visualization (Power BI)

Data Analysis

ETL/ELT Pipeline Development

Advanced DAX

Education

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

Tools

Microsoft Power BI

Job description

Responsibilities

Pipeline Development: Design, develop, and maintain robust ETL/ELT pipelines to accurately extract, transform, and load diverse datasets—including shipment data, sales & marketing performance, comprehensive financials, and truck/container asset utilization—into the centralized data warehouse.

External Data Integration (NEW): Design and implement processes to acquire and integrate data from external sources, such as public APIs, third-party logistics platforms, or market rate providers, to enrich internal datasets.

Data Modeling: Apply data warehousing principles (e.g., star schema) to model complex freight forwarding data, ensuring high data quality, consistency, and efficient query performance for reporting.

Data Governance: Ensure the integrity, security, and cleanliness of data sources, primarily using advanced SQL scripting for data manipulation and validation.

Source Management: Troubleshoot and optimize data ingestion from various source systems, including direct connections to the ERP system and management of crucial Excel files.

Develop and maintain cross-department dashboards (finance, commercial, trucking, operations, HR, etc).

Dashboard Development: Lead the design, development, and maintenance of professional, interactive business intelligence dashboards and reports primarily using Microsoft Power BI.

Extract and process weekly commercial booking/shipment data for Power BI, provide insights through historical data analysis and forecasting, and monitor commercial KPIs through to incentive/commission finalization.

Advanced Analytics: Conduct deep-dive analysis on key business areas, such as: Operational Efficiency: Analyze shipment transit times, identify bottlenecks in specific transport modes (FCL/LCL, FTL/LTL), and calculate asset utilization rates; Financial Performance: Analyze profitability per shipment, dissect operational costs, and perform margin analysis on sales data; Sales Insights: Evaluate market trends and assess the performance of sales & marketing initiatives.

Insight Generation: Translate complex analytical findings into clear, concise, and actionable recommendations for senior management and operational teams to optimize routes, pricing, and asset deployment.

Technical Reporting: Utilize advanced features within Power BI, including mastering the DAX language, to create sophisticated measures and calculations.

Requirements

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

3–5 years of experience in data engineering, analytics, or business intelligence.

Strong proficiency in SQL for data manipulation, validation, and governance.

Expertise in Microsoft Power BI or other data visualization tools, including advanced DAX and dashboard/report development.

Familiarity with ERP systems and integration of external data sources (APIs, logistics platforms, market rate providers).

Ability to perform deep-dive analysis on operational efficiency, financial performance, and sales/marketing initiatives.

Knowledge of freight forwarding services (Ocean FCL/LCL, Air, Road FTL/LTL) and related KPIs is a significant advantage.

Self-driven, detail-oriented, and capable of owning end-to-end analytical infrastructure.