[Remote] Data Engineer
Note: The job is a remote job and is open to candidates in USA. DeWinter Group is a leader in data and analytics, seeking a skilled Data Engineer for a 3-month contract engagement. The role focuses on building a Master Data Management (MDM) identity layer on Snowflake, requiring expertise in schema implementation, pipeline development, and identity resolution.
Responsibilities
- Design and implement the physical Snowflake schema from logical models, including DDL, RBAC, and PII column tagging
- Build and maintain robust ingestion pipelines from source systems (Salesforce, D365) into the Snowflake environment
- Implement crosswalk patterns as identity reference spines, coding deterministic and probabilistic entity matching logic, including population of confidence scores and survivorship status fields
- Build the Salesforce ID writeback mechanism from the canonical model back to source CRM records and implement stewardship queues with conflict-flagging logic
- Actively contribute to testing, data quality validation, and ongoing pipeline monitoring
Skills
- 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
Company Overview