Senior Marketing Data Analyst
Current✓ Developed campaign workflows, test email templates, and scheduled email deliveries in Adobe Campaign Classic, resulting in improved campaign efficiency.✓ Performed segmentation using Adobe and T-SQL to identify prospects for email campaigns and outbound calls..✓ Developed a marketing data warehouse in MS SQL Server and managed data feeds to support BI reporting and Power BI visualizations.✓ Oversaw various data extraction processes, including AGM (Annual General Meeting) data, statement mailings, and regulatory communications.✓ Implemented ‘always on’ campaigns for financial products, including CTF maturity accounts, TESP, ISA, LISA, and cancelled DD notifications, enhancing customer engagement.✓ Prepared detailed reports on marketing KPIs, analysing conversion rates, website traffic, social media engagement, and email campaign metrics (delivery, open, click-through rates) using Adobe Campaign Classic and Google Analytics.✓ Worked closely with product, marketing, and sales teams to identify cross-sell opportunities, resulting in increased customer acquisition.✓ Partnered with the outbound sales team to develop a CACI customer profiling dashboard and outbound call lead generation files using Fresco segmentation, maximizing conversion rates.✓ Ensured stakeholders had clear access to data insight and collaborated with vendors as needed to fulfil role responsibilities.TOOLKIT: T-SQL | Power BI | Python | Adobe CMT | Emarsys | Google Analytics | Testlocal | DevOps