Lead Analytics Engineer

Job Descriptionhackajob is collaborating with AJ Bell to connect them with exceptional professionals for this role. NJob Description NWe 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. NYou will play a critical role in not just migrating existing assets, but improving how we model, govern, and deliver data across the organisation. NWhy This Role Matters NThis is a high-impactrole 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. NWhat does the job involve? NSupport the Migrationfrom Legacy BI to Modern Data Platform NnSupport the end-to-end migration of reporting assets from SSRS into Snowflake NAssess and rationalise existing reports (remove duplication, improve logic, simplify where possible) NRedesign reporting structures to align with modern data modelling principles NnDefine and Implement Best Practice NnEstablish scalable standards for: NnData modelling (e.G. dimensional modelling, layered architecture) NTransformation workflows (ELT patterns) NTesting and validation NDocumentation and governance NnnIntroduce moderndevelopment practices (e.G. version control, CI/CD where appropriate) NnHands-On Delivery NnBuild and optimise data models, transformations, and reporting datasets NWrite high-quality, performant SQL in Snowflake NDevelop reusable data assets for downstream reporting and analytics NTroubleshoot and resolve data quality or performance issues NnImprove the Reporting & Analytics Layer NnDesign a clean, scalable semantic layer for reporting NStandardise key business metrics and definitions NSupport transition away from legacy report-first design toward model-first design NnMentor and Uplift the Existing Team NnProvide technical guidance and coaching to BI developers and analysts NRaise engineering standards across the team NPromote consistency and good practices without over-engineering NnStakeholder Collaboration NnWork closely with business stakeholders to understand reporting needs NTranslate requirements into robust, scalable data solutions NChallenge and refinerequirements where needed to improve outcomes NnEssentialn NStrong SQL expertise (advanced level) NProven experience working with Snowflake (or similar cloud data warehouse) NExperience migratingfrom legacy BI/reporting tools (e.G. SSRS, Cognos, Business Objects) NStrong data modelling experience (dimensional modelling, star schemas, etc.) NExperience building transformation layers in ELT environments NTrack record of delivering in hands-on roles (not purely architectural) NnHighly Desirable NnExperience with dbt or similar transformation frameworks NFamiliarity with modern data stack principles NExperience implementing testing and data quality frameworks NExposure to CI/CD indata environments NExperience rationalising large, complex reporting estates NnAbout AJ Bell NAJ Bell is one of theUK’s fastest-growing investment platform businesses, providing award-winning solutions for everyone, from professional financial advisers to first-time investors. NToday, over 723,000 customers trust us to manage more than £108billion of assets. By continually striving to make investing simpler and more accessible, we’re helping more people take control of their financial futures. NWe’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. NWhat we offern N26 days holiday, increasing with service + buy/sell scheme + bank holidays N7% Pension with matched contributions NDiscretionary bonus scheme NShare schemes (including free shares and BAYE) NHealth Cash Plan anddiscounted private healthcare NFree onsite gym NEnhanced family leave (subject to qualifying criteria) NTravel and bike loanschemes NEmployee Assistance Programme NnLife at AJ Bell NnRegular socialevents including summer and Christmas parties NLearning and development opportunities tailored to you NCasual dress code NFriendly, supportiveteam environment NnOur ways of working NWe offer hybrid working, with a minimum of 50% 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. NInclusion & diversity NWe’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….