ROLE SUMMARY
You will be involved in helping us implement reporting solutions for our growing Marketing Intelligence service. This will involve working in data collection, cleansing, harmonisation and visualisation. This role is for a proactive, improvement-oriented person with great attention to detail who has a passion for leveraging data to enhance lead generation, customer acquisition, and overall customer experience. You will use your foundational skills in data analysis but also be heavily supported and developed in this role.
ROLE REPORTS TO: Head of Analytics
EMPLOYMENT STATUS: Full Time
BUSINESS AREA: Specialist Roles and Support
KEY RESPONSIBILITIES
- Working with Advertising platform data from the likes of Google Ads, Meta, DV360, LinkedIn and more, you will ensure data accuracy, consistency, and integrity throughout the ETL process, utilising Funnel.io and Google Big Query.
- Manage inputs and data visualisation (Google Looker Studio) for client dashboards to present actionable insights.
- Use SQL to manage and manipulate tables in Google Big Query, enabling complex analysis and integration of data from multiple sources.
- Maintain detailed records of your work and task progress:
- In internal and client-facing Project Management software
- In a Data Dictionary
SELECTION CRITERIA – ROLE REQUIREMENTS
You have strong technical skills and experience:
- 2+ years working in a data analyst, business intelligence or reporting analyst role in the Advertising Industry
- Experience working with Digital Advertising Platform Data including DV360, Google Ads, Meta, LinkedIn and Snapchat among others, and familiarity with key Advertising success metrics.
- Experience with Data Visualisation requirements and tools including Google Looker Studio (preferred), Tableau or Power BI
- Advanced spreadsheeting skills – Google Sheets or Excel.
- Knowledge and proficiency in SQL and data querying techniques.
And you have the soft-skills that are needed to excel within Pivotus:
- A passion for your craft, constantly exploring new ways of leveraging data and solving problems.
- Proven experience building positive working relationships and working successfully in cross-functional teams, including demonstrated success in managing own work.
- Curiosity, and the understanding of its importance in a Data Analyst role.
- A need for attention to detail and thorough communications.
- Strong critical thinking skills – able to perform client-critical analysis with limited oversight.
- The ability to meet deadlines and prioritise workload in a busy environment
- A team orientation and proven superior customer service levels that compliments your independence as a specialist in your field
- A strong belief in the importance of our number one company value, ‘Absolute Honesty’.
Pivotus has a fully decentralised workforce and this role can be based in APAC, SEAsia or India.
Please submit your interest in this role by clicking on the below and sending your CV and any covering information that helps personalise your application.
Mail to: Michael@Pivotus.com.au
Subject: Data Analyst application – INSERT YOUR NAME HERE
