Data Analyst

Lancesoft APAC; Indonesia; On-site; IDR 150,000,000 - 230,000,000; Full time

Job summary

Lancesoft APAC is seeking a Data Analyst to analyze data flows, ensure data quality, and integrate SAP CDP with ERP systems, BigQuery, and GA4. The role includes documenting processes, supporting testing, and providing go-live support.

The ideal candidate has a Bachelor's degree in IT/IS/Data and strong SQL, data modeling, and ETL/ELT skills. Collaboration with business users is essential for success.

Qualifications

• Bachelor's degree in IT/IS/Data related field.
• Strong SQL skills and databases know-how.
• Understanding of ETL/ELT concepts and data integration.

Responsibilities

• Analyze data flows to support project and system requirements.
• Ensure data quality and data integrity across systems; validate data.
• Configure and support CRM systems (SAP CDP) and integrate with ERP, BigQuery, GA4.
• Prepare and maintain technical documentation for development and operations teams.
• Support system testing, UAT, and implementation activities.
• Provide technical support during go-live and post-implementation periods.
• Perform debugging and root cause analysis for data/system issues.
• Conduct user training and guide on data processes.
• Collaborate with business users to understand and fulfill requirements.

Skills

SQL proficiency

Data quality management

ETL/ELT concepts

Data modeling & mapping

Programming: Python/JavaScript

Data flow analysis

Communication & collaboration

Problem solving & debugging

Education

Bachelor's degree in IT/IS/Data related

Tools

SAP CDP

CRM systems

Google BigQuery

GA4

Google Tag Manager

ERP integration

Job description

Data Analyst Responsibilities

1. Analyze data flows to support project and system requirements.




2. Ensure data quality and data integrity across systems, including data validation, consistency, completeness, and accuracy.




3. Configure and support CRM systems, particularly SAP Customer Data Platform (SAP CDP), and integrate them with ERP systems and surrounding applications, such as BigQuery and Google Analytics 4 (GA4).




4. Prepare and maintain technical documentation to support development and operations teams.




5. Support system testing, user acceptance testing (UAT), and implementation activities.




6. Provide technical support during go-live and post-implementation periods.




7. Perform debugging and root cause analysis to identify and resolve data-related and system integration issues.




8. Conduct user training and provide guidance on system functionality and data processes.




9. Collaborate with business users and internal teams to understand, analyze, and fulfill business and system requirements.

Qualifications 1. Education

• Bachelor's degree (S1) in Information Technology, Information Systems, Industrial Engineering, Data Science, or a related field.

2. Technical Skills

• Strong SQL skills and a solid understanding of databases and relational data models.




• Good understanding of data quality, integrity, consistency, completeness, accuracy, validation, and reconciliation.




• Understanding of ETL/ELT concepts and data integration processes.




• Familiarity with data structures and formats, including JSON, CSV, XML, and other common data formats.




• Experience with SAP Customer Data Platform (SAP CDP), CRM systems, or related platforms.




• Knowledge of data modeling, data mapping, and functional processes related to SAP SD/MM and ERP systems.




• Familiarity with marketing automation platforms.




• Experience with Google BigQuery, Google Analytics 4 (GA4), and Google Tag Manager.




• Basic to intermediate programming skills in Python and/or JavaScript.




• Strong debugging and root cause analysis skills.

3. Interpersonal and Communication Skills

• Strong communication and negotiation skills when working with business users and internal teams.




• Good presentation skills and confidence in communicating technical concepts to non-technical stakeholders.




• Strong teamwork and collaboration skills.




• Ability to manage multiple tasks and meet tight deadlines.

4. Analytical Skills

• Strong logical and critical thinking.




• Ability to analyze data flows and business processes systematically.




• Detail-oriented, with a data-driven approach to problem-solving.

5. Experience

• 3 5 years of experience as a Business Data Analyst, Data Quality Analyst, Business Process Analyst, or in a similar role.

6. Additional Requirements

• Age: Under 30 years old.




• Gender: Male or Female.