Senior Data Engineer & HubSpot Data Architect (Remote)

The Fountain Group; San Francisco (CA); Hybrid; USD 80,000 - 90,000; Part time

Job summary

The Fountain Group is currently seeking a Data Engineer / HubSpot Consultant for a prominent client. This is a 100% remote role offering a pay rate of $58–$64.52/hr on W2 and an initial 6-month contract with high extension potential.

The role focuses on designing and building the data foundation for B2B marketing in HubSpot, owning the data model, and loading data from a warehouse into HubSpot while maintaining accurate syncs.

Qualifications

• 5+ years in data engineering, analytics engineering, marketing operations, or revenue operations.
• 2+ years hands-on with HubSpot data.
• Designed a HubSpot data model with custom objects and associations.
• Advanced SQL in a warehouse like Snowflake.
• Experience with reverse ETL and ETL/ELT tools.
• Knowledge of REST APIs and HubSpot APIs.
• Strong documentation habits.

Responsibilities

• Own the design of the HubSpot data model, including objects, custom objects, associations, and labels for many-to-many relationships.
• Agree on source-of-truth tables, definitions, and refresh schedules with data engineering and analytics.
• Build and maintain syncs from the warehouse into HubSpot using Hightouch or native integrations.
• Map source fields to HubSpot properties, and define keys, deduplication rules, and update logic for each sync.
• Monitor sync health, with alerts for failures and schema changes; fix issues quickly.
• Own data quality end to end, including deduplication, standardization, validation, enrichment, and automated cleanup.
• Plan and run the move of Iterable user attributes, events, and subscription status into HubSpot.
• Set data governance standards, including access controls, consent fields, retention rules, and PII handling.
• Document the model, field mappings, and runbooks, and keep them current.

Skills

HubSpot data modeling

SQL and data profiling

ETL/ELT tools

Data migration

REST APIs & webhooks

Documentation

Data governance

Python scripting

Tools

Snowflake

Hightouch

dbt

Airflow

Fivetran

Census

HubSpot API integrations

Job description

The Fountain Group is currently seeking a Data Engineer / HubSpot Consultant for a prominent client. This is a 100% remote role offering a pay rate of $58–$64.52/hr on W2 and an initial 6-month contract with high extension potential.

The role focuses on designing and building the data foundation for B2B marketing in HubSpot, owning the data model, and loading data from a warehouse into HubSpot while maintaining accurate syncs.