Job Description
• Build the AIM master in Snowflake: a durable prospect/contact/address foundation used by campaign execution and downstream systems.
• Ingest and standardize data from AIQ, partner files, Oracle, Salesforce, suppression sources and mail-history feeds.
• Create GUID/ResidentID mapping, address standardization fields, dedupe logic, survivorship rules and audit tables.
• Persist suppression flags, customer/prospect indicators, partner options and mail-history records so campaigns do not rebuild the universe from scratch.
• Create data quality checks, freshness monitoring, schema validation and reconciliation reports for MVP 1.
MUST HAVE
• Deep Snowflake experience, including table design, performance, permissions and production data pipelines.
• Strong SQL and Python; dbt or equivalent transformation experience.
• Experience with ELT/ETL, source ingestion, schema validation, data quality testing and pipeline monitoring.
• Experience with iden...