Remote HubSpot Data Engineer - Data Modeling & Migrations

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