Job Description
Job Title: Data Engineer-II
Job Duration: 06 months
Est. Pay Range: $65 (USD) hour.
Location: Remote
Working Shift: M-F 9am - 5pm Time zone flexibles
JOB DESCRIPTION
Key Responsibilities
Required Skills
Job Duration: 06 months
Est. Pay Range: $65 (USD) hour.
Location: Remote
Working Shift: M-F 9am - 5pm Time zone flexibles
JOB DESCRIPTION
- 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.
Numbers & Facts
| Location | remote, VA (Remote) |
| Industry | Staffing/Employment Agencies |
| Salary | $1 |
| Company Size | 2,000 to 2,499 employees |
| Year Founded | 2000 |
| Website | http://www.lancesoft.com/ |
About Company
We are a $125 Million, NMSDC-certified Minority & Woman owned Workforce Solutions Company headquartered in the DC metro area with presence across US with global presence - Canada, Mexico, India, UK, Malaysia, Indonasia, Hongkong, Singapore, UAE. We are specialized in providing Workforce Solutions, SOW project delivery, Engineering Solutions, Creative Services. We currently support 100+ Fortune companies globally and across multiple industry segments. We are currently supporting several massive programs across industry segment nationally/globally (Intel, Ally, AMD, QUALCOMM, Morgan Stanley, Kraft/ Mondelez, MNP, Amdocs, Dell, SanDisk, Medtronic, Becton Dickinson, GE, Lockheed Martin, UTC, L-3 Communications, Caterpillar, BMW, Mercedes Benz, National Grid, Dominion, Energy Future Holdings, PSEG, 3M, Fidelity, Aetna, Humana, Johnson & Johnson, Pfizer, Merck etc).
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender, identity, national origin, disability, or protected veteran status.
Skills
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesResume Builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Resume Builder