Data Analyst
Campfire is where the best stories are shared. 📖 Social-first marketing experts, translating brand messages into content that travels online. 📱 We understand why people do what they do online. ⚙️
We usually respond within three days
Campfire is an award-winning Social first digital agency, founded on the values of Honesty & Integrity, First Principle Thinking, and Exceeding Expectations. Holding some of the world’s leading brands on our client roster, we pride ourselves on innovating and creating performance-driving firsts for our clients.
As social translators, it’s our job to take a client’s message and translate it into the perfect campaign and content for the platforms they’ll live on.
We believe in meritocracy. If you want to work for an agency that will invest in you and your career, Campfire is the right place for those willing to step up and deliver as part of the team and for our clients. With quarterly PDPs rather than annual, your career can move as quickly as you do.
As a progressive agency, our teams enjoy a number of benefits including (but not limited to) hybrid working, flexi-time, wellness days/benefits, and birthdays off.
Job Summary:
As Data Analyst, you will play a crucial role in overseeing our data warehousing transition to BigQuery and extracting valuable insights from our data. You will be responsible for ensuring the successful migration of our data systems and using your expertise in SQL, data visualization, and analytics to develop comprehensive reporting dashboards. Your role will be key in providing data-driven insights.
Key Responsibilities:
-
Data Strategy and Warehouse Transition:
Lead the comms with our supporting agency on the strategic transition of data warehousing from Google Sheets to BigQuery.
Develop a comprehensive plan for data migration, ensuring minimal disruption to ongoing operations.
-
BigQuery Database Management:
Establish, optimize, and maintain BigQuery databases with our supporting agency.
Ensure database security, integrity, and scalability to support growing data needs with our supporting agency.
-
Advanced Dashboard Creation:
Design and implement sophisticated dashboards for internal reporting on key metrics such as revenue, margins, and cost-income analysis.
Develop campaign-specific dashboards to provide insights on influencer, paid media, and organic social performance.
-
Data Visualization and Reporting:
Utilize advanced data visualization techniques to present complex data in an accessible format.
Create and automate regular reports for internal stakeholders and clients, providing actionable insights.
-
Cross-Departmental Collaboration:
Work closely with various teams to understand their data needs and integrate these into the overall data strategy.
Provide data-driven recommendations to support decision-making across the company.
-
Innovation and Continuous Improvement:
Stay abreast of the latest trends and developments in data analytics and visualization.
Continually seek opportunities to enhance data processing, analysis, and reporting capabilities.
Qualifications:
Proven expertise in SQL and data visualization.
Strong analytical and logical skills, akin to an analytics engineer.
Experience with BigQuery or similar data warehousing solutions.
Demonstrated ability in building and maintaining data dashboards.
Ability to collaborate effectively with senior leadership to turn business needs into data solutions.
Forward-thinking, with a talent for process improvement.
Excellent communication and teamwork skills.
This position offers a unique opportunity to be at the forefront of data transformation at Campfire, providing strategic insights that shape our decision-making and client strategies. Your role will be a blend of technical expertise, strategic thinking, and visionary leadership, crucial for our continued success in the ever-evolving digital marketing landscape.
- Locations
- Campfire HQ
- Remote status
- Hybrid Remote
Campfire HQ
Perks & Benefits
-
Hybrid Working 🏢
We currently ask for 2 days a week spent in the office, the rest is up to you!
-
Flexi-time hours ⏱
Our hours are 9 - 5:30, but when you work those are up to you! We aim to keep meetings and calls within 10-4 too.
-
25 days leave EXCLUDING bank holidays 🏝
We offer 25 days' leave on top of yearly bank holidays.
-
Your birthday off, every year! 🥳
This is additional to your leave... have a day off... it's your birthday after all.
-
An extra day of leave with each year's service ❤️
Just something to say thank you for sticking with us.
-
Wellness & Team fun budgets 💳
We've set aside budget for team meals, nights out and social events, as well as individual wellness days.
-
Closed at Christmas 🎅🏻
We believe rest is important. At Christmas, we operate on a skeleton team, to ensure we can effectively close at Christmas and spend time with our familys.
-
Our promise on our Culture 📕
The Founding team of Campfire spent a lot of their careers in fast-paced, highly demanding jobs that made them question the age-old 'agency lifestyle'.
We don't believe the best work is created under immense stress and consistent 12-hour work days.
We believe in world-class work, which we believe is only achieved through high performance, and high performance requires balance and rest.
My promise to you is to ensure the workload is balanced, for as long as you continue to deliver world-class work.
Data Analyst
Campfire is where the best stories are shared. 📖 Social-first marketing experts, translating brand messages into content that travels online. 📱 We understand why people do what they do online. ⚙️
Loading application form
Already working at Campfire?
Let’s recruit together and find your next colleague.