Analytics Engineer - Custom Ad Reporting Pipeline
Short Term Contract / Freelance| Approx. 2 Months | Sydney based We're partnering with a fast-moving Full stack marketing agency looking for an experienced Analytics Engineer to help them as they build their own custom ad reporting platform.
This is a hands-on contract role where you'll design and deliver a scalable BigQuery-based ELT pipeline that consolidates marketing and advertising data into clean, reliable reporting marts.
You'll work across multiple data sources including Funnel.io (or Windsor.ai), Google Sheets, and custom client conversion logic to create a normalised reporting layer used by internal stakeholders and external clients.
What You'll Be Doing
- Build and maintain ELT pipelines in BigQuery
- Develop scalable data models and reporting marts using dbt
- Integrate and transform advertising platform data from sources such as Meta, Google Ads, DV360, and similar platforms
- Manage data ingestion from Funnel.io, Windsor.ai, Google Sheets, and related connectors
- Collaborate with marketing and media strategy teams to ensure reporting accuracy and usability
- Implement CI/CD practices using GitHub Actions or equivalent tooling
- Optimise performance and cost efficiency within BigQuery
Must-Have Experience
- 3+ years building production-grade solutions on BigQuery
- Strong experience with dbt
- Advanced SQL skills and strong dimensional modelling fundamentals
- Experience with Git, Docker, and CI/CD tooling such as GitHub Actions
- Understanding of advertising platform data structures and the difference between ad-performance vs reach/frequency reporting
- Previous experience with Funnel.io, Windsor.ai, or similar ad-data connectors
Nice to Have
- Experience designing multi-tenant data warehouse environments
- Knowledge of authorised views and tenant-level IAM
- BigQuery cost optimisation experience
- Previous collaboration with media, marketing, or performance strategy teams
Why Apply?
- High-impact short-term project with ownership from day one
- Flexible working arrangements
- Opportunity to shape the reporting infrastructure for a growing platform
- Work with modern data tooling across the marketing analytics space
Sydney based - 3 days in CBD office
Approx 2 months - confirmed length once candidate has had full brief with Technology Director
Day rate - Flexible for the right candidate and experience dependant ($1,000 per day upwards)
Perfect for freelancer or someone in between jobs wanting to work on a meaningful project.
