At a Glance
- Tasks: Build and optimise data infrastructure for innovative marketing strategies.
- Company: Fast-scaling creative agency focused on growth for cool brands.
- Benefits: Competitive salary, generous holiday, tech budget, and flexible work options.
- Why this job: Join a dynamic team and make a real impact in data-driven marketing.
- Qualifications: 3-5 years in data engineering or analytics, with strong Python and dbt skills.
- Other info: Exciting career growth opportunities in a collaborative environment.
The predicted salary is between 36000 - 60000 £ per year.
Ballpoint is a fast-scaling, strategy-led creative and marketing science agency built for consumer brands who want to grow fast and grow properly. We combine creative, data, and experimentation to help cool brands kill their competition.
As a team, we are made up of people at the top of their game, all with exceptional experience and a strong track record. Ballpoint started because we knew first-hand what ambitious brands actually need from an agency: not big promises and account handlers, but operators who treat their business like it's their own. Today, every Ballpoint strategist is ex-in-house senior talent.
Our clients reflect who we are: early innovators, fast-growing startups, and household names pushing into their next phase of growth. Each brings a new challenge for us to break through creatively, strategically, and through marketing science.
About this role
You will be the architect of our internal data engine. You aren’t just running reports; you are building the infrastructure that makes reporting possible. You will move us away from fragile spreadsheets and manual exports to a robust, code-first Modern Data Stack.
Our Data Stack
- Ingestion: Weld
- Warehousing & ML: BigQuery and Vertex AI
- Transformation: dbt
- Orchestration: Airflow
- BI: Looker Studio
What This Role Involves
This is a Full Stack Analytics Engineering role. You will own the lifecycle of data from the API source to the final dashboard.
- Data Integration & Orchestration (ELT)
- Pipeline Architecture: You will own the ingestion layer, using Weld to pull data from Meta, Google Ads, Shopify, GA4, and other sources into BigQuery.
- Orchestration: You will manage the scheduling, dependencies, and monitoring of our data workflows using Airflow.
- Custom Ingestion: You will write custom Python scripts/extractors to fetch data where out-of-the-box connectors fail or are not available.
- Transformation, Quality & Observability (dbt)
- The Semantic Layer: You will build and maintain our dbt project.
- Data Quality & Testing: You will implement robust dbt tests to catch nulls, duplicates, and anomalies before they reach the client.
- Observability: You will set up alerts for freshness and quality failures.
- Advanced Analytics & Marketing Science
- Statistical Modelling: You will use Vertex AI and R/Python to support the team with Marketing Mix Modelling (MMM), incrementality testing, and customer lifetime value (LTV) forecasting.
- Business Intelligence: You will connect your clean dbt models to our BI tools to create self-service dashboards.
- Collaboration & Enablement
- Handover: Work directly with our fractional data analyst during the handover period.
- Empowerment: Arm the wider team with the tools, clarity, and insight they need.
- Approach: Bring a calm, methodical, commercially minded approach to the data.
Skills & Experience
You should have:
- 3–5+ years experience in an Analytics Engineering, Data Engineering, or technical Data Analysis role.
- dbt Mastery: Deep experience building dbt projects from scratch.
- Python & R: Strong proficiency in Python and R.
- Orchestration & Integration: Experience managing Weld and orchestrating workflows with Airflow.
- GCP Ecosystem: Hands-on experience with BigQuery and Vertex AI.
- Data Quality Focus: A strong track record of implementing automated testing and observability.
- Git/Version Control: Comfortable with the command line, branching strategies, and pull requests.
- Commercial Context: Practical familiarity with paid media, Shopify/DTC/SaaS models, and attribution.
What does success look like
- 30 Days: Audit, Stabilise & Quick Wins
- The Handover: You have fully absorbed the context from our fractional analyst.
- The Audit: You have mapped our data lineage.
- The Fix: You’ve set up dbt tests on our most critical tables.
- The Win: You have shipped one high-impact fix or automation.
- 60 Days: Migration & Standardisation
- Logic Migration: You have aggressively refactored our legacy reporting.
- Orchestration: Airflow is humming.
- Custom Ingestion: You have deployed a custom Python extractor.
- Trust: The Strategy team has stopped "double-checking" the dashboard numbers.
- 90 Days: Value, Science & Scale
- Advanced Modeling: You are leveraging Vertex AI or R/Python.
- Speed to Insight: You have templatised our onboarding.
- Proactive Partner: You are joining client strategy calls.
Package
- Competitive salary
- 28 days paid holiday excluding bank holidays
- £1,500 tech budget
- EMI Scheme
- Enhanced Parental Leave Policy
- Work from anywhere days
- Monthly socials
- Regular team lunches
- Annual offsite
Data Engineer & Analyst in London employer: Ballpoint
Contact Detail:
Ballpoint Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer & Analyst in London
✨Tip Number 1
Network like a pro! Get out there and connect with people in the industry. Attend meetups, webinars, or even just grab a coffee with someone who’s already in the game. You never know who might have the inside scoop on job openings!
✨Tip Number 2
Show off your skills! Create a portfolio or GitHub repository showcasing your projects and achievements. This is your chance to demonstrate what you can do beyond just a CV. Make it easy for potential employers to see your talent in action.
✨Tip Number 3
Prepare for interviews like it’s a big match day! Research the company, understand their values, and be ready to discuss how your skills align with their needs. Practice common interview questions and think of examples that highlight your problem-solving abilities.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about joining our team at Ballpoint!
We think you need these skills to ace Data Engineer & Analyst in London
Some tips for your application 🫡
Show Your Passion: When you're writing your application, let your enthusiasm for data engineering and analytics shine through. We want to see that you’re genuinely excited about the role and how you can contribute to our team at Ballpoint.
Tailor Your CV: Make sure your CV is tailored to highlight the skills and experiences that are most relevant to the Data Engineer & Analyst role. Use keywords from the job description to show us you understand what we're looking for.
Be Clear and Concise: Keep your application clear and to the point. We appreciate well-structured applications that get straight to the heart of your experience and how it relates to the role. Avoid fluff and focus on what matters!
Apply Through Our Website: Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows you’re keen to join our team at Ballpoint.
How to prepare for a job interview at Ballpoint
✨Know Your Data Stack
Familiarise yourself with the tools mentioned in the job description, like BigQuery, dbt, and Airflow. Be ready to discuss how you've used these technologies in your previous roles and how they can be applied to Ballpoint's needs.
✨Showcase Your Problem-Solving Skills
Prepare examples of how you've tackled complex data challenges in the past. Highlight your ability to think critically and act quickly, as this is crucial for a role that requires ownership and decision-making.
✨Demonstrate Your Curiosity
Ballpoint values people who are always learning. Be prepared to discuss recent trends in data engineering or analytics that excite you, and how you stay updated with industry developments. This shows your passion for the craft.
✨Communicate Clearly
Practice explaining technical concepts in simple terms. You'll need to inspire confidence not just with your technical skills but also in how you communicate them to clients and teammates. Clarity is key!