At a Glance
- Tasks: Lead the migration of reporting assets to a modern cloud data platform and improve data delivery.
- Company: Join a forward-thinking organisation at the forefront of data transformation.
- Benefits: Enjoy 26 days holiday, a generous pension scheme, and health benefits.
- Other info: Collaborative environment with opportunities for mentorship and career growth.
- Why this job: Make a significant impact on how data is accessed and trusted across the organisation.
- Qualifications: Strong SQL skills and experience with Snowflake or similar cloud data warehouses.
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.
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
- 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
Essential
- 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
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
Lead Analytics Engineer (6 Month FTC) in Manchester employer: 慨正橡扯
As a Lead Analytics Engineer, you will be at the forefront of a transformative data migration project, working in a collaborative and innovative environment that prioritises best practices and employee growth. Our company offers a comprehensive benefits package, including generous holiday allowances, a strong pension scheme, and opportunities for professional development, all while fostering a culture of mentorship and teamwork. Located in a dynamic setting, we are committed to empowering our employees to shape the future of data analytics within the organisation.
StudySmarter Expert Advice🤫
We think this is how you could land Lead Analytics Engineer (6 Month FTC) in Manchester
✨Tip Number 1
Network like a pro! Reach out to folks in your industry on LinkedIn or at local meetups. We all know that sometimes it’s not just what you know, but who you know that can help you land that dream role.
✨Tip Number 2
Prepare for those interviews by practising common questions and scenarios related to analytics and data migration. We recommend doing mock interviews with friends or using online platforms to get comfortable with the process.
✨Tip Number 3
Showcase your skills! Create a portfolio of your past projects, especially those involving SQL and Snowflake. We want to see how you’ve tackled real-world problems and improved data processes.
✨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, we love seeing candidates who are proactive about their job search.
We think you need these skills to ace Lead Analytics Engineer (6 Month FTC) in Manchester
Some tips for your application 🫡
Tailor Your CV:Make sure your CV speaks directly to the role of Lead Analytics Engineer. Highlight your SQL expertise and experience with Snowflake, as well as any hands-on roles you've had in data migration. 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. Be sure to mention any relevant projects or experiences that showcase your abilities.
Showcase Your Hands-On Experience:We love candidates who have been in the trenches! Make sure to detail your hands-on experience with building data models and transformation layers. Share specific examples of how you've tackled challenges in previous roles.
Apply Through Our Website:Don't forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows you’re keen on joining the StudySmarter team!
How to prepare for a job interview at 慨正橡扯
✨Know Your SQL Inside Out
Since strong SQL expertise is essential for this role, make sure you brush up on your advanced SQL skills. Prepare to discuss complex queries you've written and be ready to solve SQL problems on the spot during the interview.
✨Familiarise Yourself with Snowflake
As experience with Snowflake is crucial, take some time to understand its features and functionalities. Be prepared to talk about any projects where you've used Snowflake or similar cloud data warehouses, and how you approached challenges in those environments.
✨Showcase Your Migration Experience
This role involves migrating from legacy BI tools, so come armed with examples of past migrations you've been involved in. Discuss the strategies you used to assess and rationalise existing reports, and how you improved reporting structures in your previous roles.
✨Emphasise Collaboration Skills
Stakeholder collaboration is key in this position. Be ready to share experiences where you've worked closely with business stakeholders to translate their needs into data solutions. Highlight how you challenged and refined requirements to achieve better outcomes.
