BI / Campaign Reporting Analyst required to join a campaign execution team. The client is an Australian house hold name with massive amounts of customer data, a strong leadership team and a flexible work environment!!
Role:As a mid level SQL Data Analyst, ideally with exposure to customer campaigns or marketing data, you will be responsible for a wide range of data work; including data processing, preparation, cleaning and writing complex queries. The role could suit candidates with either a BI or an analytics background.
Responsibilities include: - Main responsibilities would involve SQL work to help prepare data for their marketing campaign team
- Working with marketing and campaign execution teams on the planning and development of marketing campaigns and event based triggers
- Query campaign data stores and customer analytics database using SQL to build datasets that are the single version of the truth on campaign performance & deliver the results into self-serve dashboards
- Work with Core analytics teams to ensure that existing data quality is constantly improved
To be successful in this role you will: - 3-6 yrs experience in either: Data SQL Analysis, Data Migration, Campaign Analysis, database marketing or customer analytics role.
- Advanced SQL
- Any experience with Alteryx or GCP would be a bonus
- Strong BI reporting tools and experience
- Automation / scripting - a bonus
- Ideally be familiar with campaign management tools
- Python would also be a bonus