Data Engineer-II
Abacus Service Corporation· Oct 16, 2026 · 11d ago
HQ, USA, CA, San Francisco, 2nd St, CA
In office
Full-time
Mid
$117K–$176K est.
Job description
Title
Data Engineer-II
Location
HQ, USA, CA, San Francisco, 2nd St
Start Date
Oct 19, 2026
End Date
Apr 19, 2027
Workday Access - Posting
Yes
Requisition Reason
Original|Open Position
Laptop
Yes
Job Posting SLA Classification
Professional
Requisition Process Type
Standard
Allow for Remote
Yes
Primary Hours
Standard Business Hours
Business Need
Increase in Workload
Description
Remote
M-F 9am - 5pm
Timezone flexibls
We need a senior contractor to design and build the data foundation for our B2B marketing in HubSpot.
You will own the data model that connects the people, accounts, locations, and other records we market to.
That model determines who our campaigns can target. You will also load data from our warehouse and other source systems into HubSpot and keep those syncs running and accurate.
You will work closely with the Campaign Architect, whose Iterable-to-HubSpot migration depends on having the right properties, events, and associations in place.
Key Responsibilities
Own the design of the HubSpot data model, including objects, custom objects, associations, and association labels for many-to-many relationships.
Make and document the design decisions.
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, volume changes, and schema changes.
Fix issues quickly.
Own data quality end to end, covering 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.
Required Skills
5+ years in data engineering, analytics engineering, marketing operations, or revenue operations, including 2+ years working hands-on with HubSpot data.
Has designed a HubSpot data model with custom objects and associations, and knows the platform limits that affect design.
Advanced SQL, including profiling, transforming, and validating data in a warehouse such as Snowflake.
Hands-on experience with reverse ETL (Hightouch, Census) and ETL/ELT tools (Fivetran, dbt, Airflow).
Working knowledge of REST APIs and webhooks, including the HubSpot CRM and Associations APIs.
Has led a large data migration that preserved relationships between records.
Clear documentation habits and the ability to explain data concepts to marketers.
Preferred Skills
B2B go-to-market experience Python or JavaScript scripting HubSpot Data Hub and data quality automation HubSpot certifications Modeling account hierarchies, multi-location customers, or partner networks Salesforce alongside HubSpot Pipeline monitoring or testing tools Privacy regulations for marketing data (CCPA, GDPR, CAN-SPAM)
By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at Privacy Policy - Abacus .
Application prep
Use the role’s language and application details while tailoring your materials.
Keywords to mirror
sqlrestgopythonjavascriptai
- Platform
- jobdiva
- Effort
- medium
Benefits
Benefits detected in the listing.
Pto