Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Transform complex telecoms data into clean, scalable models that drive business decisions.
- Company: Leading telecoms company focused on data-driven insights and innovation.
- Benefits: Competitive pay, flexible work environment, and opportunities for professional growth.
- Why this job: Be the architect of data solutions that directly impact business success.
- Qualifications: Expertise in SQL, dbt, and data modelling required.
- Other info: Join a dynamic team with a community mindset and excellent career advancement potential.
Sector: Telecoms
Location: London or Reading (2 days in office)
Pay Rate: £467.50 - £552.50 (Inside IR35)
Tech Stack: Google Cloud Platform (BigQuery), dbt (Cloud/Core), SQL
The Role: The Bridge Between Data & Decisions
In the world of Telecoms, the data is vast, but the insights need to be surgical. We are looking for an Analytics Engineer who lives exactly where Data Engineering meets Data Analysis. You won't just be moving data; you'll be the architect of the 'Single Source of Truth.' Your mission is to take raw, complex telecoms data and transform it into clean, scalable, high-quality models that power our Finance, Planning, and Commercial teams. If you're tired of 'black box' engineering and want to see the direct business impact of your code, this is the seat for you.
What You'll Be Doing
- Architecting the Truth: Design and implement scalable business-layer models, marts, and OBTs. You'll decide whether a dimensional model or a flat OBT is the right tool for the specific business problem.
- Owning the Lifecycle: You take business requirements and turn them into technical reality. You'll develop, test, document, and deploy via CI/CD, treating analytics code with the same rigour as software engineering.
- Enforcing Excellence: You'll be the gatekeeper for SQL and dbt standards. You'll lead code reviews that focus on logic, consistency, and future maintainability.
- Security & Integrity: Data quality isn't an afterthought-it's a critical defect. You'll implement generic and custom tests while ensuring PII is handled safely (masking, hashing, and access control).
- Deep-Dive Problem Solving: When a pipeline breaks or a number looks 'off,' you'll trace the lineage from source to BI layer, debugging failures independently until they're resolved.
- Performance & Cost Ops: You'll hunt for refactoring opportunities in older models and use BigQuery tools to optimize query performance and cloud costs.
- Stakeholder Storytelling: You'll explain technical 'why' in simple 'business.' You make sure downstream teams know exactly how a model change will affect their dashboards before you hit deploy.
Your Profile
The Must-Haves:
- Expert SQL: You write complex, performant queries and understand the 'under the hood' mechanics of cloud data warehouses (specifically GCP BigQuery).
- dbt Specialist: Strong hands-on experience with dbt Cloud or Core is essential.
- Modelling Pro: You understand dimensional modelling and how to structure data for varied business use cases.
- CI/CD Native: You're comfortable with branching, merging, rebasing, and resolving conflicts in a professional development environment.
- Analytical Detective: You have the 'lineage mindset'-the ability to trace data flows backward to find and fix the root cause of an issue.
The Nice-to-Haves:
- Experience in Agile environments and a deep understanding of the data development lifecycle.
- Familiarity with BI tools (like Tableau) so you can see the data through the eyes of the end-user.
- A background in Performance Tuning and cost optimization within GCP.
- A 'Community' mindset-whether that's mentoring others or contributing to internal forums and meetups.
Analytics Engineer - London or Reading in City of London employer: Stott & May Professional Search Limited
Contact Detail:
Stott & May Professional Search Limited Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Analytics Engineer - London or Reading in City of London
✨Tip Number 1
Network like a pro! Reach out to folks in the telecoms sector on LinkedIn or at industry events. A friendly chat can open doors that a CV just can't.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your SQL queries and dbt models. When you can demonstrate your work, it speaks volumes more than just words on a page.
✨Tip Number 3
Prepare for the interview by understanding the company’s data challenges. Research their current projects and think about how your skills can solve their problems. It’ll show you’re genuinely interested!
✨Tip Number 4
Don’t forget to apply through our website! We love seeing candidates who take the initiative. Plus, it gives you a better chance of getting noticed by our hiring team.
We think you need these skills to ace Analytics Engineer - London or Reading in City of London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV speaks directly to the role of Analytics Engineer. Highlight your experience with SQL, dbt, and GCP, and don’t forget to showcase any relevant projects that demonstrate your skills in transforming complex data into actionable insights.
Craft a Compelling Cover Letter: Your cover letter is your chance to tell us why you’re the perfect fit for this role. Share your passion for data and how you’ve tackled similar challenges in the past. Remember, we love a good story about how you made an impact!
Showcase Your Problem-Solving Skills: In your application, give examples of how you've debugged issues or optimised data models. We want to see your analytical detective skills in action, so don’t hold back on the details of your thought process and the outcomes.
Apply Through Our Website: We encourage you to apply through our website for a smoother application process. It’s the best way for us to keep track of your application and ensure it gets the attention it deserves. Plus, it shows you’re keen to join our team!
How to prepare for a job interview at Stott & May Professional Search Limited
✨Know Your Tech Stack Inside Out
Make sure you’re well-versed in Google Cloud Platform, dbt, and SQL. Brush up on your knowledge of BigQuery and be ready to discuss how you've used these tools in past projects. Being able to talk about specific examples will show that you’re not just familiar with the tech but can also apply it effectively.
✨Prepare for Problem-Solving Scenarios
Expect to face some technical challenges during the interview. Think about how you would approach debugging a broken pipeline or optimising a query. Practise explaining your thought process clearly, as this will demonstrate your analytical skills and ability to communicate complex ideas simply.
✨Showcase Your Modelling Skills
Be ready to discuss your experience with dimensional modelling and how you’ve structured data for different business needs. Prepare to explain your decision-making process when choosing between a dimensional model and a flat OBT, as this will highlight your understanding of the role's requirements.
✨Communicate Like a Pro
Since you'll be the bridge between data and decisions, practice explaining technical concepts in layman's terms. Think about how you would convey the impact of a model change to non-technical stakeholders. This skill is crucial for ensuring everyone understands the implications of your work.