Job Description: Integration & Data Analyst (3-5 years)
Position Overview:
Key Responsibilities
1. Ecometry Integration and Management
- Manage mass setup and batch update processes within Ecometry.
- Develop and streamline batch import procedures for offers and promotional pricing.
- Coordinate offer code creation for campaign and segment tracking.
2. Salesforce Integration & Workflow
Evaluate and integrate Ecometry batch update processes into Salesforce workflows.
Facilitate migration and ingestion of campaign and offer history data into Salesforce.
Participate actively in Salesforce discovery sessions to ensure effective integration and migration strategies.
3. Amperity Data Management
- Oversee integration and ingestion of campaign, customer engagement, and behavioral data into Amperity from platforms like Adobe, Listrak, Five9, and Salesforce.
- Manage data segmentation use cases within Amperity, particularly email and dial/contact engagement data.
- Coordinate direct integrations between Amperity and external platforms (Listrak, Adobe, Salesforce).
4. Customer Data Maintenance
- Execute data cleanup initiatives, including archiving customer transaction records and reducing data footprint.
- Ensure synchronization of customer files across platforms (Ecometry, Salesforce, Amperity).
- Manage data maintenance tasks such as address verification, standardization, and compliance management (DNP, CCPA, GDPR).
5. CRM and Call Center Data
Facilitate the migration of call center engagement data and CRM notes into Salesforce.
Ensure accurate tracking and integration of inbound and outbound communication activities.
6. Compliance and Data Governance
Maintain compliance standards (CCPA/GDPR) across data management practices.
Regularly evaluate and implement improvements in data governance and management processes.
Technical Skills Required:
Strong proficiency with Salesforce CRM (Marketing Cloud, Service Cloud).
Experience with Ecometry, including offer and pricing batch processes.
Hands-on experience in customer data platforms (Amperity preferred).
Familiarity with email marketing platforms (Listrak).
Experience with data migration projects and integrations (Five9, Avaya).
Data handling and transformation experience (Excel, SQL, batch processing).
Knowledge of compliance standards (CCPA/GDPR).
Additional Skills & Qualifications:
Excellent analytical and problem-solving abilities.
Strong interpersonal and communication skills.
Ability to manage multiple projects and priorities simultaneously.
Proactive attitude towards continuous improvement and innovation in data processes.
Bachelor’s degree in IT, Computer Science, Business Administration, or a related field.
Preferred Experience
Background in retail or e-commerce.
Experience in digital marketing and customer segmentation.
Previous involvement in CRM migrations and integrations.
Reporting To:
- [Data Integration Manager, CRM Lead]
Join our team and play a key role in driving efficient data management and integration processes that enable our business to deliver exceptional customer experiences and insights.