Treasury Data Engineer

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.

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:

The key responsibilities are:

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:

The following skills and experience are required for this role:

Excellent technical aptitude – T-SQL, DAX, SSAS Tabular, 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

LI-PS