Job SummaryWe are seeking an experienced Data Engineer II to design and build the data foundation that powers B2B marketing initiatives within HubSpot. This role will own the development and maintenance of the HubSpot data model, ensuring accurate relationships between people, accounts, locations, and other key business entities. The Data Engineer II will work closely with marketing, analytics, and data engineering teams to enable effective campaign targeting, support critical data migrations, and maintain high standards of data quality and governance.
Key Responsibilities- Design, implement, and maintain the HubSpot data model, including standard objects, custom objects, associations, and association labels for complex many-to-many relationships.
- Document data model architecture, field definitions, and design decisions.
- Collaborate with Data Engineering and Analytics teams to define source-of-truth datasets, business definitions, and refresh schedules.
- Build and manage data integrations between the data warehouse and HubSpot using Hightouch, native integrations, or similar tools.
- Map source fields to HubSpot properties and establish data keys, deduplication logic, and update rules.
- Monitor and maintain data synchronization processes, proactively resolving failures, schema changes, and data discrepancies.
- Own end-to-end data quality processes, including validation, enrichment, standardization, deduplication, and automated cleanup.
- Lead the migration of Iterable user attributes, events, and subscription data into HubSpot while preserving record relationships.
- Establish and maintain data governance standards, including access controls, consent management, data retention, and PII handling.
- Create and maintain technical documentation, field mappings, process documentation, and operational runbooks.
- Partner closely with the Campaign Architect to ensure required properties, events, and associations support marketing campaign execution.
Required Qualifications- Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field, or equivalent practical experience.
- 5+ years of experience in Data Engineering, Analytics Engineering, Marketing Operations, or Revenue Operations.
- Minimum 2 years of hands-on experience working with HubSpot data and platform architecture.
- Proven experience designing HubSpot data models utilizing custom objects and complex associations.
- Strong understanding of HubSpot platform capabilities, limitations, and best practices.
- Advanced SQL expertise, including data profiling, transformation, validation, and warehouse management.
- Experience working with cloud data warehouses such as Snowflake.
- Hands-on experience with Reverse ETL tools such as Hightouch or Census.
- Experience with ETL/ELT tools including Fivetran, dbt, Airflow, or similar platforms.
- Working knowledge of REST APIs, webhooks, and HubSpot CRM/Associations APIs.
- Demonstrated success leading large-scale data migrations while maintaining data integrity and relationships.
- Strong analytical, troubleshooting, and documentation skills.
- Ability to communicate complex technical concepts effectively to both technical and non-technical stakeholders.
Preferred Qualifications- Experience supporting B2B go-to-market organizations.
- Proficiency in Python and/or JavaScript scripting.
- Experience with HubSpot Data Hub and data quality automation initiatives.
- Experience modeling account hierarchies, multi-location customer structures, or partner ecosystems.
- Experience integrating Salesforce and HubSpot environments.
- Familiarity with pipeline monitoring, testing frameworks, and data observability tools.
- Working knowledge of privacy and compliance regulations, including GDPR, CCPA, and CAN-SPAM.
Certifications- HubSpot Certifications (preferred).
- Relevant certifications in Data Engineering, Cloud Platforms, or Marketing Technology are a plus.
