Data Warehouse Senior Developer

Employer: LSEG Romania
Domain:
  • IT Hardware
  • IT Software
  • Job type: full-time
    Job level: 1 - 5 years of experience
    Location:
  • BUCHAREST
  • Updated at: 21.09.2021

    Data Solutions for Capital Markets Technology team provide data solutions for the Capital Markets business. The team is comprised of Corporate Data Warehouse (CDW), Business Intelligence and Front-End teams, Application Development (App Dev) teams, a Solution Architect and Quality Assurance. The team works as a collective to craft and build valuable data solutions for Capital Markets business.

    The CDW Products team is responsible for delivering critical business logic such as billing and regulation requirements and data analytics requirements for BI reporting for the UK Equity, Derivatives Markets, Turquoise (pan-European Equity Markets) and Foreign Exchange.

    The team is in charge with providing an AWS cloud-based data factory (Kafka, EMR, Spark and Flink). The cloud data warehouse is Snowflake with Matillion as ELT tool.

    Key Responsibilities

    To carry out the following key tasks as a Senior Developer within the CDW Development team:

    • Reporting into the Team lead, the Senior Data Warehouse Developer‘s main responsibility is to assist the Product Manager / team lead with the design, development and maintenance of the data warehouse and related data transformation;

    • Work with the 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;

    • Provide Database Warehouse expertise and support to the team members;

    • Develop and extend database functionality to support current and future business needs;

    • Maintain and handle data feeds and work with business users to improve data flow into and out of the Data Warehouse;

    • Build improvements in existing code and systems to improve efficiencies;

    • Be able to understand and develop Java code is a big bonus;

    • Provide daily support to business functions.

    Candidate Profile

    Required Skills

    • A minimum of 5 years design, performance tuning, development and experience with data warehouse and ETL technology (Oracle, SQL Server, Snowflake etc);

    • Strong analytical and problem solving skills;

    • Experience of the whole development life cycle: requirements, design, development, testing;

    • Strong written and verbal communication skills with other team members, QA teams and internal business partners;

    • Be able to guide junior developers.

    Desirable Skills

    • Experience of cloud database and ETL technologies such as Snowflake or Matillion;

    • 1-2 years Python or Java experience;

    • Knowledge of Business Intelligence tools for data analysis and report generation (e.g. Business Objects, Data Visualisation);

    • 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.

    Key Behavior

    • Be comfortable working in a fast paced environment where needs evolve rapidly and priorities change;

    • Self motivated and pro-active;

    • Teammate (co-operative, support, be flexible, take ownership, appropriate challenge, maturity etc.);

    • Highly organised, self-disciplined and thorough;

    • Able to build good client (internal and external) relationships; establish and maintain rapport, orientation towards providing client service;

    • Interested in the evolution of the Financial Markets in Europe;

    • Happy to operate outside of their normal role when required.

    We are looking for intellectually curious people, interested in the bigger picture of how technology industry is evolving, ready to ask difficult questions and deal with complicated scenarios. If you a forward thinker and 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:

    • Pillar 3 Supplemental Pension

    • 25 days’ holiday a year

    • Private medical insurance

    • Group life insurance policy

    • Meal vouchers

    • Share Purchase Plan

    • Volunteering Days

    • Bookster

    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.