Data Automation Engineer (Python)

PROJECT OVERVIEW

This project has two primary components:

• Translate complex Excel-based business logic into maintainable, production-quality Python code

• Generate business-friendly Excel outputs (welldesigned tables, formatting, conditional logic) from Python-produced CSVs

You will build a Python package (internal) and support local Notebook-based operations, enabling analysts to run process consistently. A strong ability to convert business rules into deterministic code and to design lightweight, reliable operational processes will be critical.

The ideal candidate works independently with minimal oversight, communicates complex concepts clearly to business stakeholders, maintains strong documentation standards, and adapts comfortably to a fast-paced, iterative workflow.

IN THIS ROLE, YOU WILL

1. Convert Existing Excel Logic & Manual Workflows into Python

• Analyse current Excel files to extract formulas, business rules, macros, and logic flow.

• Rewrite this logic into clean, modular Python (functions, classes).

• Ensure output parity with existing manual Excel workflows.

• Implement robust validation, logging, and error handling.

2. Build an Internal Python Package

• Package the code as a reusable, well-structured internal library.

• Provide clear documentation (docstrings, examples, operation documents).

• Enable execution through local Jupyter Notebooks for Analysts.

• Set up unit tests for critical functions.

3. Create Analyst-Friendly Excel Reports

• Transform Python-generated CSV outputs into formatted Excel reports using openpyxl, xlsxwriter, or similar.

• Ensure readability for business stakeholders without technical skills.

4. Forecast & P/L Automation

• Automate:

• 18month forecast generation

• platform-level splits

• Pre-order tracker updates

• P/L logic (platform margins, Box costs, COGS)

• Ensure numerical consistency with existing tools and historical cases.

5. Operational Design & Runbook Creation

• Design how analysts will operate the system:

• step-by-step procedures

• input requirements

• parameterisation

• validation steps

• error-handling guidelines

• Deliver:

• Runbook (step-by-step guide for daily operations)

• Process diagrams / execution flow

• Test coverage notes

• Support the go-live rehearsal and handover.

6. Collaboration & Workflow Ownership

• Work closely with Forecasting Analysts to validate business logic.

• Collaborate with Data Scientists / Engineers as needed.

• Provide weekly updates on milestone progress.

IF YOU ARE

• 3+ years Python experience focused on data automation or analytics workflows.

• Strong knowledge of Excel → Python translation:

• complex formulas

• lookup tables

• nested logic

• multi-sheet workflows

• Experience creating automation-friendly and readable Excel outputs:

• formatting

• pivot-style layouts

• conditional formatting

• Proven experience building and maintaining Python packages.

• Confident with Jupyter/Notebook-based operations.

• Strong SQL skills (BigQuery preferred).

• Familiarity with Google Cloud services (BigQuery, Cloud Storage, IAM basics, and pricing structure).

NICE TO HAVE

• Knowledge of forecasting or financial models.

• Understanding of revenue / margin / P&L concepts.

• Exposure to analytics teams in a commercial or media/entertainment setting.

• Experience with code optimisation and refactoring legacy logic.

AS AN OPINOV8R, YOU WILL HAVE

• Digital-First Approach: Great talent knows no borders! You can work from wherever you are — we hire and collaborate with professionals worldwide.

• Remote Work Model: Balance your professional and personal life with our flexible working conditions, empowering you to deliver your best from anywhere.

• Exciting Projects: Dive into impactful projects across industries that challenge and spark creativity.

• Boost Your Expertise: Grow your career with continuous learning, development opportunities, and hands-on experience.

• Join the Best Team Ever: Collaborate with our diverse and cross-cultural team of passionate technologists and creative thinkers.

HOW’S THE HIRING PROCESS GOING

We strive to make our hiring process smooth and transparent to find the perfect match for both sides. Steps may differ depending on the role, but here’s what to expect:

• Initial Interview: If your background fits the role, we’ll invite you for an interview with a Talent Acquisition Specialist.

• Technical Interview: Depending on the position, you may complete a technical assessment or test task.

• Final Decision: After all steps, we’ll get back to you with the result and next steps.