[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.ResponsibilitiesDesign and implement the physical Snowflake schema from logical models, including DDL, RBAC, and PII column taggingBuild and maintain robust ingestion pipelines from source systems (Salesforce, D365) into the Snowflake environmentImplement crosswalk patterns as identity reference spines, coding deterministic and probabilistic entity matching logic, including population of confidence scores and survivorship status fieldsBuild the Salesforce ID writeback mechanism from the canonical model back to source CRM records and implement stewardship queues with conflict-flagging logicActively contribute to testing, data quality validation, and ongoing pipeline monitoringSkills5+ 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 programSolid 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 scoringAbility to read and implement solutions from logical data models and formal data dictionariesCompany OverviewThe DeWinter Group is the Bay Area's premier provider of accounting, finance, & IT staffing & recruiting. It was founded in 2000, and is headquartered in Campbell, California, USA, with a workforce of 201-500 employees. Its website is https://www.dewintergroup.com/.