Treasury Data Engineer

Jefferies; Greater London; On-site; GBP 50,000 - 70,000; Full time

Job summary

A global financial services firm in London is seeking a skilled individual to join their Treasury Technology team. The candidate will enhance Cash Management and support Treasury Analytics by loading and analyzing data using SQL and developing OLAP databases with SSAS. Strong technical expertise in T-SQL, analytical skills, and a good understanding of financial products like Fixed Income and Equities are essential. This role requires collaboration with various teams and developers, ensuring effective data solutions.

Qualifications

• Excellent technical aptitude in T-SQL, DAX, SSAS Tabular, and Python.
• Strong analytical and problem-solving skills.
• Good understanding of data warehousing and data processing concepts.
• Ability to work collaboratively in teams.
• Good communication skills to convey concepts effectively.
• Business knowledge of Fixed Income and Equities is a plus.
• Familiarity with Treasury functions.

Responsibilities

• Work with teams to source and ingest data.
• Collaborate with developers using dev ops tools.
• Ingest data into a data warehouse with ELT processes.
• Develop and maintain OLAP databases and SSAS cubes.
• Create reports and dashboards in Power BI and SSRS.
• Write performant and maintainable code.
• Adhere to project deadlines.

Skills

T-SQL

DAX

SSAS Tabular

Python

Data mining

Data analysis

Problem-solving

Communication

Tools

Power BI

SSRS

GIT

Job description

Overview

Joining the Treasury Technology team. The team currently has a presence in London and New York and is responsible for providing software and data solutions to enhance and support Cash Management, FX Funding, Treasury Analytics and Liquidity. Working closely with the global team. Analyse and load data into SQL Server databases and build / maintain SSAS Tabular models to meet Treasury’s reporting and analytics needs. A good understanding of Treasury’s function, as well as Equities and Fixed Income products, including REPO and Stock Lending is desirable.

Responsibilities

• Work with other teams to source and ingest data in a variety of forms
• Collaborate with a team of developers using dev ops tools like GIT and CI
• Ingest data into a data warehouse with ELT processes using T-SQL
• Develop and maintain OLAP databases and SSAS cubes
• Create reports and dashboards in Power BI and SSRS
• Writing performant and maintainable code to provide value from data
• Adhere to project deadlines

Qualifications

• Excellent technical aptitude – T-SQL, DAX, SSAS Tabular, Python etc.
• Strong analytical & problem-solving skills with a logical approach
• Knowledge of data warehousing and data processing concepts
• Able to work collaboratively
• Excellent data analytical skills – Data mining / discovery
• Good communication skills, able to covey concepts.
• Good business knowledge of Fixed Income and Equities, Repos and STBL
• Good understanding of Treasury