Operations Analyst (Data & Automation)

Y Ventures Group; Jakarta Pusat; Sur place; IDR 78 120 000 - 133 920 000; Plein temps

Résumé du poste

Y Ventures Group is seeking an Operations Analyst (Data & Automation) in Jakarta to build data tools and automation for the Logistics team. You will turn business needs into reliable ETL flows, dashboards, and AI-assisted workflows, while collaborating with Business Analysts and logistics staff to drive improvements.

We welcome fresh graduates with relevant internship or project experience. The role requires curiosity about data, strong Python/SQL skills, and comfort working from the office as

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data or related field.
• 0–2 years of experience; fresh graduates welcome with relevant internship, freelance, or part-time work.
• Has built at least one end-to-end project used by others (internship, work, or personal).
• Experience with AI coding assistants and ability to validate outputs.

Responsabilités

• Build and maintain data transformation (ETL) flows with deterministic outputs.
• Create internal web tools to capture operational data not available via API, with validation and audit trails.
• Design and maintain database schemas with constraints to ensure clean data (no duplicates, no orphaned records).
• Build dashboards and reports on top of the data platform.
• Develop AI-assisted workflows with checks on outputs.
• Write tests from known-input and expected-output cases.
• Reuse and extend existing tools; document each tool (purpose, inputs/outputs, deployment, testing).
• Use AI coding tools and be able to explain any shipped code.
• Collaborate with Logistics to understand daily processes and improve tools based on usage feedback.
• Support requirement gathering, SOP documentation, and ad hoc reporting for logistics.

Connaissances

Python

SQL

Relational databases

Git

Automated testing

Formation

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

Outils

PostgreSQL

MySQL

SQL Server

Description du poste

Responsibilities

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.

Responsibilities

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.

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.