Consultant - Campaign Analytics - Internet/Online

Role and Responsibilty :

You're Awesome At :

- Translating the marketing requests into actual output that will touch the customers or prospects.

- Marketing and technical database system/campaign management software.

- Identifying and resolving potential issues before campaign execution and possess a detailed knowledge of the entire campaign process.

You'll Be Improving & Responsible For :

- Educating the business perspectives on new approaches for audience selection, such as data usage and statistical validation data

- Maintaining the definition requirements for reporting tools

- Performing data-mining searches from the data warehouse

- Generating insight into customer segments for use within business development and other CRM initiatives

- Initiating, driving and supporting CRM, 1PD, 2PD and 3PD activities using data

- Data Science & analytics (Logistics regression/Time series modelling/ trend analysis) while maintaining data integrity

- Providing data metrics (clarity, accuracy, depth and recommendations) to business and all stakeholders

- Providing reporting support to Key Account Management program for APAC & EMEA

- Campaign list creation and management (for both email and business development campaigns).

- Analysing ongoing and end-of campaign results

- Using SQL Server and Excel to prepare accurate marketing campaign lists and reports

- Managing CRM lifecycle eDM series to ensure candidates and clients are fully engaged at the right time with the right communication

- Identifying growth, cross sell, up sell and retention opportunities within the database

- Preparing Audience in DMP for campaigns and track performance

- Ensure campaign tracking reports measure results consistently across all divisions and regions

- Liaising with key Stakeholders to ensure customer master database are maintained well

- Provide support within the CRM team on cross functioning roles

Your Experience Across The Years in the Roles You've Played -

- Minimum 2-4 years of experience working closely with data/ reporting in a SQL Server/Redshift environment or CRM, DMP, Google analytics/ Omniture

- Experience communicating or reporting to senior stakeholders

- Experience in PowerBI, Exact Target, GA, Adobe, DMP, Datorama and SQL Experience in website scrapping and statistical predictive modelling will be highly advantageous

- Strong Excel reporting skills (Macro, Pivot table, V-lookup etc)

- Identifying best practice and reporting function methodologies

- Business systems and operational experience in Marketing Analytics, Performance marketing or campaign analytics

- Experience of utilising data analysis

- Embrace and initiate change Building strong internal and external relationships

- Hands-on experience such as SQL data extraction, running campaigns, driving projects, prepare proposal and make presentation to senior management will be highly advantageous