Data Warehouse Developer

About the FXI CMDF teamCapital Markets Data Factory (CMDF) is a cloud-based data warehouse used for Billing, Regulatory Reporting and Customer Analytics.The FX team uses the CMDF to manage data from the new Foreign Exchange trading venues being built as part of FXI, the project within LSEG to re-platform all the Refinitiv FX trading venues.The FX CMDF team covers a Technical Architect, Business Analysts, a DWH team, a BI team and an Application Development Team.CMDF is being built from scratch, and most of the fast-growing team have joined LSEG fairly recently. Working in the team provides an opportunity to work in a near greenfield project with cloud-based technology, and to learn in detail how a foreign exchange market operates.Job OverviewWe are looking for a Data Warehouse Developer with an understanding of cloud and data warehouse technologies. The candidate will be working closely with the business, architect, and BAs to define solutions for the following key capabilities for FX markets:

• Data landing from trading systems.
• Billing calculation and management.
• Regulation requirements
• Customer and internal reporting and analytics.

The DWH development team, a QA team and a Project Manager for the FX CMDF project are based in Bucharest.The role reports to the DWH development team leader, also based in Bucharest.Responsibilities

• Development and maintenance of the data warehouse and related data transformation.

• Work with Business Analysts, Java Developers, End Users, Devops, BI developers and QA teams when appropriate.
• Deliver technical documents such as Technical Designs, Specifications, Users Guides.
• Design, Development and maintenance of Data Warehouse storage and transformation using Snowflake and Matillion.
• Take shared responsibility for all database support, development and administrative work to:
  • Provide FX Data warehouse functionalities (Snowflake)
  • Use ETL (Matillion)
  • Develop and maintain SQL code on Snowflake
  • Develop and maintain good coding standards.
  • Develop and extend database functionality to support current and future business needs
  • Maintain and manage data feeds and work with business users to improve data flow into and out of the Data Warehouse
  • Create improvements in existing code and systems to improve efficiencies
  • Provide daily support to business functions.
  • Participate in peer-reviews of solution designs and related code.

Required Skills

• A minimum of 3 year's design, performance tuning, development and experience with data warehouse and ETL technology (Oracle, SQL Server, Snowflake etc)
• Oracle - SQL, PL/SQL - min 3 years experience
• ETL Tool (any tool) - min 2 years experience
• DWH (concepts , implementation) - min 2 years experience
• Strong analytical and problem solving skills.
• Exposure to the whole development life cycle: design, development, testing.
• Strong written and verbal communication skills with other team members, QA teams and internal business stakeholders.

Desirable skills

• Experience of cloud database and ETL technologies such as Snowflake or Matillion.
• Experience with agile development methodologies including Kanban and Scrum and full SDLC experience
• Experience with source control management systems, continuous integration/deployment environments, and release management.

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 maximize 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:

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)
Dental Coverage
Life insurance
Pillar 3 Private Pension
Meal Vouchers
Flexible Benefits
Bookster
Volunteering Events
Team Buildings

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.