Data Engineer

Lumon; London; On-site; GBP 50,000 - 80,000; Full time

Job summary

An established industry player is seeking a Data Engineer to enhance its technical data infrastructure. This role focuses on building and optimizing Azure Synapse data warehouses, developing robust data pipelines, and ensuring high-quality datasets for analytics. The ideal candidate will thrive in delivering scalable data solutions and solving complex challenges. Join a company dedicated to equity, diversity, and inclusion, where your contributions will help shape a collaborative and innovative environment. If you are passionate about data engineering and want to make a difference, this opportunity is perfect for you.

Benefits

25 days Annual leave

Birthday day off

Free monthly company lunches

Summer and Christmas parties

Access to Pirkx benefits platform

Medicash health scheme

Cycle to work scheme

Quiet/Prayer room

Employee Assistance Programme

Ongoing training and development

Qualifications

• 3+ years in data engineering or similar roles, preferably in financial services.
• Hands-on experience with Azure tools and SQL database management.

Responsibilities

• Design and maintain ETL/ELT pipelines using Azure tools.
• Collaborate with stakeholders to develop data solutions and dashboards.

Skills

Azure Synapse

SQL

ETL Pipelines

Data Transformation

Data Quality Metrics

Education

Bachelor's Degree in Computer Science or related field

Tools

Azure Data Factory

Power BI

Azure Data Lake Storage

Job description

Who are we?

Lumon is a leading foreign exchange and international payments company which enables effortless overseas payments by uniting people, technology & expertise. We are passionate about what we do, as we believe helping people and companies achieve their goals is more valuable than just moving their money.

Life at Lumon

People are always at the heart of what we do, no matter if it's our clients, our community or our Lumoneer's. To give you a little flavour of what we mean...

We are a proud charity partner of Future First who support children in schools across the UK. We are a carbon neutral business. We are committed to Equity, Diversity and Inclusion; our EDI committee serves an important role at Lumon by challenging the status quo and helping us move the needle. We really want to make Lumon a great place to work, where people feel comfortable being themselves and where we can attract as much diversity as we possibly can. If this sounds good to you, then we're thrilled you're considering joining our team!

Role Overview

The Data Engineer will play a critical role in implementing and maintaining Lumon's technical data infrastructure. Reporting to the Head of Data, you will focus on building and optimising the Azure Synapse data warehouse, developing robust data pipelines, and delivering high-quality datasets for reporting and analytics.
This role is ideal for a technically skilled professional who thrives on designing scalable data solutions and enjoys solving complex data challenges.

Key Responsibilities

Data Infrastructure and Pipeline Development

• Design, develop, and maintain ETL/ELT pipelines using Azure Synapse Analytics, Data Factory and other Azure related cloud warehouse tools.
• Optimise the Azure Synapse data warehouse for performance, scalability, and reliability.
• Integrate data from various internal and external sources, ensuring accuracy and consistency across datasets.

Data Transformation and Quality

• Perform data transformation tasks to ensure datasets are structured for efficient reporting and analysis.
• Collaborate with the Head of Data to establish and monitor data quality metrics, implementing remediation processes as necessary.

Database Management

• Assist in managing and maintaining SQL databases, optimising query performance and ensuring secure data storage in compliance with company policies.
• Support database migrations and implement best practices for data security and retention.

Business Intelligence Support

• Work closely with the Data Analyst and other stakeholders to develop and deploy Power BI dashboards and reports.
• Provide technical support for troubleshooting data-related issues and ensuring continuous availability of critical reports and datasets.

Collaboration and Problem-Solving

• Collaborate with stakeholders to understand business requirements and translate them into technical data solutions.
• Identify opportunities to improve existing processes and automate routine tasks to enhance efficiency.

Required Experience

• 3+ years in data engineering or similar technical roles, preferably in financial services or a related field.
• Hands-on experience with Azure Synapse, Pipeline creations, Azure Data Factory, and Azure Data Lake Storage.
• Strong proficiency in SQL, including database management, query optimisation, and troubleshooting.
• Experience building and maintaining ETL pipelines for large-scale data environments.

Technical Skills

• Expertise in cloud-based data warehouse architecture within Azure ecosystems.
• Strong understanding of data modelling and transformation processes.
• Familiarity with Power BI for creating and deploying visualisations.

Attributes

• Detail-oriented with excellent problem-solving skills.
• Collaborative mindset and ability to work effectively across teams.
• Eager to stay updated with emerging data engineering trends and tools.

What you'll get:

• A competitive salary
• 25 days Annual leave, with a chance to purchase up to 5 additional days'
• Birthday day off
• Free monthly company lunches
• Summer and Christmas parties, and other fun social events throughout the year
• Access to Pirkx benefits platform which includes online GP, cashback and discounts on shopping and restaurants, gym discounts and more!
• Medicash health scheme for you and your family
• Cycle to work scheme
• Quiet/Prayer room in Head Office
• Employee Assistance Programme
• Mental Health First Aiders
• Pension
• 4x Life Assurance
• Ongoing training and development
• Enhanced maternity leave
• Menopause support
• 2 additional days a year for 'Moments that Matter

Lumon is proud to be an Equal Opportunity Employer. We are committed to equal employment opportunity regardless of race, colour, ancestry, religion, sex, sexual orientation, age, marital status, disability, or gender identity.

If you consider yourself to have a disability or require any reasonable adjustment during the recruitment process or within the workplace, please highlight this at the earliest opportunity, we will provide appropriate support to you throughout the process.

Department Technology Role Data Engineer Locations 20 Farringdon