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. All instances of UnaVista are hosted by the Exchange. It is a ‘rich internet application’, written in Java with a SQL Server back end, and pure HTML/Javascript front end.

Technical requirements:

• 1-2 years 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 optimize 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 for this role are:

• To build new solutions on the UnaVista platform in accordance with requirements prioritized by product management and regulators

• To deliver optimized and scalable solutions ensuring on-going support requirements are minimized

• 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

• Bookster

• Share Purchase Plan

• Volunteering Days

People are at the heart of what we do and drive the success of our business. Our culture of connecting, creating opportunity and delivering excellence shape how we think, how we do things and how we help our people fulfil their potential.

At LSEG we embrace diversity and actively seek to attract individuals with unique backgrounds and perspectives. We break down barriers and encourage collaboration, enabling innovation and rapid development of solutions that make a difference. Our workplace generates an enriching and rewarding experience for our people and customers alike. Our vision is to build an inclusive culture in which everyone feels driven to reach their potential.

We know that real personal growth cannot be achieved by simply climbing a career ladder – which is why we encourage and enable a wealth of avenues and interesting opportunities for everyone to broaden and deepen their skills and expertise.

LSEG are committed to supporting emotional, physical, financial and societal wellbeing. Our tailored benefits are a key part of this commitment and we offer colleagues a range of support from healthcare and retirement planning to paid volunteering days and consumer discounts.

We also make reasonable accommodations for applicants and employees with disabilities. If an accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please make your recruiter aware, we want to ensure you perform at your best.

As a global organisation spanning 70 countries and one rooted in a culture of growth, opportunity, diversity and innovation, LSEG is a place where everyone can grow, develop and fulfil your potential with purposeful careers.