Lead Analytics Engineer (6 Month FTC)

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 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 £108billion 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