At a Glance
- Tasks: Transform complex data into clear insights that drive business decisions and storytelling.
- Company: Join Pencil, a leader in innovative advertising technology with a mission to empower creativity.
- Benefits: Flexible contract role with opportunities for professional growth and skill development.
- Other info: Dynamic team environment focused on collaboration and innovation.
- Why this job: Be at the forefront of AI in advertising and make a real impact on small businesses.
- Qualifications: Advanced SQL skills and experience with data analysis and reporting tools.
The predicted salary is between 40000 - 50000 £ per year.
At Pencil, we are driving innovation in advertising technology through our state-of-the-art SaaS product, which harnesses Generative AI to redefine content creation. Our mission is to make AI the default in advertising without replacing creative people. To achieve this, we need to make sure that our technology isn’t just in the hands of big brands - we need to try to help small businesses and creative individuals too.
You will own and elevate Pencil’s customer and product analytics by turning complex datasets into clear, trusted insights that Customer Success, Account Management, and Product teams can use every day. Build structured reporting and reusable views that support QBRs, bespoke client analysis, and proactive storytelling around adoption, value, and growth opportunities.
Requirements- Advanced SQL
- Strong experience writing complex SQL queries across large, messy datasets
- Confident with joins, window functions, time-series analysis, cohorts, and retention queries
- Able to build reliable, reusable datasets that power dashboards and reporting
- Business Intelligence & Reporting
- Hands-on experience building dashboards and reports for non-technical stakeholders
- Ability to design clear, intuitive reporting that customer-facing teams can trust and use
- Experience creating reusable views / semantic layers and defining consistent metrics
- Experience with Holistics is a strong plus (Looker, Tableau, Power BI also acceptable)
- Product Analytics
- Experience working with product usage and behavioural data in tools such as Amplitude
- Comfortable analysing funnels, retention, cohorts, workflows, and feature usage
- Able to identify drop-offs, friction points, and meaningful usage patterns
- Data Interpretation & Insight Generation
- Ability to translate open-ended business questions into clear analytical approaches
- Comfortable forming hypotheses, exploring data proactively, and surfacing insights
- Strong judgement on what is “signal vs noise” in customer and usage data
- Data Storytelling
- Able to turn complex analysis into clear, structured narratives
- Comfortable producing outputs for QBRs, internal reporting, and customer success storytelling
- Strong spreadsheet skills (Excel / Google Sheets) for polished, human-friendly outputs
Data Analyst - Contract employer: Pencil
At Pencil, we pride ourselves on fostering a dynamic and inclusive work culture that champions innovation and creativity. As a Data Analyst, you will have the opportunity to work with cutting-edge technology in a collaborative environment that values your insights and contributions. We offer robust professional development opportunities, competitive benefits, and a commitment to supporting both small businesses and creative individuals, making us an exceptional employer for those seeking meaningful and rewarding employment.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst - Contract
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect with potential colleagues on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your data analysis projects, dashboards, and reports. This gives you a chance to demonstrate your expertise and makes you stand out from the crowd.
✨Tip Number 3
Prepare for interviews by practising common data analyst questions and scenarios. Think about how you can explain your analytical process and insights clearly, especially for non-technical stakeholders.
✨Tip Number 4
Don’t forget to apply through our website! We’re always looking for talented individuals who can help us drive innovation. Plus, it’s a great way to ensure your application gets seen by the right people.
We think you need these skills to ace Data Analyst - Contract
Some tips for your application 🫡
Tailor Your CV:Make sure your CV speaks directly to the job description. Highlight your SQL skills and experience with complex datasets, as these are key for the Data Analyst role. We want to see how your background aligns with our mission at Pencil!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to tell us why you're passionate about data analytics and how you can help elevate our customer and product insights. Keep it engaging and relevant to the role.
Showcase Your Projects:If you've worked on any relevant projects, don’t hold back! Include links or descriptions of dashboards you've built or analyses you've conducted. We love seeing real examples of your work that demonstrate your skills.
Apply Through Our Website:We encourage you to apply through our website for a smoother process. It helps us keep track of applications and ensures you get all the updates directly from us. Plus, it shows you're keen on joining our team!
How to prepare for a job interview at Pencil
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be ready to discuss complex queries, joins, and window functions. Practising with messy datasets can help you feel more confident when tackling real-world problems.
✨Showcase Your Dashboard Skills
Prepare to talk about your experience with building dashboards and reports. Bring examples of your work, especially if you've used tools like Holistics, Looker, or Tableau. Highlight how your dashboards have helped non-technical stakeholders make informed decisions.
✨Master Data Storytelling
Think about how you can turn data into compelling narratives. Be ready to explain how you've translated complex analyses into clear insights for different teams. Practice explaining your findings in a way that anyone can understand, focusing on the 'why' behind the data.
✨Be Proactive with Insights
Demonstrate your ability to identify trends and insights from data. Prepare examples where you've proactively explored data to surface meaningful patterns or solve business questions. Show that you can distinguish between what's important and what's just noise.
