Solutions Engineer

Description du poste:

Post Trade Regulatory Reporting (PTRR) is a department within Markets which owns an estate of systems built on the PTRR Platform. The systems cover a range of functions from the generation of LEIs and ISINs for the UK to the regulatory reporting systems like EMIR Trade Repository and MiFIR Reporting. All are underpinned by the PTRR Platform, an ETL and visualisation suite developed in-house since 2006.

The PTRR Solutions Engineering team traditionally manages the configuration layer of systems created on the PTRR Platform, from initial blank install to initial delivery and then on into feature development and maintenance releases. Recent releases such as EMIR Refit have seen a move to incorporate technologies currently outside the PTRR Platform, with integration back to the Platform.
Based in the Technology centre in Bucharest, Romania, the Solution Engineer will work within a Scrum team to apply business requirements to develop productions that satisfy customer needs. They will also provide assistance to support the product in the live environment by performing in depth analysis of raised issues and developing fixes to remediate the problems.
The role reports to the Scrum team's technical lead.

Key Responsibilities:
* Demonstrates knowledge of technologies within LSEG and how they relate to various parts of the business
* Develops tools and applications by producing clean and efficient code, may also review others' code when required
* Manages own workload and promotes an inclusive and open culture
* Develops knowledge and expertise in software development and develops knowledge of other domains to understand linkages and dependencies
* Builds understanding of strategy and culture, and how they impact own work
* Executes on the delivery of given tasks with some guidance and oversight
* Builds trusting relationships with team and colleagues, collaborating closely with team
* Communicates with clarity and precision in a concise format
* Takes initiative to develop knowledge in technology products and tools through on the job learning, certifications and projects.
* Will work within an agile framework, participating in all ceremonies and working collaboratively with colleagues.
* Has a strong emphasis on build quality which is achieved by adhering to best practise and also thorough unit testing.
* Work closely with Site Reliability Engineers to understand problems in the production environment, perform detailed analysis to find the cause
* Write clean, efficient code using SQL Server to remediate bugs through code fixes, careful testing and documented processes.
* To own one's changes through the build and test phases and also deploy to the production environment.

Candidate Profile / Key Skills:
Essential experience and skills required:
2+ year's experience in :
* Must have excellent query writing skills in SQLServer, most notably:
o DDL ie. Create /alter/drop tables and views
o DML ie. Insert / delete from tables, select and update columns from tables.
o Aggregating data ie. Calculate sum, count, min,max of values in a given data set, using group by
* Good awareness and understanding of SQL query performance optimization
* Able to demonstrate good analytical and problem solving skills.
* Sound written and verbal communication skills and ability to present ideas to others.
Bonus skills:
* Knowledge of Snowflake, Powershell is very beneficial
* Experience in Python
* Knowledge of cloud concepts, data warehouse and services is desirable.

Behavioural Skills:
Must be self-motivated and have a desire to engage in process improvement.
* Have ambition to succeed and shows initiative
* Keen to collaborate with colleagues in the team and other teams
* Well organized, pays attention to detail
* Good interpersonal and communication skills
* Has an enthusiasm for learning new concepts, using colleagues and resources where possible but also through individual curiosity and application
* Should be resilient, undeterred by problems and setbacks
* A keen problem solver

Benefits:
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 through a wide range of learning tools both formal and informal. We believe in remunerating our people with competitive salaries and a range of attractive benefits such as:
* 25 days' holiday per year
* 1 additional day off for your Birthday
* Annual wellness allowance
* Share Purchase Plan
* Medical Health Insurance
* Medical Subscription (preventive medical services)
* Life insurance
* Pillar 3 Private Pension
* Meal Vouchers
* Flexible Benefits
* Bookster
* Volunteering Events
* All LSEG colleagues with at least one year's continuous service, who become parents, are now entitled to at least 26 weeks' paid leave, and the option to return to work on a phased basis, in relation with specific company's policy and guidelines

Career Stage:Associate

London Stock Exchange Group (LSEG) Information:
Join us and be part of a team that values innovation, quality, and continuous improvement. If you're ready to take your career to the next level and make a significant impact, we'd love to hear from you.

LSEG is a leading global financial markets infrastructure and data provider. Our purpose is driving financial stability, empowering economies and enabling customers to create sustainable growth.

Our purpose is the foundation on which our culture is built. Our values of Integrity, Partnership, Excellence and Change underpin our purpose and set the standard for everything we do, every day. They go to the heart of who we are and guide our decision making and everyday actions.

Working with us means that you will be part of a dynamic organisation of 25,000 people across 65 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.

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 mental health or physical disability needs.

You will be part of a collaborative and creative culture where we encourage new ideas. We are committed to sustainability across our global business and we are proud to partner with our customers to help them meet their sustainability objectives. Our charity, the LSEG Foundation provides charitable grants to community groups that help people access economic opportunities and build a secure future with financial independence. Colleagues can get involved through fundraising and volunteering.

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

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