Senior Data engineer (Java/SQL)

Methods; Glasgow; On-site; GBP 75,000 - 110,000; Full time

Benefits offered by this job

LinkedIn Learning access

Employee assistance programme

Wellness support

Pension Salary Exchange with employer/

Life Assurance

Job summary

Methods in Glasgow is seeking a Senior Data Engineer to design and deliver scalable data solutions. You will leverage Java and Scala to build pipelines, manage distributed big data frameworks, and optimize our data platform.

The role emphasizes strong SQL, Java development, ETL/ELT experience, and collaboration with data architects and stakeholders to translate requirements into robust data solutions. Onsite in Glasgow with 3 days per week in the office is expected.

Qualifications

• Java development experience (5+ years)
• Advanced SQL skills including performance tuning and data modelling
• Experience designing and developing ETL/ELT pipelines
• Experience with relational databases (PostgreSQL, SQL Server, Oracle, MySQL)
• Knowledge of data warehousing concepts and dimensional modelling
• Version control using Git
• Knowledge of cloud-based data platforms and modern data engineering practices
• Desirable Scala development and Spark/Kafka exposure

Responsibilities

• Design, develop, and maintain scalable data pipelines for data integration, transformation, and analytics
• Write 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 stakeholders to translate requirements into scalable data solutions
• Implement automated testing, monitoring, and data quality controls across the data platform

Skills

Java development

Advanced SQL

ETL/ELT pipelines

Relational databases

Data warehousing modeling

Git

Cloud data platforms

Scala development

Tools

PostgreSQL

SQL Server

Oracle

MySQL

Apache Spark

Kafka

Azure

AWS

GCP

CI/CD pipelines

Job description

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.

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

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)