HubSpot Data Engineer

Mykelly; San Francisco (CA); Remote; USD 83,000 - 124,000; Full time

Job summary

HubSpot is seeking a Senior HubSpot Data Engineer to build the data foundation for B2B marketing. You’ll design the HubSpot data model that connects people, accounts, locations, and other records, and ensure data from the warehouse and other systems is synchronized.

This role will drive a migration from Iterable to HubSpot, partnering with marketing and technical teams. It is remote in the USA with flexible hours and a 9-5 schedule.

Qualifications

• 5+ years in data engineering or analytics/marketing ops.
• 2+ years hands-on with HubSpot data.
• Design HubSpot data models with custom objects & associations.
• Advanced SQL in a warehouse (e.g., Snowflake).
• Experience with reverse ETL tools (Hightouch, Census) and ETL/ELT tools (Fivetran, dbt, Airflow).
• REST APIs and webhooks, including HubSpot CRM/Associations APIs.
• Led a large data migration while preserving relationships.
• Strong documentation and ability to explain data concepts to marketing teams.

Responsibilities

• Design and document HubSpot data models, including custom objects and many-to-many relationships.
• Align with Data Engineering and Analytics on source-of-truth tables, data definitions, and refresh schedules.
• Build and maintain warehouse-to-HubSpot syncs using Hightouch or native integrations.
• Map source fields to HubSpot properties and define keys, deduplication rules, and update logic.
• Monitor sync health, set up alerts for failures and volume/schema changes, and resolve issues promptly.
• Own data quality processes, including deduplication, standardization, validation, enrichment, and automated cleanup.
• Plan and execute the migration of Iterable user attributes, events, and subscription status into HubSpot.
• Establish governance standards for access controls, consent fields, data retention, and PII handling.
• Keep documentation for the data model, field mappings, and operational runbooks current.

Skills

Data engineering

HubSpot data

SQL (Snowflake)

Reverse ETL (Hightouch/Census)

ETL/ELT tools (Fivetran, dbt, Airflow)

REST APIs & webhooks

Data migration leadership

Documentation & communication

Tools

Hightouch

Census

Fivetran

dbt

Airflow

Snowflake

Job description

HubSpot Data Engineer

• Location: Remote (USA)
• Contract duration: 6 months
• Contract Type: W2 under Kelly
• Schedule: Remote M-F 9am - 5pm Time zone flexible
• Pay: $71.30/hour
• Visa Sponsorship: Not applicable

Description

We're seeking a Senior HubSpot Data Engineer to build and maintain the data foundation for B2B marketing. You'll design the HubSpot data model that connects people, accounts, locations, and other records, and ensure data from the warehouse and other systems is synchronized accurately. You'll also partner with marketing and technical teams on a migration from Iterable to HubSpot. This is a remote, weekday role, generally scheduled from 9 a.m. to 5 p.m. with time-zone flexibility.

Key Responsibilities

• Design and document HubSpot data models, including custom objects, associations, and labels for many-to-many relationships.
• Align with Data Engineering and Analytics teams on source-of-truth tables, data definitions, and refresh schedules.
• Build and maintain warehouse-to-HubSpot syncs using Hightouch or native integrations.
• Map source fields to HubSpot properties and define keys, deduplication rules, and update logic.
• Monitor sync health, set up alerts for failures and volume or schema changes, and resolve issues promptly.
• Own data quality processes, including deduplication, standardization, validation, enrichment, and automated cleanup.
• Plan and execute the migration of Iterable user attributes, events, and subscription status into HubSpot.
• Establish governance standards for access controls, consent fields, data retention, and PII handling.
• Keep documentation for the data model, field mappings, and operational runbooks current.

Required Qualifications

• 5+ years of experience in data engineering, analytics engineering, marketing operations, or revenue operations, including 2+ years working hands-on with HubSpot data.
• Experience designing HubSpot data models with custom objects and associations, and understanding of relevant platform limitations.
• Advanced SQL skills, including data profiling, transformation, and validation in a warehouse such as Snowflake.
• Hands-on experience with reverse ETL tools such as Hightouch or Census and ETL/ELT tools such as Fivetran, dbt, or Airflow.
• Working knowledge of REST APIs and webhooks, including HubSpot CRM and Associations APIs.
• Experience leading a large data migration while preserving relationships between records.
• Strong documentation and communication skills, including the ability to explain data concepts to marketing teams.

Preferred Qualifications

• B2B go-to-market experience.
• Python or JavaScript scripting experience.
• Familiarity with HubSpot Data Hub and data quality automation.
• HubSpot certifications.
• Experience modeling account hierarchies, multi-location customers, or partner networks.
• Experience with Salesforce alongside HubSpot.
• Familiarity with pipeline monitoring or testing tools.
• Knowledge of marketing-data privacy regulations such as CCPA, GDPR, and CAN-SPAM.