About us:

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.

This is a 6 month contract position.

Key responsibilities:

• Make Data Usable for Customer-Facing Teams: Holistics is powerful but inaccessible for CS and AM day-to-day use. We need structured reporting, views, and outputs that translate complex datasets into clear, actionable insight that teams can confidently use with clients.
• Support Client-Facing Reporting & QBRs: Our clients increasingly request bespoke analysis for QBRs (adoption trends, usage patterns, ROI signals, forecasts). We need an analyst who can interpret these requests, shape the right data response, and support clear client communications—even if not client-facing directly.
• Proactive Insight, Not Just Reporting: Beyond reactive requests, we need someone who can proactively explore the data, identify patterns, form hypotheses, and surface insights that help CS and AM teams build stronger narratives around value, adoption, and growth opportunities.
• Partner Closely with Product on Usage & Behavioural Data: The role will work closely with the Product team to interpret data from tools such as Amplitude, helping build a clearer understanding of how users engage with Pencil — including feature usage, workflows, and time spent in the platform. These insights will benefit Product by informing roadmap prioritisation, identifying friction or drop-off points, and grounding product decisions in real customer behaviour.
• Bring Analytical Rigor to a Fast-Growing Business: As Pencil evolves quickly, we need someone with a strong data analysis background who can introduce new frameworks, perspectives, and considerations—helping us mature how we think about customer data, success metrics, and storytelling at scale.

Your background:

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

KPIs & Success Measures

• Clear, repeatable client-ready reporting structures derived from Holistics
• Faster, higher-quality responses to QBR and ad-hoc client data requests
• Stronger insight-led narratives used by CS and AM in renewals and growth conversations
• Meaningful usage and behavioural insights shared with Product from Amplitude data
• Improved understanding of feature adoption, workflows, and engagement patterns
• Improved internal confidence in data across customer-facing and product teams