Analytics Engineer Staff

PT Delta Food Distribusi (Jakarta); Jakarta Timur; On-site; IDR 200.000.000 - 300.000.000; Full time

Job summary

A leading distribution company in Jakarta is seeking a Data Engineer to manage API data collection and data integration from internal systems like ERP and CRM. The ideal candidate holds a Bachelor's degree and has at least 2 years of experience in data engineering with Microsoft technologies such as SQL Server and PowerBI. The role includes creating data audits and translating business needs into effective data designs. This is a fantastic opportunity to contribute to significant data-driven decisions within the organization.

Qualifications

• 2 years experience in data engineering with Microsoft Stacks.
• Project experience in API data collection/ingestion from ERP & CRM.
• Skilled at converting business needs into clear data mart designs.

Responsibilities

• Ingest, collect, and integrate internal system & API data like ERP and CRM.
• Convert business needs into clear data mart designs for PowerBI.
• Create data audits to ensure functionality, quality, and correctness of data.

Skills

Data engineering

Business needs analysis

Data mart design

API integration

Education

Bachelor degree in business, information system/technology, data science, statistic/math or related

Tools

Microsoft SQL Server

SSIS

SSAS

PowerBI

Job description

Education and Experience

• Bachelor degree in business, information system/technology, data science, statistic/math or related
• 2 years experience in data engineering in Microsoft Stacks (SQL Server, SSIS, SSAS, PBI)
• Project experience in API data collection/ingestion from ERP & CRM or 3rd party app related to Datawarehouse
• Skilled at converting business needs into clear data mart designs

Responsibilities

• Ingest, collect, & integrate internal system & API data like ERP (Sage X3) & CRM (HubSpot, Salesforce) or related to Datawarehouse
• Converting business needs into clear data mart designs to be consumed for business user via PowerBI
• Create the data audit in our internal application to make sure the functionality, quality, and correctness for the data consumptions
• Analyze the data data to be meaningful and easy to understand