Overview In this role you will design and implement data harmonization and visualization for Marketing Cloud Intelligence, turning multi-source marketing data into insights. You'll lead API/ETL integrations and build advanced dashboards while safeguarding data governance for enterprise analytics. You work with cross-functional teams to optimize data pipelines and performance for high-volume datasets. This is a chance to shape marketing analytics at scale within a supportive, mission-driven bank and payments organization.
Compensation / Benefits- Healthcare (medical, dental, vision)
- Life insurance
- Disability insurance (short-term and long-term)
- Parental leave
- 401(k) retirement plan
- Paid vacation and holidays
Responsibilities- Design data models and harmonize disparate data sources (media, CRM, web, email) within MCI
- Build robust ETL pipelines, create custom connectors, and implement API integrations
- Configure calculated dimensions, measures, and complex widgets to support KPI frameworks
- Enforce data governance and naming conventions; optimize performance for large datasets
- Implement QA processes for data accuracy, testing, and deployment of systems
Key requirements- 5+ years in marketing data engineering, including 3+ years in Salesforce Datorama (MCI)
- Strong SQL skills; experience with API-based integrations; data modeling and ETL
- Deep understanding of marketing channels, KPI frameworks, and attribution
- Proficiency with CRM and marketing automation platforms
- Experience with data modeling, relational databases (SQL), data mapping, and API integration
- Knowledge of Salesforce schema, SOQL, Data Loader, ETL tools, and master data management
- Salesforce Certified Data Architect; Platform Data Architect; Marketing Cloud Intelligence Accredited Professional
- SQL
- API integrations
- data modeling
- ETL
- Salesforce Datorama (MCI)
- SOQL
