Operations Analyst (Data & Automation)

KantorKu; Jakarta Pusat; On-site; IDR 133,920,000 - 178,560,000; Full time

Job summary

Y Ventures Group is seeking an Operations Analyst (Data & Automation) to build data tools and automate workflows for the Logistics team. You will transform business needs into reliable ETL flows, dashboards, and internal web tools.

You will collaborate with the Logistics team to understand daily processes, gather requirements, document SOPs, and support ad hoc reporting. Fresh graduates with relevant internship or project work are welcome.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data or related field.
• 0–2 years of experience; fresh graduates with relevant internships or projects welcome.
• Has built at least one end-to-end project used by others (internship, work or personal).
• Experience with AI coding assistants and the judgment to check their output.

Responsibilities

• Build and maintain data transformation (ETL) flows with deterministic outputs.
• Create internal web tools for capturing operational data with validation and audit trails.
• Design and maintain relational database schemas with constraints to ensure data quality.
• Develop dashboards and reports on top of the data platform.
• Build AI-assisted workflows where appropriate and validate AI outputs.
• Write tests for known-input and expected-output cases with stakeholders.

Skills

Python

SQL

Git

Education

Bachelor's degree in Computer Science, Information Systems, Data or related field

Tools

PostgreSQL

MySQL

SQL Server

Job description

The Operations Analyst (Data & Automation) is the Logistics team's in-house builder of data tools and automation. They turn business needs into small, reliable systems: data transformation (ETL) flows, dashboards and reports, data-entry tools for scattered operational data, and AI-assisted workflows. They also support the Business Analyst with requirement gathering, SOP documentation and reporting, and work closely with the Logistics team to drive improvement.

• Build and maintain data transformation (ETL) flows that produce deterministic, verifiable output, reconciled against source data.
• Build internal web tools to capture operational data that is not available via API, with input validation and audit trails.
• Design and maintain database schemas for data owned by these tools, using constraints and validation to keep data clean (no duplicates, no orphaned records).
• Build dashboards and reports on top of the existing data platform.
• Build AI-assisted workflows where they fit, with checks on the AI's output.
• Write tests from known-input and expected-output cases agreed with the requester.
• Reuse and extend existing live tools as templates, and document each tool shipped (purpose, inputs and outputs, how to deploy, how to test).
• Use AI coding tools in daily work and be able to explain any code shipped.
• Work with Logistics team members to understand their daily processes, collect feedback after each launch, and improve tools based on how they are used.
• Support requirement gathering, SOP documentation, and ad hoc reporting for the logistics team.

Requirements

Education:

• Bachelor's degree in Computer Science, Information Systems, Data or related field.

Experience:

• 0–2 years of experience
• Fresh graduates are welcome if they have relevant internship, freelance, or part-time experience.
• Has built at least one project end-to-end that other people used (internship, work or personal).
• Experience with AI coding assistants, and the judgment to check their output.

Skills:

• Python and SQL: able to read, write and debug both independently.
• Relational database fundamentals: table design, primary and foreign keys, constraints, joins, indexes and transactions; hands-on experience with a relational database such as PostgreSQL, MySQL or SQL Server.
• Working knowledge of Git and basic automated testing.

Attributes:

• Clear written communication, and comfortable taking requirements from non-technical colleagues.
• Genuine interest in business operations (e.g., logistics or supply chain) and willingness to learn how the logistics team works.
• Able to work from the office when required.

Y Ventures Group is a data-driven e-commerce company. We establish strong relationships with global brand partners, providing valuable data insights and actively distributing their products in the e-commerce space. By combining our data-driven methodologies with our extensive e-commerce expertise, we ensure our partners maintain a stable and thriving presence in the marketplace. Our dedication to transparency, collaboration and end-to-end support fosters trust and strong partnerships, driving success for our clients.