At a Glance
- Tasks: Build scalable data models and lead end-to-end model development for a major telecom client.
- Company: Join a dynamic telecom company in Central London with a hybrid work model.
- Benefits: Competitive day rate, flexible working, and the chance to work on impactful projects.
- Why this job: Make a real difference by transforming data into reliable insights for key business teams.
- Qualifications: Expert SQL skills, experience with GCP BigQuery, and strong analytical abilities required.
- Other info: Opportunity for professional growth in a fast-paced, collaborative environment.
Contract Role: Analytics Engineer – Telecom | Central London (Hybrid)
Location: Central London — 2 days per week onsite
Contract: 6 months initially
Day Rate: £450–£540 (Inside IR35)
Start: ASAP
We’re hiring an Analytics Engineer to support a major telecom client. This role sits between data engineering and analytics, building clean, scalable data models that fuel reliable insights across commercial, finance, and planning teams.
What You’ll Do
- Build scalable data models (marts, business layers, OBTs) that act as a single source of truth.
- Lead end‑to‑end model development: requirements → build → testing → documentation → CI/CD deployment.
- Uphold high coding standards in SQL and dbt; review and maintain clean, well‑structured analytics code.
- Ensure data quality & PII protection using tests, validation, and secure handling practices.
- Troubleshoot data issues across source → transformation → BI layers, owning fixes end‑to‑end.
- Optimise & refactor existing models for performance and cost (BigQuery).
- Manage orchestration & environments, including dev/prod troubleshooting.
- Analyse new data sources and design models accordingly.
- Communicate clearly with stakeholders, explaining technical concepts in plain language.
- Own technical debt, documenting issues and advocating for resolution.
What You Bring
Essential
- Expert SQL and advanced query writing
- Strong data modelling (dimensional, marts)
- Hands‑on experience with GCP BigQuery
- Strong dbt Cloud/Core experience
- Excellent analytical, debugging, and problem‑solving skills
- Ability to trace lineage and diagnose issues independently
- Experience with CI/CD, branching, merging, conflict resolution
- Understanding of data quality frameworks & PII standards
- Clear communication with technical and non‑technical stakeholders
Desirable
- Broader knowledge of modelling best practices
- Agile delivery experience
- Exposure to BI tools (Tableau etc.)
- Query performance tuning & cloud cost optimisation
- Strong ownership and independent working
- Mentoring or community contribution experience
If you have the required skills & experience, please apply promptly to be considered.
Analytics Engineer in Guildford employer: Queen Square Recruitment
Contact Detail:
Queen Square Recruitment Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Analytics Engineer in Guildford
✨Tip Number 1
Network like a pro! Reach out to your connections in the telecom and analytics space. A quick chat can lead to opportunities that aren’t even advertised yet. Don’t be shy; we all love a good natter!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your data models and projects. Use platforms like GitHub to share your work. We want to see what you can do, so let’s make it easy for potential employers to find you!
✨Tip Number 3
Prepare for those interviews! Brush up on your SQL and dbt knowledge, and be ready to discuss your past projects. We recommend practising common interview questions related to data modelling and problem-solving to boost your confidence.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we’re always on the lookout for talented individuals like you, so don’t miss out on the chance to join us!
We think you need these skills to ace Analytics Engineer in Guildford
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights the skills and experiences that match the Analytics Engineer role. Use keywords from the job description to show we’re on the same page!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Share why you’re excited about this role and how your background makes you the perfect fit for our team at StudySmarter.
Showcase Your Projects: If you've worked on relevant projects, don’t hold back! Include examples of data models you've built or issues you've solved, especially those that demonstrate your SQL and dbt skills.
Apply Through Our Website: We want to hear from you! Make sure to apply through our website to ensure your application gets the attention it deserves. We can’t wait to see what you bring to the table!
How to prepare for a job interview at Queen Square Recruitment
✨Know Your Data Models
Make sure you brush up on your data modelling skills, especially dimensional models and marts. Be ready to discuss how you've built scalable data models in the past and how they served as a single source of truth for your team.
✨Show Off Your SQL Skills
Prepare to demonstrate your SQL prowess during the interview. Have examples ready where you've written complex queries or optimised performance, and be prepared to explain your thought process behind them.
✨Communicate Like a Pro
Since this role involves liaising with both technical and non-technical stakeholders, practice explaining complex concepts in simple terms. Think about how you would describe your previous projects to someone without a technical background.
✨Be Ready to Troubleshoot
Expect questions around troubleshooting data issues. Prepare some scenarios where you identified and resolved problems across the data pipeline, and be ready to discuss the steps you took to ensure data quality and PII protection.