At a Glance
- Tasks: Lead a major data transformation and shape how data is accessed and trusted.
- 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 practices and mentor a talented team.
- Qualifications: Strong SQL skills and experience with Snowflake or similar cloud data warehouses.
The predicted salary is between 60000 - 75000 £ 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
Requirements:
- 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.
Lead Analytics Engineer (6 Month FTC) in Salford employer: Aj Bell
AJ Bell is an exceptional employer, recognised as one of the UK’s Best 100 Companies to Work For for six consecutive years. With a strong focus on employee growth and a supportive culture, we offer extensive benefits including 26 days holiday, a generous pension scheme, and tailored learning opportunities. Our hybrid working model promotes work-life balance while fostering collaboration in a friendly environment, making AJ Bell a great place for those looking to make a meaningful impact in the financial services sector.
StudySmarter Expert Advice🤫
We think this is how you could land Lead Analytics Engineer (6 Month FTC) in Salford
✨Tip Number 1
Network like a pro! Reach out to people in your industry, especially those who work at AJ Bell or similar companies. A friendly chat can lead to insider info about the role and even a referral!
✨Tip Number 2
Show off your skills! Prepare a portfolio or case studies that highlight your experience with data modelling, SQL, and Snowflake. This will give you an edge during interviews and show that you're ready to hit the ground running.
✨Tip Number 3
Practice makes perfect! Get comfortable with common interview questions related to analytics and data transformation. Mock interviews with friends or mentors can help you articulate your thoughts clearly and confidently.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, it shows you’re genuinely interested in joining the team at AJ Bell.
We think you need these skills to ace Lead Analytics Engineer (6 Month FTC) in Salford
Some tips for your application 🫡
Tailor Your CV:Make sure your CV speaks directly to the role of Lead Analytics Engineer. Highlight your experience with Snowflake, SQL, and any data migration projects you've tackled. We want to see how your skills align with our needs!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're excited about this role and how you can contribute to our data transformation journey. Keep it engaging and personal – we love a bit of personality!
Showcase Your Technical Skills:Don’t hold back on showcasing your technical prowess! Mention specific projects where you've implemented best practices in data modelling or worked with modern data stacks. We’re keen to see your hands-on experience!
Apply Through Our Website:We encourage you to apply through our website for a smoother process. It helps us keep track of applications and ensures you don’t miss out on any important updates. 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 your understanding of data modelling and analytics. Be ready to discuss your experience with SQL and Snowflake, as well as any legacy BI tools you've worked with. This will show that you’re not just familiar with the concepts but can also apply them practically.
✨Showcase Your Problem-Solving Skills
Prepare to share specific examples of how you've tackled data quality issues or improved reporting structures in the past. Highlight your hands-on experience in building and optimising data models, as this role requires a proactive approach to problem-solving.
✨Emphasise Collaboration and Mentorship
Since this role involves mentoring others, be ready to discuss your experience in guiding teams or collaborating with stakeholders. Share instances where you’ve successfully translated complex requirements into actionable data solutions, showcasing your ability to uplift those around you.
✨Stay Current with Modern Practices
Familiarise yourself with modern data stack principles and CI/CD practices. Mention any experience you have with frameworks like dbt, and be prepared to discuss how you would implement best practices in data governance and documentation. This shows you're forward-thinking and ready to contribute to the organisation's data transformation.
