At a Glance
- Tasks: Build scalable data models and develop automated data pipelines using modern tools.
- Company: Join a forward-thinking company focused on data innovation and sustainability.
- Benefits: Competitive salary, generous holiday, healthcare plan, and electric car scheme.
- Other info: Dynamic team environment with opportunities for growth and development.
- Why this job: Shape data standards and practices while making a real impact in analytics.
- Qualifications: Strong SQL skills and experience with cloud data platforms like Snowflake.
The predicted salary is between 45000 - 55000 £ per year.
We’re looking for an Analytics Engineer to join our Data & Analytics team, helping to build scalable, reliable and well‑governed data products using modern analytics engineering practices. This role is centred on data modelling, transformation and pipeline development, with a strong focus on dbt‑style workflows and cloud data platforms (e.g. Snowflake). You’ll play a key role in shaping how data is structured and delivered across the organisation, enabling high‑quality, self‑service analytics. While the role includes exposure to Power BI, the focus is on engineering robust datasets and semantic models that underpin reporting, rather than building dashboards.
What you’ll be doing:
- Build scalable data models and transformation layers
- Design and develop reusable, well‑structured data models to support analytics use cases
- Apply best practices in dimensional modelling and semantic layer design
- Build data transformation workflows using modern tools (e.g. SQL, dbt or equivalent)
- Develop and operate data pipelines
- Create and maintain automated ELT pipelines to transform and deliver data from multiple sources
- Ensure pipelines are reliable, efficient and scalable within a cloud data environment (e.g. Snowflake)
- Promote standardisation, modular design and reusability across data transformations
- Drive data quality and engineering best practice
- Implement testing frameworks (e.g. data validation, schema tests, lineage) to ensure data accuracy
- Maintain documentation, version control and structured development practices
- Contribute to the adoption of modern analytics engineering standards across the team
- Enable downstream analytics (Power BI)
- Develop and maintain datasets and semantic models for Power BI consumption
- Validate and test data within Power BI to ensure consistency with underlying models
- Support programmatic interaction with Power BI (e.g. metadata extraction, automation, integration with data workflows)
- Ensure strong alignment between upstream models and downstream reporting outputs
- Collaborate with analysts and stakeholders
- Translate business requirements into scalable, reusable data assets
- Enable self‑service analytics by delivering clean, well‑structured datasets
- Work closely with analysts to improve data usability and consistency
- Optimisation and continuous improvement
- Improve performance of queries, transformations and data models
- Identify opportunities to automate processes and enhance efficiency
- Contribute to tooling, frameworks and shared development patterns
Who we’re looking for:
- Strong experience with SQL and data modelling (e.g. dimensional modelling, semantic modelling)
- Experience with modern data transformation tooling (e.g. dbt, strongly preferred)
- Experience working with cloud data platforms (e.g. Snowflake, Azure, AWS)
- Experience building and maintaining scalable data pipelines and datasets
- Understanding of data quality, testing and governance practices
- Experience working with Power BI datasets/semantic models (rather than solely report development)
- Experience with Python or scripting for automation desirable
- Exposure to version control (e.g. Git) and collaborative development practices
Why is this role different?
- Focus on data modelling and transformation — not reporting delivery
- Built around modern analytics engineering (dbt, ELT, testing, version control)
- Strong emphasis on cloud data platforms (e.g. Snowflake)
- Power BI used as a consumer layer, not the primary skill set
- Opportunity to help shape standards, tooling and engineering practices
Benefits:
- The opportunity to participate in our annual, performance‑related bonus plan and valuable share schemes
- Generous pension contribution
- Life assurance
- Healthcare Plan (permanent employees only)
- At least 25 days holiday, plus public holidays, 26 days after 2 years’ service. There’s also the option to buy and sell holiday
- Competitive family leave
- Participate in our electric car scheme, which offers employees the option to hire a brand‑new electric car through tax efficient salary sacrifice (permanent employees only)
- There are many discounts we offer – both for our own products and at a range of high street stores and online
- We’re creating net‑zero carbon workplaces by 2030 by investing in our sustainable, modern offices across the UK, all designed to bring people together and elevate the in‑person experience
Data Analyst (Analytics Engineer) in Cardiff employer: Legal And General Group
Join a forward-thinking company that prioritises innovation and employee well-being, offering a collaborative work culture where your contributions directly impact the organisation's data landscape. With generous benefits including performance-related bonuses, a robust pension scheme, and a commitment to sustainability, you'll find ample opportunities for professional growth and development in a supportive environment. Located in modern offices designed for collaboration, this role as an Analytics Engineer allows you to shape data practices while enjoying a healthy work-life balance.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst (Analytics Engineer) in Cardiff
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, attend meetups, and connect with potential colleagues on LinkedIn. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your data models, transformation workflows, and any projects you've worked on. This gives you a chance to demonstrate your expertise in SQL, dbt, and cloud platforms like Snowflake.
✨Tip Number 3
Prepare for interviews by brushing up on common data engineering questions and scenarios. Be ready to discuss your experience with data quality, testing frameworks, and how you've collaborated with analysts to deliver clean datasets.
✨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, it shows you're genuinely interested in joining our team at StudySmarter.
We think you need these skills to ace Data Analyst (Analytics Engineer) in Cardiff
Some tips for your application 🫡
Tailor Your CV:Make sure your CV reflects the skills and experiences that match the job description. Highlight your SQL expertise, data modelling experience, and any work with cloud platforms like Snowflake. We want to see how you can contribute to our Data & Analytics team!
Craft a Compelling Cover Letter:Use your cover letter to tell us why you're passionate about analytics engineering. Share specific examples of your past projects, especially those involving dbt or data transformation workflows. This is your chance to show us your personality and enthusiasm for the role!
Showcase Your Projects:If you've worked on relevant projects, whether in a professional setting or as personal endeavours, make sure to mention them. We love seeing practical applications of your skills, especially around data pipelines and quality assurance practices. It helps us understand your hands-on experience!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way to ensure your application gets into the right hands. Plus, it shows us you're keen on joining our team at StudySmarter. Don’t miss out on this opportunity!
How to prepare for a job interview at Legal And General Group
✨Know Your Data Modelling
Make sure you brush up on your data modelling skills, especially dimensional and semantic modelling. Be ready to discuss how you've applied these practices in previous roles, as this will show your understanding of the core responsibilities of the Analytics Engineer position.
✨Familiarise with dbt and Cloud Platforms
Since the role heavily focuses on dbt and cloud data platforms like Snowflake, it’s crucial to demonstrate your experience with these tools. Prepare examples of how you've built scalable data pipelines or transformation workflows using dbt, and be ready to explain your approach to ensuring data quality.
✨Showcase Your Collaboration Skills
This role involves working closely with analysts and stakeholders, so be prepared to share experiences where you've translated business requirements into data assets. Highlight any instances where your collaboration improved data usability or consistency, as this will resonate well with the interviewers.
✨Prepare for Technical Questions
Expect technical questions related to SQL, data transformation, and testing frameworks. Brush up on your knowledge of automated ELT pipelines and be ready to discuss how you ensure reliability and efficiency in your data processes. Practising common SQL queries and transformations can give you an edge.
