SQL DEVELOPER – £60K – LONDON
Operations Infrastructure Developer / SQL / Asset Management / FX derivatives / Fixed Income / Python
Successful investment management firm with over $1bn assets under management in numerous funds.
Our infrastructure involves a commercial portfolio management system (PMS) and a data-warehouse, a key part of this roll will be working with the ancillary systems that consume data from the PMS and data-warehouse.
These ancillary systems provide workflow automation, process controls and management information.
A typical ancillary systems that we have in place is a few hundred lines of python code that makes heavy use of loading data from a SQL database into a Pandas dataframe, manipulating it and outputting to a database or email report. EXPERIENCE REQUIRED Looking for an Operations Infrastructure Developer, to help us maintain and build our operations infrastructure.
You MUST have worked in an Assent Management recently Ability to build solutions to data and automation problems from scratch, with no pre-existing template to follow.
Ability to understand python code written by others and maintain and expand that code.
Ability to analyse financial performance and automate medium complexity reports and metrics describing financial performance.
Ability to collect specifications from diverse stakeholders, mediate conflicting requirements and act on specifications to build systems.
Ability to build solutions that extract data from a system, transform data and load into a disparate system.
Ability to code up solutions alone without needing daily oversight.
Must be comfortable supporting solutions that are required to run successfully every day. Domain knowledge of ledgers containing investment transactions necessary Domain knowledge of ledgers containing accounting transactions advantageous
2:1 or higher in numerical (maths/physics/engineering/etc) or computer science degree
Must have technical competencies:
SQL Python & Pandas Advantageous technical competencies:
MS SQL Server Stack SSIS / SSRS / SSAS SFTP System scripting PyCharm development environment Azure DevOps
Advantageous regulatory knowledge
Advantageous financial instrument knowledge
Interest rate derivatives
Equity and resultant corporate actions