Technical Business Analyst - Data Projects (SQL)

Technical Business Analyst - Data Projects (SQL)
  • £600 per Day
  • Contract
  • City of London, London, England, UK City of London London GBR ec1a 4af
Job Ref: BBBH22484
Sector: Data & Analytics
Date Added: 06 May 2022
  • Technical Business Analyst - Data Projects
  • London - Hybrid. Onsite 2/3 days per week
  • 6 months
  • Inside of IR35

My client, a large Insurance Company, is looking for a Technical Business Analyst to work in their Data Pillar. The Data Team is responsible for delivery of strategic solutions under the Data Driven Organisation (DDO) programme of work, including core data platforms in the guise of the clients datawarehouse and associated reporting and analytical solution. We are responsible for the support of these platforms and also providing a data development and analysis function to other teams.

Key Responsibilities

  • Help the client's data team to deliver it's objectives under the DDO strategic programme
  • Working closely with the development teams; using your analysis skill and experience you will break complex
  • requirements down enabling developers to engage and deliver the correct solution
  • Gain knowledge of the data team's processes and functions to play an effective role as a custodian of our
  • values and operating methods - you will act as a guide to those looking to engage our tea
  • Help the data team in it's day to day operations; responding to add-hoc incoming requests and advising those
  • who ask for our assistance
  • Help maintain the team's documentation (for both systems and processes)
  • Ensure solutions are tested from the beginning of it's development to release - we deliver quality first time
  • Assist in impact analysis of change on systems, highlighting the options, impact and potential links between
  • other changes and systems allowing informed decisions to be made
  • Maintain strong, close, working relationships with customers of the department and IT colleagues. We are
  • open, pragmatic and act with honesty and integrity at all times.

Skills and Experience

  • Demonstrated ability to communicate both in business and technical terms
  • Knowledge, experience and understanding of ETL processes including the ability to analyse existing ETL
  • Use of Jira as a tool to track and manage work items and Confluence as a repository of knowledge - we
  • document as we deliver and learn.
  • Familiarity with SSIS as an ETL tool
  • Good knowledge of MS Excel to help with requirements gathering and demonstrating concepts
  • Familiarity with SQL, SQL tools and general database principles
  • Knowledge of London market insurance
  • 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.
  • AWS Experience is desirable.

If you are interested and available please apply today!

Lorien Plc is acting as an Employment Business in relation to this vacancy.

05/06/2022 14:36:50
GBP 0.00 600 Day
Contact Consultant:
Hollie Smith

Submitting application, please wait..