Patchworks iPaaS Integrations Engineer - Contract role

About Swanky

We’re Swanky, a fast-growing global Shopify Platinum Partner . We design, build, and grow Shopify Plus stores that convert. Our clients are ambitious brands, and we help them thrive with world-class Shopify solutions.

About the Role

We’re looking for a contractor Integrations Engineer to help us design, build, and maintain data integrations across our ecommerce stack. You’ll work on iPaaS-driven integrations, primarily using Patchworks, to move and transform data between platforms such as Shopify, ERPs, WMS/3PLs, marketplaces, and analytics tools.

This is a hands-on role where you’ll be responsible for building reliable, observable, and well-documented integrations. You’ll collaborate closely with our existing Patchworks Integrations Lead Engineer, as well as our engineering team, project managers, and client stakeholders to define requirements, map data models, and ensure data flows are accurate, performant, and resilient.

Your day-to-day could involve building Patchworks flows, developing custom Python scripts and TypeScript components to handle complex data transformations, working with Supabase middleware tooling, writing SQL for validation and reconciliation, and troubleshooting issues in production. You’ll also contribute to integration standards, deployment practices, and operational runbooks.

Responsibilities

• Design, build, and support iPaaS integrations using Patchworks (and other integration tooling where needed).
• Work closely with our Patchworks Integrations Lead Engineer to deliver new integrations and improve existing ones.
• Work with client stakeholders and internal teams to capture integration requirements and translate them into robust data flows.
• Map source and target data models (orders, inventory, products, customers, payments, etc.) and implement transformations to meet business rules.
• Develop and maintain custom integration components and scripts in Python and TypeScript to extend iPaaS capabilities.
• Work with Supabase (Postgres) for data storage, operational dashboards, reconciliation tooling, and integration support workflows.
• Write and optimise SQL for data extraction, transformation, validation, reconciliation, and reporting.
• Troubleshoot and resolve integration failures, data quality issues, and performance bottlenecks.
• Implement logging, monitoring, alerting, and operational processes to ensure integrations are reliable and supportable.
• Document integration designs, data mappings, runbooks, and handover notes for internal teams and clients.
• Follow secure engineering practices when handling credentials, PII, and platform permissions.
• Collaborate via Git-based workflows where code is involved (PRs, reviews, versioning, release notes).

About You

You’re pragmatic, detail-oriented, and comfortable owning integration work end-to-end, from discovery through delivery and support. You have a strong data mindset and enjoy tracking down root causes when systems do not agree. You can communicate clearly with both technical and non-technical stakeholders, and you are able to work independently as a contractor while staying aligned with team standards.

Required skills & experience

• Strong commercial experience building and supporting integrations (iPaaS, ETL/ELT, or bespoke middleware).
• Python: confident writing production-grade scripts and integration components (error handling, retries, testing, packaging, maintainability).
• TypeScript: confident building maintainable services, scripts, or serverless components that support integration workflows.
• SQL: confident querying and validating relational datasets, designing reconciliations, and optimising queries.
• Experience with API integrations (REST/GraphQL), authentication patterns (OAuth, API keys), and webhooks.
• Experience working with databases and data modelling for operational and analytics use cases.
• Solid understanding of data quality, idempotency, retries, rate limits, and integration resiliency patterns.
• Comfortable working with logs, monitoring, and incident-style troubleshooting.
• Strong written documentation skills and clear communication in client-facing contexts.

Advantageous

• Hands-on experience building integrations with Patchworks iPaaS.

Nice to have

• Experience with Supabase (Auth, Edge Functions, storage, RLS, Postgres optimisation) or similar backend platforms.
• Experience with other ETL/iPaaS tools such as Talend (or similar platforms like Boomi, MuleSoft, Workato, Make, Zapier, Azure Data Factory).
• Experience integrating Shopify with ERPs (NetSuite, SAP, Microsoft Dynamics, Brightpearl, etc.) and 3PL/WMS platforms.
• Familiarity with data warehousing and ELT patterns (for example: BigQuery, Snowflake, Redshift) and orchestration tools.
• Experience with versioning/deploying iPaaS assets and maintaining environments (dev/stage/prod).
• Comfort with basic DevOps and cloud concepts (secrets management, serverless jobs, scheduled tasks).

Contract details

• Role type: Contract role
• IR35 status: to be confirmed, dependent on working arrangements."
• Initial contract length: 3 months (with potential extension and/or full-time position).
• Start: ASAP.
• Location: Remote, with optional Exeter office time if preferred.
• Day rate: Competitive, dependent on experience.
• Availability: Full-time preferred, part-time considered.

Benefits

As a contractor role, Swanky benefits do not apply. However, you’ll work with a collaborative, ambitious team on high-impact ecommerce integrations for well-known brands, with clear delivery goals and minimal bureaucracy.