DataWarehouse Developer Team Lead (SQL)

Solutions Team Lead

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 Solutions Team Lead, you will work/coordinate closely with a small team of Solution Engineers (SQL) along 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:

• At least 4-5 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
• Experience in leading small development teams technically and mentor junior SQL developers

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:

• Technical and team leadership for the EMIR (Refit) project with full accountability for that product's solution delivery.
• Act as a Lead Solutions Architect, fulfilling all of the requisite responsibilities of the role by:
• Guide team development efforts towards successful project delivery
• Provide technical guidance to colleagues through mentoring, coaching and technical training
• Identify and nurture area of growth within the team both technically and functional
• 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.
• Coordinate teams into projects but also monitoring, offering feedback and performing annual objective settings / appraisals

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

People are at the heart of what we do and drive the success of our business. Our colleagues thrive personally and expertly through our shared values of Integrity, Partnership, Innovation and Excellence, which are at the core of our culture. We embrace diversity and actively seek to attract people with outstanding backgrounds and perspectives. We are always looking at ways to become more agile, so we meet the needs of our teams and customers. We believe that an inclusive collaborative workplace is pivotal to our success and supports the potential and growth of all colleagues at LSEG.

At LSEG, we believe that creating a diverse and inclusive organisation is fundamental to the way we deliver on our promise of creating essential partnerships and open opportunities. Our open culture is central to how we deliver our purpose - driving financial stability, empowering economies and enabling customers to create sustainable growth - in everything we do.

Working with us means that you will be part of a dynamic organisation of 25,000 people across 70 countries. However, we will value your individuality and enable you to bring your true self to work so you can help enrich our diverse workforce. You will be part of a collaborative and creative culture where we encourage new ideas and are committed to sustainability across our global business. You will experience the critical role we have in helping to re-engineer the financial ecosystem to support and drive sustainable economic growth. Together, we are aiming to achieve this growth by accelerating the just transition to net zero, enabling growth of the green economy and creating inclusive economic opportunity.

LSEG offers a range of tailored benefits and support, including healthcare, retirement planning, paid volunteering days and wellbeing initiatives.

We are proud to be an equal opportunities employer. This means that we do not discriminate on the basis of anyone's race, religion, colour, national origin, gender, sexual orientation, gender identity, gender expression, age, marital status, veteran status, pregnancy or disability, or any other basis protected under applicable law. Conforming with applicable law, we can reasonably accommodate applicants' and employees' religious practices and beliefs, as well as any mental health or physical disability needs.

Please take a moment to read this privacy notice carefully, as it describes what personal information London Stock Exchange Group (LSEG) (we) may hold about you, what it's used for, and how it's obtained, your rights and how to contact us as a data subject.

If you are submitting as a Recruitment Agency Partner, it is essential and your responsibility to ensure that candidates applying to LSEG are aware of this privacy notice.