Senior Data engineer (Java/SQL)

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)