Treasury Data Engineer: ELT, SSAS & Power BI

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

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.