Location
Remote, occasional travel for team meet-ups
Level
Mid
Report To
Technical Delivery Lead
Date
06/07/2025

Overview:

The Data Engineer joins SpotDev’s client-delivery team to design, build and document data integrations, migrations and reporting solutions for B2B clients using HubSpot.

Working as part of our Technical Delivery team (and in close liaison with our Design & Development team), you will translate source data and third-party APIs into reliable, auditable pipelines that power HubSpot processes and client BI tools. You will represent SpotDev confidently on calls and emails, guiding stakeholders—often at senior level—through complex data challenges.

 

On a daily basis, you will:

  • Profile raw client data using SQL—primarily PostgreSQL and MySQL—and Python (pandas), validating quality, structure and readiness for transformation.

  • Produce ERDs, data dictionaries and clear source-to-target mapping documents.

  • Review third-party API documentation and define transformation logic.

  • Build and automate ETL/ELT pipelines, loading data into HubSpot and related platforms.

  • Create reports in Power BI and other data/BI tools.

  • Lead or contribute to client workshops, status calls and written updates.

  • Enforce data-governance, Data Protection Act, GDPR and security standards throughout every project.

Key Responsibilities:

Area

What success looks like

Scoping & Solution Design

  • Identify data challenges and requirements during discovery.

  • Design robust, scalable data models and transformation workflows.

Documentation & Mapping

  • Produce detailed mapping documents, ERDs and API reference notes.

  • Keep documentation version-controlled and client-ready.

Pipeline Development

  • Write clean, efficient SQL and Python scripts.

  • Automate loads to HubSpot via REST APIs or middleware tools.

Reporting & Validation

  • Build Power BI dashboards or equivalent to validate and surface insights.

  • Handover clean models and guidance to client BI teams.

Client Communication

  • Present solutions in plain English on calls and in emails.

  • Manage expectations on scope, timelines and data quality.

Experience & characteristics

Skills

  • 5–10 years in data integration, data engineering or ETL roles.

  • Advanced SQL plus solid Python (pandas, NumPy).

  • Proven history of migrating data into HubSpot or similar CRMs.

  • Confident interpreting REST/JSON/GraphQL API documentation.

  • Competent with data-modelling and process charting tools (Lucidchart would be an advantage).

  • Power BI (or comparable) for dashboarding and validation.

  • Excellent written and verbal communication with client stakeholders

Personal characteristics

  • Proactive problem-solver who enjoys untangling complex data sets.

  • Calm, credible presence on client calls and in written updates.

  • Works to SpotDev’s values:

    • We act in SpotDev’s best interests.

    • We deliver quality work on time.

    • We are process-driven professionals.

    • We are accountable until it’s done.

Recruitment process

The hiring process takes about two weeks from shortlisting to references.

  1. CV and covering-letter review.

  2. Shortlisting call.

  3. Practical skills test.

  4. Technical interview.

  5. References.

 

Apply for Data Engineer

More open roles

Interim Chief Operating Officer

Chief Executive
Location
Remote, occasional travel for team meet-ups
Level
Leadership
Main Responsabilities

Reporting to: Chief Executive

Employment: Fixed-Term Contract (Maternity Cover) – 9 to 12 months. Full-time or Part-time (SpotDev is open to this role being part-time for the right candidate)

Salary: £75,000 (pro rata)

SpotDev is a specialist HubSpot consultancy that helps ambitious B2B organisations solve complex technical challenges across CRM, RevOps, integrations, and CMS development.
 
As we continue to deliver enterprise-grade solutions with precision and scale, we are seeking a commercially minded and operationally driven Interim Chief Operating Officer (COO) to support the business during a period of maternity leave.
 
Provisional commencement date: 15 August 2025

Traffic Manager

C-Suite
Location
Fully Remote, Full-time
Level
Mid
Main Responsabilities

Reporting to: C-Suite

Employment: Full-time

Salary: up to £40,000pa 

SpotDev is seeking a highly organised and proactive Traffic Manager to oversee the internal allocation and scheduling of resources across our delivery teams.
 
This pivotal role ensures that our capacity planning tools—ClickUp (for day-to-day visibility) and Operating (for strategic forecasting)—are consistently up to date, enabling informed decision-making at every level of the business. 

Full-Stack Developer

Lead Developer
Location
Fully Remote
Level
All
Main Responsabilities

Reporting to: Lead Developer

Employment: Full-time

Salary: SpotDev is always recruiting for this role, so we will align salary to experience and capabilities. Typical ranges from £20,000 to £60,000.

The Full-Stack Developer is responsible for building scalable, high-quality digital solutions across both front-end and back-end technologies. Working under the guidance of the Lead Developer and Senior Developer, you’ll deliver custom-coded workflows, APIs, HubSpot CMS modules, and web applications that are secure, maintainable, and user-friendly.