Senior Data engineer (Java/SQL)

About this role

We are seeking a Senior Data Engineer with strong SQL and Java expertise to design and deliver scalable data solutions. In this role, you will leverage Java's robustness and Scala's functional data-processing power to build scalable pipelines, manage distributed big data frameworks, and optimize our data platform. Location: 3days/w onsite in Glasgow Key Responsibilities Design, develop, and maintain scalable data pipelines to support data integration, transformation, and analytics requirements. Write efficient, high-performance SQL queries, stored procedures, and data transformation logic. Build and maintain backend data processing applications using Java. Develop scalable APIs and microservices architectures. Work with batch and near real-time data processing frameworks to deliver reliable data solutions. Optimise data models, database performance, and query execution. Collaborate with data architects, analysts, and business stakeholders to translate requirements into scalable data solutions. Implement automated testing, monitoring, and data quality controls across the data platform. Requirements Essential Skills & Experience • Java: 5+ years of professional experience with Java (Version 11 or higher preferred). • Advanced SQL skills with experience in performance tuning, data modelling, and complex query development. • Strong Java development experience, including object-oriented design and enterprise application development. • Experience designing and developing ETL/ELT pipelines. • Experience working with relational databases such as PostgreSQL, SQL Server, Oracle, or MySQL. • Understanding of data warehousing concepts and dimensional modelling. • Experience with version control systems such as Git. • Knowledge of cloud-based data platforms and modern data engineering practices. Desirable Skills • Experience with Scala development. • Experience with Apache Spark or other distributed data processing frameworks. • Experience with Kafka, Event Hubs, or other streaming technologies. • Exposure to cloud platforms such as Azure, AWS, or GCP. • Experience with CI/CD pipelines and DevOps practices. • Familiarity with data lake and lakehouse architectures. • Experience in banking or financial services industry Benefits Benefits By joining us you can expect Autonomy to develop and grow your skills and experience Be part of exciting project work that is making a difference in society Strong, inspiring and thought-provoking leadership A supportive and collaborative environment As well as this, we offer: Development access to LinkedIn Learning, a management development programme and training Wellness 24/7 Confidential employee assistance programme Social - Breakfast Tuesdays, Thirsty Thursdays and Pizza on the last Thursday of each month as well as commitment to charitable causes Time off 25 days a year; plus the opportunity to purchase extra leave per year Pension Salary Exchange Scheme with 4% employer contribution and 5% employee contribution Life Assurance of 4 times base salary Private Medical Insurance which is non-contributory (spouse and dependants included) Worldwide Travel Insurance which is non-contributory (spouse and dependants included)