At a Glance
- Tasks: Design and implement scalable data models while optimising performance and ensuring data quality.
- Company: Join a forward-thinking analytics team in a hybrid work environment.
- Benefits: Flexible working, competitive salary, and opportunities for professional growth.
- Other info: Dynamic role with a focus on innovation and collaboration.
- Why this job: Make an impact by solving complex data challenges and mentoring others in the community.
- Qualifications: Strong SQL skills and experience with GCP, BigQuery, and DBT required.
The predicted salary is between 45000 - 55000 £ per year.
Location: Reading/Paddington (Hybrid 2 days a week)
Skill Set: GCP, BigQuery, SQL, DBT. Candidate must have very strong SQL experience support with DBT for data modelling and transformation. Detailed JD attached, we need profiles mostly aligned with GCP.
- AE Community Engagement: Proactively shares knowledge, mentors others, and contributes to the wider analytics community.
- Coding Maintenance & Improvements: Identifies and implements opportunities to refactor and improve the existing codebase for better performance, readability, and efficiency.
- Coding Standards: Champions and enforces coding standards, ensuring the entire team produces consistent, high-quality, and well-documented code.
- Communication: Effectively communicates complex technical concepts to both technical and non-technical audiences.
- Critical Thinking: Goes beyond the immediate request to understand the underlying business problem and challenges assumptions.
- Data Exploration: Independently explores new datasets to validate quality, understand their structure, and identify potential uses.
- Data Modelling Techniques and Architecture: Designs and implements robust, scalable, and efficient data models and architectures.
- Development Lifecycle: Understands and follows the full software development lifecycle, including requirements gathering, development, testing, and deployment.
- Environment Configuration: Understands the development and production environments, and the configs within them, on the analytics platform.
- Impact Awareness: Understands the downstream impact of their work on other teams, systems, and business processes.
- Independent Working: Can take a high-level objective and break it down into smaller tasks, working autonomously to deliver the outcome.
- Industry Knowledge and Best Practice: Stays up-to-date with the latest trends, tools, and best practices in the data industry.
- Optimisation: Identifies and resolves performance bottlenecks in queries and data models.
- Quality Control & PII: Implements robust data quality testing and ensures the security and privacy of sensitive data.
- Resolving Issues: Independently and effectively troubleshoots and resolves complex technical issues.
- SQL Skills: Demonstrates advanced SQL skills, including complex joins, window functions, and performance tuning.
- Scheduling of Transformations: Manages and optimizes the scheduling and orchestration of data transformation jobs.
- Source Control: Uses Git and source control effectively for collaboration, versioning, and code management.
- Technical Debt: Identifies and prioritizes the reduction of technical debt in the analytics codebase.
Engineer - Design employer: Ubique Systems
Contact Detail:
Ubique Systems Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Engineer - Design
✨Tip Number 1
Network like a pro! Get involved in local meetups or online forums related to data engineering and analytics. This is a great way to connect with industry professionals who might just know about job openings before they’re advertised.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your SQL projects, data models, or any cool transformations you've done with DBT. Having tangible examples of your work can really set you apart during interviews.
✨Tip Number 3
Practice makes perfect! Brush up on your coding skills and be ready to tackle technical challenges during interviews. Use platforms like LeetCode or HackerRank to sharpen your SQL and coding abilities.
✨Tip Number 4
Don’t forget to apply through our website! We’ve got loads of opportunities that align with your skills in GCP and SQL. Plus, it’s a straightforward way to get your application noticed by the right people.
We think you need these skills to ace Engineer - Design
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Engineer - Design role. Highlight your strong SQL experience and any relevant projects you've worked on with GCP, BigQuery, and DBT. We want to see how your skills align with what we're looking for!
Showcase Your Communication Skills: Since you'll be communicating complex concepts, it's essential to demonstrate your ability to explain technical details clearly. Use examples in your application that show how you've effectively communicated with both technical and non-technical audiences.
Highlight Your Problem-Solving Abilities: We love critical thinkers! In your application, share instances where you've gone beyond the immediate request to tackle underlying business problems. This shows us you're not just about coding but also about understanding the bigger picture.
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 gives you a chance to explore more about us and what we do!
How to prepare for a job interview at Ubique Systems
✨Know Your SQL Inside Out
Since the role requires very strong SQL experience, make sure you brush up on complex joins, window functions, and performance tuning. Prepare to discuss specific examples of how you've used SQL in past projects, especially in relation to data modelling and transformation.
✨Showcase Your Coding Standards Knowledge
Be ready to talk about your experience with coding standards and how you've championed them in previous roles. Think of examples where you improved code readability and efficiency, and be prepared to explain your thought process behind those improvements.
✨Communicate Complex Concepts Simply
This position requires effective communication of technical concepts to both technical and non-technical audiences. Practice explaining a complex project or concept in simple terms, as this will demonstrate your ability to bridge the gap between different stakeholders.
✨Demonstrate Critical Thinking Skills
Prepare to discuss how you've tackled business problems beyond just the immediate requests. Think of instances where you challenged assumptions or explored new datasets to validate quality and identify potential uses, showcasing your analytical mindset.