Data Engineer
DeWinter BH ·www.dewintergroup.com
Apply direct
Title: Data Engineer — MDM & Identity Layer (Snowflake)
Job Type: Contract
Contract Length: 3 months (with extension potential)
Pay Range: $60–$70/hour
Location: Remote (EST hours)
About the Opportunity:
Our client, a leader in data and analytics, is looking for a skilled Data Engineer to join their team for a 3-month engagement. This project involves building a canonical Master Data Management (MDM) identity layer on Snowflake, focused on mastering core entities—including Accounts, Contacts, Leads, Contracts, and Products—across multiple source systems. This is a high-impact, greenfield implementation role that requires a self-motivated professional who can hit the ground running, work from established architectural artifacts, and contribute to complex design decisions.
Key Responsibilities & Deliverables:
This role is focused on the successful implementation of a custom-build MDM solution. Your responsibilities will include:
We are looking for someone with a proven track record of successful data engineering engagements. The ideal candidate will have:
Job Type: Contract
Contract Length: 3 months (with extension potential)
Pay Range: $60–$70/hour
Location: Remote (EST hours)
About the Opportunity:
Our client, a leader in data and analytics, is looking for a skilled Data Engineer to join their team for a 3-month engagement. This project involves building a canonical Master Data Management (MDM) identity layer on Snowflake, focused on mastering core entities—including Accounts, Contacts, Leads, Contracts, and Products—across multiple source systems. This is a high-impact, greenfield implementation role that requires a self-motivated professional who can hit the ground running, work from established architectural artifacts, and contribute to complex design decisions.
Key Responsibilities & Deliverables:
This role is focused on the successful implementation of a custom-build MDM solution. Your responsibilities will include:
- Schema Implementation: Design and implement the physical Snowflake schema from logical models, including DDL, RBAC, and PII column tagging.
- Pipeline Development: Build and maintain robust ingestion pipelines from source systems (Salesforce, D365) into the Snowflake environment.
- Identity Resolution: Implement crosswalk patterns as identity reference spines, coding deterministic and probabilistic entity matching logic, including population of confidence scores and survivorship status fields.
- Writeback & Stewardship: Build the Salesforce ID writeback mechanism from the canonical model back to source CRM records and implement stewardship queues with conflict-flagging logic.
- Quality Assurance: Actively contribute to testing, data quality validation, and ongoing pipeline monitoring.
We are looking for someone with a proven track record of successful data engineering engagements. The ideal candidate will have:
- 5+ years of experience in data engineering, with at least 2 years of hands-on experience using Snowflake (DDL, ELT, streams, tasks, RBAC).
- Demonstrable experience implementing or operating an MDM or entity resolution program.
- Solid SQL skills and proficiency in at least one pipeline language (DBT is required; Python is strongly preferred).
- Experience with multi-source data ingestion from CRM and ERP systems (Salesforce, D365, or equivalent).
- A strong understanding of entity resolution concepts, including deterministic matching, probabilistic matching, blocking strategies, and confidence scoring.
- Ability to read and implement solutions from logical data models and formal data dictionaries.
Frequently asked questions
Who is hiring for the Data Engineer role?
DeWinter BH is hiring for the Data Engineer position, a Shazamme client. Apply directly on the employer's career site.
Where is the Data Engineer job located?
The Data Engineer role with DeWinter BH is based in Campbell, CA, US. The role is remote-friendly.
Is the Data Engineer role remote?
Yes — the Data Engineer position at DeWinter BH is remote. Candidates based in US are preferred.
What does the Data Engineer role pay?
DeWinter BH lists the Data Engineer role at up to USD 70 per hour.
Is the Data Engineer role full-time or contract?
This is a full time position at DeWinter BH.
What experience level is the Data Engineer role?
The Data Engineer position is aimed at mid-level candidates.
How do I apply for the Data Engineer role at DeWinter BH?
Apply directly on DeWinter BH's career page via the Apply button on this listing. ZammeJobs links straight through to the employer's ATS — no third-party form, no resume database.