At a Glance
- Tasks: Join our team to design and develop data warehousing solutions for financial crime management.
- Company: Be part of the London Stock Exchange Group, a leader in financial markets infrastructure.
- Benefits: Enjoy tailored benefits, healthcare, retirement planning, and paid volunteering days.
- Why this job: Make a real impact in finance while working with cutting-edge technology and a dynamic team.
- Qualifications: 6+ years in databases and ETL tools; strong SQL skills required.
- Other info: Collaborative culture that values innovation and supports your personal growth.
The predicted salary is between 36000 - 60000 £ per year.
LSEG are embarking on a Finance Transformation programme, delivering our Finance Vision and redefining the way we work to bring value and deliver sustainable growth for the business. The Programme shall drive efficiencies and maximise benefits for LSEG by transforming our abilities of managing Financial Crime via our internal Engineering capabilities.
We have an exciting opportunity for a Data Engineer to join our dynamic team within the London Stock Exchange Group, working as part of the Financial Crime Engineering team, and supporting LSEG through designing and developing data warehousing solutions and integration of our core systems.
The role sits within the Corporate Engineering Delivery function, which provides technology services to Corporate Functions Teams for LSEG and we are looking for someone with demonstrated ability for our Financial Crime Engineering Team. This is a hands-on development position for a candidate with a demonstrable record of working with data analysis and database development having excellent development and problem-solving skills, someone with creativity and self-motivation to deliver on critically important projects with timelines and competing priorities and execution excellence (preferably in Financial Services) in supporting enterprise applications across various business units and has good exposure to various database engineering platforms.
As a Data Engineer, you will be responsible for:
- Work with a team of Developers to deliver the product led by data along with the desired functionalities and business outcomes.
- Managing backlog, designing, developing, delivering and supporting data warehouse changes in an Agile methodology.
- Ensure data structure and database designs align with application requirements, organization standards, business goals, and scalability needs.
- Develop ETL pipelines and processes for OLAP systems and data warehouses.
- Managing build and release activities for data solutions.
- Assisting with architecture artefacts to support product changes.
- Maintaining and optimizing of data modelling through continuous improvements and enhancements.
- Working with product owners, architects, business analysts, scrum master and other team members to deliver change on a timely basis.
Knowledge/Skills:
- Hands on experience in writing advanced SQL Queries.
- Strong analytical problem-solving skills.
- Hands on development experience with solid skills in designing, developing and deploying complex applications using OLTP and OLAP based databases.
- Hands on expertise in Physical Data Modeling and DB design with solid skills in performance tuning.
- Hands on experience in troubleshooting and resolving database performance issues.
- Hands on experience in building systems using modern, scalable, resilient, cloud native architectures. Experience on AWS is desirable.
- Hands on experience with multiple databases along with Snowflake and implementing complex stored procedures.
- Good knowledge of data modeling concepts like dimensional modeling and DWH concepts like change data capture (CDC).
- Hands-on experience in Matillion, Boomi or any other ETL tools.
- Scripting knowledge (e.g. Python, Spark etc.) would be desirable.
- Ability to provide production support for Data Warehouse issues such as data load problems, transformation/translation problems etc.
- Worked in Offshore / Onsite Engagements and collaborated across time zones.
- Should be a great teammate.
- Should be eager to learn new technology and/or functional areas.
Experience:
- At least 6 years of experience in various databases and ETL tools like Informatica, Matillion.
- Must have ETL E2E experience in documentation, development, testing & deployment to Production.
- Bachelor’s degree in computer science or related field.
- Strong Relational Database background and SQL Skills.
- Proficiency in automation and continuous delivery methods.
- Proficiency in all aspects of the Software Development Life Cycle in an Agile environment.
- Experience leading & managing a development team, preferably in a financial technology or banking MNC.
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 culture of connecting, creating opportunity and delivering excellence shapes how we think, how we do things and how we help our people fulfil their potential.
Data Engineer employer: London Stock Exchange Group
Contact Detail:
London Stock Exchange Group Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer
✨Tip Number 1
Network like a pro! Reach out to current employees at LSEG on LinkedIn or through mutual connections. A friendly chat can give you insider info and might just get your foot in the door.
✨Tip Number 2
Prepare for those interviews! Brush up on your SQL skills and be ready to discuss your experience with ETL processes. We want to see how you tackle real-world problems, so have some examples ready.
✨Tip Number 3
Show off your creativity! When discussing past projects, highlight how you’ve innovated or improved processes. LSEG loves candidates who think outside the box and bring fresh ideas to the table.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining our team.
We think you need these skills to ace Data Engineer
Some tips for your application 🫡
Tailor Your Application: Make sure to customise your CV and cover letter to highlight your experience with data engineering, especially in financial services. We want to see how your skills align with our needs, so don’t hold back on showcasing relevant projects!
Show Off Your Skills: When detailing your experience, focus on your hands-on development skills, particularly with SQL and ETL tools. We love seeing specific examples of how you've tackled challenges and delivered results in previous roles.
Be Clear and Concise: Keep your application straightforward and to the point. Use bullet points for easy reading and make sure to highlight your key achievements. We appreciate clarity, so avoid jargon unless it’s necessary!
Apply Through Our Website: We encourage you to submit your application directly through our website. It’s the best way for us to receive your details and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at London Stock Exchange Group
✨Know Your Data Inside Out
As a Data Engineer, you’ll need to demonstrate your expertise in SQL and database design. Brush up on advanced SQL queries and be ready to discuss your experience with data warehousing solutions. Prepare examples of how you've optimised database performance or resolved issues in past projects.
✨Showcase Your Problem-Solving Skills
The role requires strong analytical problem-solving skills. Think of specific challenges you've faced in previous roles, especially related to ETL processes or data modelling. Be prepared to walk through your thought process and the steps you took to overcome these challenges.
✨Familiarise Yourself with Agile Methodologies
Since the position involves working in an Agile environment, it’s crucial to understand Agile principles. Be ready to discuss your experience managing backlogs and collaborating with cross-functional teams. Highlight any tools you’ve used for Agile project management.
✨Demonstrate Your Team Spirit
LSEG values collaboration, so it's important to show that you're a great teammate. Share examples of how you've worked effectively within a team, especially in offshore/onsite engagements. Emphasise your eagerness to learn and adapt to new technologies, as this aligns with their culture of continuous improvement.