Junior Data Engineer

PORTWEST, a leading global manufacturer of safety wear, workwear and PPE is currently seeking applications for the position of Junior Data Engineer, based near the Manchester area, on a permanent basis reporting to the Head of Ecommerce and Marketplace. Founded in 1904, Portwest has become one of the fastest growing workwear companies in the world currently employing over 5,100 staff worldwide. With 1400 styles across more than 20 ranges, we design, manufacture and distribute market leading workwear, safety wear and PPE in fully owned production facilities. We’re on a mission to become the world’s most requested PPE and Safety Wear Brand.
JOB SUMMARY: 

We are seeking a Junior Data Engineer with 1–3+ years' experience to help build our foundational cloud data platform. The role focuses on building a central data store in AWS, automating data ingestion from APIs and internal sources, and ensuring analysts have access to clean, well-structured datasets. 

This is an ideal opportunity for someone early in their career who wants hands-on experience with cloud data engineering and to contribute directly to Portwest’s global eCommerce and marketplace growth strategy.

This is a hybrid role, one day a week the successful candidate will be required to work from Portwest's Manchester office, located at Salford Quays. The remaining 4 days of the week, the successful candidate will work from home. Travel to our warehouse in Thurnscoe will also be required 1-2 times per month. Access to a car is essential for this role for inter-office travel. 

KEY RESPONSIBILITIES:

1. AWS Data Repository Setup: Assist in setting up, maintaining, and documenting the core serverless data environment using Amazon S3, AWS Glue Data Catalogue, and Amazon Athena.
2. Pipeline Automation: Develop and schedule Python-based processes to automatically pull and update data from key sources including:
• Amazon Vendor sales data
• Inventory and pricing data
• High-volume clicks and page views
3. Data Integration: Ingest and integrate essential internal data from SharePoint and OneDrive into S3, creating a unified source of truth.
4. Data Transformation & Quality: Use Python and SQL to clean and structure raw data into clean, analytics-ready tables. Implement basic data quality checks and monitoring to ensure reliable automated refreshes.
5. Output Delivery: Produce and document reusable, well-structured tables optimised for downstream BI consumption.

REQUIREMENTS:

• Essential Skills

  • • Hands-on experience with SQL for querying and data manipulation
    • Working knowledge of Python for automation or data handling (e.g. pandas, basic API calls)
    • Basic understanding of AWS (or transferable cloud concepts)
    • Analytical mindset and strong written/verbal communication skills
    • Experience automating data pulls from APIs

    Desirable Skills

    • Experience with S3, Athena, or Glue
    • Exposure to marketplace/eCommerce metrics (Buy Box, COGS, Conversion)
    • Exposure to Alteryx or advanced Power Query for ETL workflows
    • Experience with data visualisation tools (Power BI, Qlik, Tableau)

#LI-CO1