Marketing Solutions Architect
CurrentResponsible for designing, developing, and maintaining Prosper's marketing stack to meet business requirements for communications. Includes SMS, Push, Email, and InApp messaging channels for both commercial and transactional use cases, leveraging a suite of big data solutions under GCP and Iterable.• Oversee and maintain Prosper's Iterable instance and the broader digital marketing technology stack.• Build SQL models in dbt that power analytics dashboards and audience selection.• Develop/manage a Python-powered 'marketing solutions' library that automates mundane tasks (including a database snapshot of template and campaign metadata, plus a Jupyter environment to work in-memory).• Evaluate design outcomes to ensure technical objectives are met for new projects.• Collaborate with the data engineering team to ensure data tables are processed, transferred, recorded, and utilized effectively.• Ensure the accuracy and reliability of API event systems to marketing tools.• Oversee integration with external tooling or third party software to enhance the existing stack.• Leverage BigQuery to dive into tables for quality assurance, campaign troubleshooting, and audience selection.• Manage user-level Email, Push, and SMS journeys, including holistic implementation criteria for quality assurance (duplication, receipt, data implementation, etc.).• Manage content and delivery of outbound webhooks from Iterable to internal databases (Cloud Functions, GCP Data Lake, BigQuery).• Define user segmentation, audience sizing, and manage existing audience buckets defined in communication journeys (BigQuery, Postman, Python).• Conduct tasks related to Google Analytics (GA4), Google Ads and Google Tag Manager, ensuring accurate tracking and reporting of marketing data.• Collaborate with internal stakeholders to write data requirements for new marketing communications and enhancements to existing campaigns (Jira, Atlas, Confluence).