Data Analyst Assistant

PT Trans Cosmos Commerce; Jakarta Selatan; On-site; IDR 133,920,000 - 200,880,000; Full time

Job summary

PT Trans Cosmos Commerce seeks a data analyst to collect, consolidate, and analyze data from sales, marketplace, marketing, and operations to drive business decisions.

You will prepare dashboards and reports using Power BI/Tableau, perform data cleaning and validation, and explain insights to both technical and non-technical stakeholders.

Qualifications

• Bachelor's degree in Data Science, Statistics, Mathematics, Computer Science, Information Systems, Business Analytics, Business Administration, or a related field.
• Minimum 2 years of professional experience in Data Analysis, Business Intelligence, Business Analytics, Data Science, or a related analytical role.
• Proven experience in data analysis and interpretation, preferably involving sales, marketing, marketplace, e-commerce, or business performance data.
• Strong understanding of data preparation, data cleaning, validation, transformation, and analysis.
• Experience identifying trends, patterns, performance gaps, and business opportunities through data analysis.
• Proficient in Microsoft Excel, including Pivot Tables, VLOOKUP/XLOOKUP, data analysis, and reporting functions.
• Working knowledge of SQL for data extraction, querying, manipulation, and analysis.
• Experience creating reports, dashboards, and data visualizations using tools such as Power BI, Tableau, or equivalent platforms.
• Strong analytical and problem-solving skills with the ability to translate data into clear, actionable business insights and recommendations.
• Strong attention to detail with a commitment to data accuracy, consistency, and reliability.
• Good communication skills with the ability to explain analytical findings and data insights to technical and non-technical stakeholders.
• Ability to manage multiple analytical tasks, prioritize effectively, and meet deadlines in a fast-paced business environment.
• Good working proficiency in Bahasa Indonesia and English.

Responsibilities

• Collect, consolidate, and analyze data from relevant business sources, including sales, marketplace, marketing, and operational data.
• Perform data cleaning, validation, and reconciliation to identify data quality issues.
• Prepare and maintain regular business performance reports, dashboards, and data visualizations.
• Monitor key performance indicators and identify trends, variances, and gaps.
• Conduct exploratory and structured data analysis to identify opportunities, risks, and areas for improvement.
• Develop data-driven insights and recommendations to support improvements in sales, marketplace, marketing, and operations.

Skills

Data analysis

Excel proficiency

SQL querying

Power BI

Tableau

Data visualization

Communication skills

Bahasa Indonesia & English

Education

Bachelor's degree in Data Science or related field

Tools

Pivot Tables (Excel)

VLOOKUP/XLOOKUP (Excel)

Power BI

Tableau

Job description

Collect, consolidate, and analyze data from relevant business sources, including sales, marketplace, marketing, and operational data.

Perform data cleaning, validation, and reconciliation to identify and resolve data inconsistencies, missing information, or potential data quality issues.

Prepare and maintain regular business performance reports, dashboards, and data visualizations using relevant analytical and reporting tools.

Monitor key business and operational performance indicators and identify significant trends, patterns, variances, and performance gaps.

Conduct exploratory and structured data analysis to identify business opportunities, potential risks, and areas for improvement.

Develop data-driven insights and recommendations to support improvements in sales performance, marketplace performance, marketing activities, and operational effectiveness.

Support stakeholders in defining data requirements, analytical objectives, and reporting needs based on business priorities.

Translate business requirements into appropriate datasets, reports, dashboards, and analytical outputs.

Present and communicate analytical findings in a clear and understandable manner to both technical and non-technical stakeholders.

Support the development and enhancement of data dashboards and analytical solutions to improve accessibility and usability of business information.

Utilize Microsoft Excel, SQL, and data visualization tools such as Power BI, Tableau, or equivalent platforms for data analysis and reporting.

Apply Python or other analytical tools, where relevant, to support data processing, analysis, or automation. (Optional)

Maintain accurate documentation of data sources, analytical processes, reports, and dashboards to support consistency and traceability.

Conduct ad hoc analysis and prepare relevant data insights to support management requests, business reviews, and new project requirements.

Collaborate with relevant teams to validate analytical findings and ensure that insights are aligned with actual business conditions.

Continuously identify opportunities to improve data quality, reporting processes, analytical methods, and overall efficiency of data-driven decision-making.

QUALIFICATION:

Bachelor's degree in Data Science, Statistics, Mathematics, Computer Science, Information Systems, Business Analytics, Business Administration, or a related field.

Minimum 2 years of professional experience in Data Analysis, Business Intelligence, Business Analytics, Data Science, or a related analytical role.

Proven experience in data analysis and interpretation, preferably involving sales, marketing, marketplace, e-commerce, or business performance data.

Strong understanding of data preparation, data cleaning, validation, transformation, and analysis.

Experience identifying trends, patterns, performance gaps, and business opportunities through data analysis.

Proficient in Microsoft Excel, including Pivot Tables, VLOOKUP/XLOOKUP, data analysis, and reporting functions.

Working knowledge of SQL for data extraction, querying, manipulation, and analysis.

Experience creating reports, dashboards, and data visualizations using tools such as Power BI, Tableau, or equivalent platforms.

Strong analytical and problem-solving skills with the ability to translate data into clear, actionable business insights and recommendations.

Strong attention to detail with a commitment to data accuracy, consistency, and reliability.

Good communication skills with the ability to explain analytical findings and data insights to technical and non-technical stakeholders.

Ability to manage multiple analytical tasks, prioritize effectively, and meet deadlines in a fast-paced business environment.

Good working proficiency in Bahasa Indonesia and English.