Data Warehouse/Marketing Systems Engineer
Responsible for ensuring marketing data was gathered, current, correct, and available to marketing analysts to build targeted marketing campaigns. This included collecting/purchasing customer and prospect data, importing, cleansing, matching, standardizing, and consolidating it into a marketing data warehouse.• Successfully developed an email address and phone number cleansing and standardization process utilizing DataFlux and SQL Server• Responsible for managing marketing suppression including mail, phone, and email communications• Supported Marketing Analysts by gathering and maintaining a comprehensive database of all US attorneys and law firms enabling them to build a targeted campaign list• Developed and maintained an automated process to match customer lists from outside vendors to our marketing database to add key marketing attributes and maximize data quality• Continually improved system using SQL query tuning and analysis• Reduced marketing mailing costs by syncing addresses with the National Change of Address registry