SQL Solution Developer UnaVista is the London Stock Exchange's matching, reconciliation and data integration service, our customers being tier 1 investment banks, hedge funds, brokers and other financial institutions.
The UnaVista team is run along similar lines to a software company : our culture is dynamic, and requires each individual to adapt rapidly to change, contribute fully and think on their feet.
This role involves on-going interaction with all other areas (sales, pre-sales, professional services, development and QA, customer support, technical writing, marketing), as well as with customers.
As a SQL Solution Developer, you will work closely with our business and technical analyst teams to understand business requirements that drives the analysis and design of high quality solutions for our customers.
The EMIR Refit project will be part of the European Commission’s regulatory fitness and performance programme (REFIT), launched in 2012, aimed at simplifying EU legislation and reducing any unnecessary regulatory burdens for citizens and businesses.
Alongside other European regulations, EMIR has been assessed with that goal in mind and a number of improvements proposed.
The UnaVista EMIR Refit project will basically mean a redesign of the existing EMIR solution to fit the requirements and improvements issued by ESMA.
Technical requirements : At least 2-3 years (junior / mid level) or 4+ years (senior) of T- SQL development on Microsoft SQL Server 2008 / 2017 (preferably).
Skilled at creating and optimising large complicated T-SQL transactional statements Be proficient in database architecture design and performance tuning Demonstrated proficiency in working with large data sets (billions of records) Understanding Business requirements and translating them into technical solutions Experience in troubleshooting and resolving database issues (integrity, performance, blocking and deadlocking issues, etc.
Develop, implement and optimise stored procedures, functions and XML manipulation using T-SQL Preferably / Nice to have : Worked within an Agile / Scrum environment using tools like Jira, Confluence etc.
Financial / Banking / Insurance background preferred Java knowledge is a plus Key responsibilities : To build new solutions on the UnaVista platform in accordance with requirements prioritised by product management and regulators To deliver optimised and scalable solutions ensuring on-going support requirements are minimised To work with related teams (development, professional services, QA and support) to ensure that business solutions are delivered on time and with high quality standards To translate business requirements into actual technical solutions and document system features / functionalities Communicate effectively with project stakeholder to report on progress against agreed deliverables and escalate any critical issues / blockers.
We are looking for intellectually curious people, passionate about the bigger picture of how technology industry is evolving, ready to ask difficult questions and deal with complicated scenarios.
If you are creative and a problem solver, this is the place to be as will be supporting you to fast-forward your career.
We maximise each employee’s potential through personal development and through a wide range of learning tools both formal and informal.
We believe that remunerating our people with competitive salaries and a range of attractive benefits such as : Pillar 3 Supplemental Pension 25 days’ holiday a year Private medical insurance Group life insurance policy Meal vouchers Share Purchase Plan Volunteering Days