Junior Data Engineer

The Junior Data Engineer supports the Finance department's day-to-day data operations within a 3PL business environment. The primary focus of this role is data processing and verification — including logistics billing reconciliation and customer pricing data preparation — while also assisting senior engineer with the gradual build-out of automated workflows. A foundational technique of programming is expected, with the opportunity to develop technical skills on the job. The role also assists on the build-out of the company's BigQuery data room, and is expected to work AI-first — using AI coding assistants and LLM-based tools as the default approach to day-to-day data work.

• Billing Verification & Reconciliation: Process and verify logistics carrier invoices; cross-check billing data against system records and internal references; establish validation rules and flag discrepancies and follow up with relevant parties for resolution.
• Customer Pricing Data Preparation: Assist senior data engineers in collecting, organizing, and maintaining customer rate data; create data quality check rules to support the preparation of customer pricing and perform basic data quality checks to ensure accuracy.
• Automation Support & Learning: Assist senior data engineers in testing and validating automated workflows; complete daily data query and validation, and proactively learn to take on more technical tasks over time.
• Ad-hoc Data Tasks: Handle data processing and reporting requests from the Finance department and cross-functional teams as assigned, including data collation, formatting, and basic transformation tasks.
• BigQuery Data Room Support: Assist the senior data engineer on the BigQuery data room project — loading and staging source data, writing and testing SQL queries and transformation logic, documenting table structures and field definitions, and running data quality checks to confirm that modelled data ties back to the source systems.
• AI-First Ways of Working: Use AI and LLM-based tools as the default approach to daily work — including AI coding assistants for writing and debugging SQL and Python, and LLM tools for data checks, documentation and reconciliation support. Write and refine prompts, build reusable prompt templates and lightweight AI-assisted workflows for recurring tasks, and always validate AI output against source data before it is relied upon.