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