Marketing Campaign Data Analyst

[jo1]

Marketing Campaign Data Analyst

3-6 month opportunity

About the Gig:

As the Marketing Campaign Data Analyst, your role is divided between the SIMplus and M8 brands Mobile offering.

You will be responsible for extraction, manipulation and supply of campaign data to manage retention & migration campaigns. In addition the role requires ad-hoc reporting requirements and analysis to provide insights into the customer bases for business users. You will be recognised as a key ‘power-user’ for all database and analysis software with plenty of opportunity to get your hands dirty with Marketing’s data requirements.

Key Aspects of the Role:

Replicate in Cognos Impromptu all data extracts for Retention/Migration Campaign activity which will be used for internal and external contact centre channels

Use Cognos Impromptu and filtering for the extraction of SIMplus and M8 data to support ongoing calling activity for internal teams and external parties

Supply data in a timely manner (as per agreed calendar) via secure FTP sites

Maintain a quarterly rolling data supply calendar for Retention/Migration Campaign

Maintain documentation of changes made to campaign supply (as driven by the Retention Manager/Migration).

Ad-hoc data extraction and subsequent analysis to produce customer insights and recommendations for various departments in the business

Use customer data to ‘draw a picture’ to demonstrate trends such as customer behavioural patterns, changes in usage, attrition/loyalty patterns, etc

Provide conversion reporting for inbound and outbound leads provided internally

Assist with the delivery of new campaigns, including preparing internal documentation and working with vendors to ensure timely campaign delivery

Assist with managing ad-hoc IT system changes for retention/migration activity

Apply “Customer Notes†to the database for marketing campaigns so customer facing users can see activity at a customer level

Providing analytical insights to people from different departments on an ad hoc basis

Wrap up campaign analysis reporting

Major challenges in this role:

Ensuring 100% accurate and timely delivery of essential information for Senior Management meetings

Managing multiple projects and objectives – balancing necessary day to day reporting and campaign list management whilst prioritising longer term project-related research and analysis

Designing reporting frameworks and creating reports from scratch for fellow team members

Using the customer database to gain insights into the success of campaigns, reasons behind churn / growth, customer behaviour and usage trends

About You:

Knowledge & Experience Required

You must have superb attention to detail and be very accurate in your work

Minimum 3-5 years experience in marketing analysis or similar roles

Strong analytical skills, a good understanding of data warehouse extraction methods, data analysis principles and commercial acumen

Familiarity with data analysis software used for marketing purposes including Cognos Impromptu, campaign management of data and advanced skills in using Microsoft Access and Excel. This means you will be a ‘power-user’ in all main data extraction and analysis software used in the business.

Ability to draw insights from raw data - providing analysis support to management in terms of ‘what happened?’, ‘why?’ and ‘what next?’

Self motivated, with the ability to work effectively alone or as a member of both the marketing team and wider company teams across all levels of the company

Interested in seeing the impact and success of what you do

Enjoy working in a dynamic environment

A concern for quality and customer focus

Flexibility in working with people and time

§ Tertiary qualifications in Commerce / Business / Finance or Marketing are desirable