Data Engineering Technical Lead Location: Manchester Role Type: Permanent Work Setup: Hybrid - 3 days in officeandnbsp;Who We AreVanguard is one of the world''s leading investment firms, dedicated to helping clients achieve lasting financial success. Established in 1975, its unique ownership structure-where funds own the company and investors own the funds-ensures all efforts are focused on client outcomes. Known for integrity, innovation, and low-cost investing, fosters an inclusive and collaborative culture that empowers employees to make a meaningful impact globally. What you''ll do: Delivers advanced data solutions by processing, storing, and serving data efficiently. Ensures high-quality, secure, and scalable data pipelines. Performs deep analytical work on diverse data sources and mentors junior Data Engineers.Design and develop ETL processes, database systems, and tools for Real Time and offline analytics.Ensure data consistency and integrity; integrate large, complex datasets for business insights.Converts business requirements into design and code, developing complex programs, queries, and reports while ensuring well-structured, documented, and maintainable solutions.Collaborate with internal clients and technical teams to implement effective data solutions.Lead solution development, providing technical guidance and explaining considerations to team and clients.Assess data quality, test code, and provide technical consulting and data analysis guidance.Mentor junio