Treasury Data Engineer

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

Job summary

A leading financial services firm in London is seeking a Treasury Technology team member to enhance Cash Management and Treasury Analytics. Responsibilities include data ingestion, database maintenance, and report creation using tools like Power BI. The ideal candidate will have excellent technical skills in T-SQL and Python, strong analytical abilities, and good knowledge of Fixed Income and Equities.

Qualifications

• Excellent technical aptitude including T-SQL, DAX, and Python.
• Knowledge of data warehousing and processing concepts.
• Strong analytical skills and a logical problem-solving approach.

Responsibilities

• Source and ingest data in various forms.
• Collaborate using dev ops tools.
• Ingest data into a data warehouse.

Skills

T-SQL

DAX

SSAS Tabular

Python

Data analytical skills

Problem-solving skills

Communicative skills

Tools

Power BI

SSRS

DevOps tools (GIT, CI)

Job description

Role

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.

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

Requirements

• 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