At a Glance
- Tasks: Lead the migration to a modern data platform and optimise reporting structures.
- Company: Join AJ Bell, one of the UK's fastest-growing investment platforms.
- Benefits: Enjoy 26 days holiday, a generous pension scheme, and health benefits.
- Other info: Hybrid working, regular social events, and a supportive team culture.
- Why this job: Make a real impact on data transformation and mentor a talented team.
- Qualifications: Strong SQL skills and experience with Snowflake or similar cloud data warehouses.
The predicted salary is between 60000 - 80000 £ per year.
This is a high-impact role at the centre of a major data transformation. The successful candidate will shape how data is modelled, accessed, and trusted across the organisation for years to come.
What does the job involve?
- Support the Migration from Legacy BI to Modern Data Platform
- Support the end-to-end migration of reporting assets from SSRS into Snowflake
- Assess and rationalise existing reports (remove duplication, improve logic, simplify where possible)
- Redesign reporting structures to align with modern data modelling principles
- Define and Implement Best Practice
- Data modelling (e.g. dimensional modelling, layered architecture)
- Testing and validation
- Documentation and governance
- Introduce modern development practices (e.g. version control, CI/CD where appropriate)
- Hands-On Delivery
- Build and optimise data models, transformations, and reporting datasets
- Write high-quality, performant SQL in Snowflake
- Develop reusable data assets for downstream reporting and analytics
- Troubleshoot and resolve data quality or performance issues
- Improve the Reporting & Analytics Layer
- Design a clean, scalable semantic layer for reporting
- Standardise key business metrics and definitions
- Support transition away from legacy report-first design toward model-first design
- Mentor and Uplift the Existing Team
- Provide technical guidance and coaching to BI developers and analysts
- Raise engineering standards across the team
- Promote consistency and good practices without over-engineering
- Stakeholder Collaboration
- Work closely with business stakeholders to understand reporting needs
- Translate requirements into robust, scalable data solutions
- Challenge and refine requirements where needed to improve outcomes
Strong SQL expertise (advanced level)
Proven experience working with Snowflake (or similar cloud data warehouse)
Experience migrating from legacy BI/reporting tools (e.g. SSRS, Cognos, Business Objects)
Strong data modelling experience (dimensional modelling, star schemas, etc.)
Experience building transformation layers in ELT environments
Track record of delivering in hands-on roles (not purely architectural)
Highly Desirable
- Experience with dbt or similar transformation frameworks
- Familiarity with modern data stack principles
- Experience implementing testing and data quality frameworks
- Exposure to CI/CD in data environments
- Experience rationalising large, complex reporting estates
About AJ Bell
AJ Bell is one of the UK’s fastest-growing investment platform businesses, providing award-winning solutions for everyone, from professional financial advisers to first-time investors. Today, over 723,000 customers trust us to manage more than £108 billion of assets. By continually striving to make investing simpler and more accessible, we’re helping more people take control of their financial futures. We’re proud to be recognised as one of the UK’s Best 100 Companies to Work For, for six consecutive years, and a Great Place to Work® in 2025 and 2026—a reflection of our supportive and collaborative culture.
What we offer
- 26 days holiday, increasing with service + buy/sell scheme + bank holidays
- 7% Pension with matched contributions
- Discretionary bonus scheme
- Share schemes (including free shares and BAYE)
- Health Cash Plan and discounted private healthcare
- Free onsite gym
- Enhanced family leave (subject to qualifying criteria)
- Travel and bike loan schemes
- Employee Assistance Programme
Life at AJ Bell
- Regular social events including summer and Christmas parties
- Learning and development opportunities tailored to you
- Casual dress code
- Friendly, supportive team environment
Our ways of working
We offer hybrid working, with a minimum of 60% of your working time per month spent in the office. For new starters, there’s an initial period of full-time office working to help you settle in and build relationships.
Inclusion & diversity
We’re committed to creating an inclusive environment where everyone feels respected and able to be themselves at work. We welcome applications from all backgrounds and make hiring decisions based on skills, experience and potential.
Analytics Engineer — Snowflake Data Platform Lead in Salford employer: Aj Bell
AJ Bell is an exceptional employer, recognised as one of the UK’s Best 100 Companies to Work For, offering a supportive and collaborative culture that fosters employee growth. With a strong focus on work-life balance, hybrid working options, and tailored learning opportunities, employees can thrive in their roles while enjoying generous benefits such as a 7% pension contribution, health cash plans, and regular social events. Join us in shaping the future of investment platforms while being part of a team that values inclusivity and personal development.
StudySmarter Expert Advice🤫
We think this is how you could land Analytics Engineer — Snowflake Data Platform Lead in Salford
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, especially those already working at AJ Bell. A friendly chat can open doors and give you insider info on what they're looking for.
✨Tip Number 2
Show off your skills! If you’ve got a portfolio or examples of your work with Snowflake or data modelling, bring them along to interviews. It’s a great way to demonstrate your hands-on experience.
✨Tip Number 3
Prepare for those tricky questions! Think about how you’d tackle challenges like migrating from legacy systems or improving data quality. Being ready with real-life examples will impress the interviewers.
✨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 the team.
We think you need these skills to ace Analytics Engineer — Snowflake Data Platform Lead in Salford
Some tips for your application 🫡
Tailor Your Application:Make sure to customise your CV and cover letter to highlight your experience with Snowflake and data modelling. We want to see how your skills align with the role, so don’t hold back on showcasing your relevant projects!
Show Off Your SQL Skills:Since strong SQL expertise is a must-have for this role, include specific examples of complex queries or transformations you've built. We love seeing how you’ve tackled data challenges in the past!
Be Clear and Concise:When writing your application, keep it straightforward and to the point. We appreciate clarity, so avoid jargon unless it’s necessary. Make it easy for us to see why you’re the perfect fit!
Apply Through Our Website:We encourage you to submit your application directly through our website. It’s the best way for us to receive your details and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at Aj Bell
✨Know Your Data Inside Out
Before the interview, dive deep into data modelling principles, especially dimensional modelling and star schemas. Be ready to discuss how you've applied these concepts in your previous roles, particularly with Snowflake or similar platforms.
✨Showcase Your SQL Skills
Prepare to demonstrate your SQL expertise during the interview. Have examples ready where you've written high-quality, performant SQL queries, and be prepared to troubleshoot any potential data quality issues on the spot.
✨Understand the Migration Process
Familiarise yourself with the end-to-end migration process from legacy BI tools like SSRS to modern data platforms. Be ready to discuss your experience in rationalising reports and improving logic, as well as how you would approach this task in the new role.
✨Engage with Stakeholders
Think about how you would collaborate with business stakeholders to understand their reporting needs. Prepare examples of how you've translated requirements into scalable data solutions and how you’ve challenged and refined those requirements for better outcomes.
