opinov8

Data Automation Engineer, Python

opinov8

contract

Posted on:

Location Type: Hybrid

Location: United Kingdom

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

BigQueryCloudPythonSQL

About the role

  • Convert Existing Excel Logic & Manual Workflows into Python
  • Analyze 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.

Requirements

  • 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).
Benefits
  • 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.
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
PythonExcelSQLopenpyxlxlsxwriterdata automationdata analyticsunit testingautomation-friendly outputsPython package development
Soft Skills
collaborationcommunicationworkflow ownershipanalytical skillsdocumentation skillsproblem-solvingattention to detailvalidation skillsorganizational skillsstakeholder engagement