Data Engineer

• 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.

• Pipeline Automation: Develop and schedule Python-based processes to automatically pull and update data from key sources including: o Amazon Vendor / Seller sales data o Inventory and pricing data o High-volume clicks and page views o General online scraping data from the online commercial environment

• Data Integration: Ingest and integrate essential internal data from SharePoint and OneDrive into S3, creating a unified source of truth.

• 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.

• Output Delivery: Produce and document reusable, well-structured tables optimised for downstream BI consumption.

We are seeking a 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. As part of our digital transformation, we are building a simple, scalable cloud data environment to drive smarter decisions across our Amazon Vendor channel and future marketplace platforms. This role will be fundamental to that mission.

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., * Essential Skills

• Degree in a STEM, Computer Science, or related discipline (or equivalent experience)

• 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 Desirable Skills

• Experience with S3, Athena, or Glue

• Experience automating data pulls from APIs

• Exposure to marketplace/eCommerce metrics (Buy Box, COGS, Conversion)

• Exposure to Alteryx or advanced Power Query for ETL workflows

#LI-CO1, Applicants must have a right to live and work in the relevant jurisdiction.

PORTWEST , a leading global manufacturer of safety wear, workwear and PPE is currently seeking applications for the position of 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.