Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the migration of analytics to a modern cloud platform and optimise data models.
- Company: Join a forward-thinking company driving major data transformation in Manchester.
- Benefits: Competitive salary, flexible working options, and opportunities for professional growth.
- Other info: Collaborative team environment with mentorship opportunities and career advancement.
- Why this job: Make a significant impact on data practices and shape the future of analytics.
- Qualifications: Experience in data modelling, SQL, and a passion for innovative analytics solutions.
The predicted salary is between 60000 - 75000 £ per year.
We are undertaking a strategic migration of our reporting and analytics estate from SSRS to a modern cloud data platform (Snowflake). This role will support the design and delivery of that transformation, establishing best-in-class practices while remaining hands-on in building models, pipelines, and reporting layers. You will play a critical role in not just migrating existing assets, but improving how we model, govern, and deliver data across the organisation.
Why This Role Matters
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
- Establish scalable standards for:
- Data modelling (e.g. dimensional modelling, layered architecture)
- Transformation workflows (ELT patterns)
- 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
Lead Analytics Engineer (6 Month FTC) | Manchester, UK employer: Aj Bell
Contact Detail:
Aj Bell Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Lead Analytics Engineer (6 Month FTC) | Manchester, UK
✨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 best work, especially any projects related to data modelling or analytics. This will give you an edge and demonstrate your hands-on experience to potential employers.
✨Tip Number 3
Prepare for interviews by brushing up on your SQL and data transformation techniques. Be ready to discuss how you've tackled similar challenges in the past, especially around migrating reporting assets or improving data governance.
✨Tip Number 4
Don't forget to apply through our website! We love seeing candidates who are genuinely interested in joining us. Plus, it helps us keep track of your application and get you into the right role faster.
We think you need these skills to ace Lead Analytics Engineer (6 Month FTC) | Manchester, UK
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 data migration, especially from SSRS to modern platforms like Snowflake. We want to see how your skills align with our needs!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Share your passion for data transformation and how you can contribute to our mission. Be sure to mention any hands-on experience you've had with data modelling and governance.
Showcase Your Technical Skills: We’re looking for someone who can write high-quality SQL and build data models. Include specific examples of projects where you’ve done this. The more relevant details you provide, the better we can see your fit for the role!
Apply Through Our Website: Don’t forget to submit your application through our website! It’s the best way for us to receive your materials and ensures you’re considered for the position. We can’t wait to see what you bring to the table!
How to prepare for a job interview at Aj Bell
✨Know Your Data Inside Out
Make sure you’re well-versed in data modelling principles and the specifics of Snowflake. Brush up on your SQL skills, as you'll likely be asked to demonstrate your ability to write performant queries. Familiarise yourself with common data transformation workflows and best practices.
✨Showcase Your Migration Experience
Be prepared to discuss any previous experience you have with migrating reporting assets, especially from legacy systems to modern platforms. Highlight specific challenges you faced and how you overcame them, as this will show your problem-solving skills and hands-on experience.
✨Emphasise Best Practices
Talk about your understanding of best practices in data governance, documentation, and version control. Companies are looking for candidates who can not only execute tasks but also establish scalable standards that improve overall efficiency.
✨Demonstrate Leadership and Mentorship Skills
Since this role involves mentoring, be ready to share examples of how you've uplifted teams in the past. Discuss your approach to guiding others through complex projects and how you foster a collaborative environment, as this will resonate well with the interviewers.