Datawarehouse Developer

Datawarehouse Developer
  • Competitive
  • Contract
  • City of London, London, England, UK City of London London GBR EC3M 3AW
Job Ref: 50214349
Sector: Software Development
Date Added: 09 June 2021
Key Responsibilities
  • Assist the MI Manager and warehouse architect with activities pertaining to the LSM datawarehouse, finance mart and cube
  • Assist where necessary with development and testing activities to ensure released code is of required quality and development deadlines are met
  • Maintain close, good working relationships with customers of the department, finance and IT colleagues including the warehouse development team
  • Adhere at all times to company procedures and standards.
  • Field end user queries related to the warehouse and related systems including assisting with retrieval and understanding of warehouse and mart data as well as guidance on use of an analysis services tabular cube
  • Adherence to all relevant regulatory requirements forms part of your role, and the demonstration of behaviours as set out in the Conduct Risk Policy, as they relate to your role, is core to LSM's commitment to placing customers at the centre of our business and behaving with integrity. LSM expects you to understand your responsibilities relating to all regulatory and internal requirements, and to proactively demonstrate compliance with these requirements and behaviours at all times. These requirements include Solvency II, fair treatment of customers, Financial Crime, Data Protection, Conflicts of Interest, and Whistleblowing.
  • Owning assigned tasks and seeing these through to successful completion
  • Also provide support assistance for other existing SQL based applications and provide development capabilities when required.
Skills and Experience
  • Have an in-depth knowledge of the Microsoft BI Stack:
    • Advanced knowledge of MS SQL Server T-SQL
    • Strong experience of ETL development, including use of SSIS to move data between systems and automate load processes
    • Strong knowledge and experience of Microsoft Analysis Services Tabular cubes and the DAX language
    • Experience using Visual Studio/SSDT for BI related development activity
    • Use of TFS as a code repository, deployment of code under change management and use of deployment Azure Dev Ops pipelines
  • Good understanding of reporting database systems their design, particularly Kimball modelling methodologies
  • Good understanding of data warehouse systems, their function and the business requirements they are intended to service
  • General knowledge of IT concepts, strategies and methodologies, including architectural and security concepts, systems development lifecycle, information management and portfolio management (production systems, release planning, change management).
  • Knowledge of industry technologies and application including new and current architectures, including data modelling and overall solution design.
  • Proactive approach to fault finding and issue resolution.
  • Ability to communicate well with technical and non-technical colleagues.
  • Experience of working in both agile and SDLC development environments.
  • Experience of Team Foundation Server/Version Control Systems.
  • Good knowledge of business functions, business operations, objectives and strategies.
  • In-depth knowledge IT standards and guidelines.
  • Experience with insurance platform data (e.g. Genius/IRIS) to understand how London Market policies and claims are modelled.
  • Knowledge of CI/CD (continuous integration/continuous delivery) advantageous

We are an equal opportunities employer and welcome applications from all suitably qualified persons regardless of their race, sex, disability, religion/belief, sexual orientation, gender reassignment, marriage and civil partnerships, pregnancy or maternity or age

09/07/2021 15:11:43
GBP Annum
Contact Consultant:
Amy Stratford

Submitting application, please wait..