At a Glance
- Tasks: Design and optimise ETL/ELT pipelines for high-quality data solutions.
- Company: Join a forward-thinking company with a collaborative Business Intelligence team.
- Benefits: Opportunity to work with modern cloud technologies and develop your skills.
- Other info: Engaging team environment with opportunities for professional growth.
- Why this job: Solve complex data challenges and make a real impact on the data platform.
- Qualifications: Strong SQL skills and experience with ETL/ELT pipelines required.
The predicted salary is between 45000 - 55000 £ per year.
We're looking for an Analytics Engineer to join our client's high-performing Business Intelligence team, helping to build scalable, high-quality data solutions that power reporting, dashboards and self-service analytics across the business.
Working closely with BI Developers and business stakeholders, you'll design and optimise ETL/ELT pipelines, develop curated data models, and translate business requirements into reliable backend data solutions. This is a fantastic opportunity for someone who enjoys solving complex data challenges and wants to work with modern cloud technologies in a collaborative, forward-thinking environment.
What you'll be doing
- Design, build and maintain scalable ETL/ELT pipelines that deliver reliable, high-quality data.
- Develop curated, business-ready datasets that support reporting, dashboards and self-service analytics.
- Optimise data models, SQL queries and pipeline performance to improve efficiency and scalability.
- Implement data quality, monitoring and governance controls to ensure trusted, accurate data.
- Collaborate with BI Developers to build backend data models that support performant visualisations.
- Work with business stakeholders to understand requirements and translate them into robust technical solutions.
- Contribute to the continuous improvement of the data platform, exploring modern tooling and engineering best practices.
What we're looking for
- Strong SQL skills with experience building and optimising data models.
- Experience designing and maintaining ETL/ELT pipelines.
- Experience working with cloud data platforms (AWS preferred).
- Exposure to data warehousing, data lakes and modern data architecture.
- Understanding of workflow orchestration and automation tools.
- Python experience (including PySpark) is beneficial but not essential.
- Exposure to BI platforms such as Power BI, Tableau or QuickSight, with an understanding of how backend data models support reporting and visualisation.
- Strong communication skills and the ability to work effectively with both technical and non-technical stakeholders.
- A genuine interest in modern data engineering practices and emerging technologies.
The Team
You'll be joining a highly collaborative and engaging team within a business that genuinely invests in its people. Alongside working on modern data technologies, you'll have the opportunity to influence the evolution of the data platform, work closely with experienced BI professionals, and continue developing both your technical and professional skills in a supportive environment.
Please note: This is a backend-focused Analytics Engineering role centred around SQL, data modelling and ETL/ELT development. While you'll work closely with BI Developers, this is not a dashboard or reporting development position.
Analytics Engineer in Sunderland employer: TRIA
TRIA is an excellent employer that fosters a dynamic and inclusive work culture in the heart of Bristol. With a strong focus on employee growth, we offer comprehensive training opportunities and a supportive environment that encourages innovation and collaboration. Our competitive salary package, performance bonuses, and generous holiday allowance make TRIA a rewarding place to advance your career in the insurance software industry.
StudySmarter Expert Advice🤫
We think this is how you could land Analytics Engineer in Sunderland
✨Get to Grips with Data Visualisation Tools
If you're aiming for a full-time role in business intelligence, brush up on your skills with popular data visualisation tools like Tableau or Power BI. Showcasing projects where you've transformed raw data into clear visual insights can give you a real edge.
✨Join Local Business Intelligence Meetups
Look for local business intelligence meetups or analytics conferences in your area. These events are not just great for learning but also for networking with industry professionals who could lead you to opportunities at companies like TRIA!
✨Engage with Online BI Communities
Join online forums or communities focused on business intelligence—think LinkedIn groups, Reddit threads, or even dedicated Slack channels. Engage actively by sharing your insights and asking questions; this can help you build visibility and connect with potential employers.
✨Leverage Your University’s Career Support
If you're a recent graduate, definitely tap into your university's career services. Many have connections with companies in need of full-time BI specialists, and they can guide you on how to pitch yourself effectively—don't miss out on that!
We think you need these skills to ace Analytics Engineer in Sunderland
Some tips for your application 🫡
Highlight Your Analytical Skills:In the business intelligence field, showcasing your analytical skills is a must. Make sure your CV includes relevant experience with data analysis tools, programming languages like SQL or Python, and any projects where you've interpreted complex data sets to drive business decisions.
Showcase Your Business Acumen:Don't just focus on data; show us how you can apply your insights to real-world business problems. Highlight projects where you made a tangible impact on company performance, and be prepared to explain your thought process in your cover letter.
Tailor Your Documents for Us:When applying for a full-time role at TRIA, tailor your CV and cover letter to reflect our organisational goals and strategies. Mention specific tools and methodologies that align with what we do—this shows you’ve done your homework and are genuinely interested in our mission!
Include Relevant Certifications:Certifications like Google Data Analytics or similar qualifications can really make you stand out in business intelligence. Include these in your application, as they demonstrate your commitment to the field and your willingness to stay current with industry standards.
How to prepare for a job interview at TRIA
✨Show off your analytical skills
In a business intelligence role, you're going to need to demonstrate your analytical prowess. Be prepared to discuss specific tools you've used, like SQL, Tableau, or Power BI. Have real-world examples ready where you’ve turned data into actionable insights – this is what makes us shine in interviews!
✨Practice your technical know-how
Expect some technical questions during the interview that dive deep into your understanding of data modelling and analytics frameworks. Brush up on your knowledge of data warehousing concepts and be ready to tackle any real case scenarios they might present. They’ll want to see how you approach problems using your BI toolkit.
✨Portfolio of Projects
Since it's a full-time role, having a strong portfolio is key! Compile case studies demonstrating your previous projects, preferably showing how your insights led to business improvements. This can help us display how you think through complex datasets and your problem-solving process, which is what employers are keen on seeing.
✨Know their business model
Get familiar with TRIA’s business model and recent data-driven decisions. Be prepared to discuss how your skills can specifically support their objectives or challenges. Understanding their landscape shows that you’re not just a data buff, but you’re also genuinely interested in how BI can impact their bottom line.
