Data Analyst

Location: London

*** Mention DataYoshi when applying ***

Data Analyst

FTC 12 months

Take a lead role within the Data Warehouse tower within MSAmlin. The role will involve the support of all Data Analysis for the Data Warehouse and ETL solutions to support projects and small change within the suite of Data Warehouse applications and be the Lead within the team.

The role will be engaged in the investigation, evaluation, interpretation and classification of data, in order to define and clarify information structures which describe the relationships between real world entities. Such structures facilitate the development of software systems, links between systems or retrieval activities. They will investigate corporate data requirements, and apply data analysis, data modelling and quality assurance techniques, to establish, modify or maintain data structures and their associated components (entity descriptions, relationship descriptions, attribute definitions). They will provide advice and guidance to database designers and others using the data structures and associated components.

There will be a level of Data Analysis support activity during the development, testing, release and warranty phases of any project and work packages. There will also be an element of support activities for user enquiries and other identified issues that arise within Data Warehouse and ETL environments as required.

The role will work closely with the Datawarehouse Development and Support Managers to ensure that all data solutions are implemented with data quality in mind. The role will also interface directly with the Enterprise Data Architects and the CTO team

  • Data specification based upon business specifications, user requirements and optimal presentation of data to reporting tools such as MicroStrategy.
  • Data design of all aspects of Data Warehouse deliverables which will include input into the Business Glossary, ownership and delivery of source to target mappings, amendment and adherence to the Physical Data Model, Data Profiling and input into business rules.
  • Design will ensure data is modelled logically, consistently and intuitively, making certain that proposed solutions perform optimally within agreed tolerances.

    Provide consultancy and development estimates with Key assumptions as part of evaluating work packages in support of projects relating to data deliverables and overall project or BAU deliverables

  • Liaise with business representatives, business expert users and BA, PM, Developers and Architects to ensure all requirements are within scope of the proposed solution, the Data Warehouse structure and the companies’ data strategy.
  • Ensure alignment to MS Amlin’s Information Governance Framework through liason with CTO, the Data Architacture Team and the Information Governance Committee.
  • Involvement in Project & BAU work as a Project Team Member where required.
  • Production and maintenance of documentation including technical, procedural and administrative documents where required.
  • Provide second line support as part of transitioning warehouse deliverables from projects to dedicated support team.
  • Proficiency to an intermediate hands on level – SQL Server (T-SQL and SSIS), InfoSphere Data Architect, Microsoft Master Data Services, Excel

4. The Operating Environment and Context of the Job

Ownership of assigned project work packages and delivery as per schedule agreed with Tower Lead.

Where appropriate to operate as technical lead on a project in support of other less experienced members of the team.


The role is based in London or Chelmsford but covers all aspects of Data Analysis work across the organisation so there will be the requirement to occasionally work from other locations as necessary.

5. Key Competencies:


Job Specific

Organisational Skills

Ability to work to quality standards and in a structured environment

Ability to work to tight deadlines and under pressure

Data Warehouse - Data Design

Work as part of a team

SQL skills along with full understanding of data design concepts, data modelling, data profiling, Logical Data Model design & adherence, Kimball methodology, quality controlled documentation

Self Management

Delivering Results

Understanding Business Analysis & requirements

Data Analysis Capability

6. Cultural Behaviours:

The behaviours that the job holder must exhibit for desired cultural fit.

Client Centric

Places all our internal and external clients at the centre of decision making; develops propositions that are fair, relevant and useful


Thinks about future possibilities and outcomes that can shape success in original ways


Provides opportunities and support for colleagues to grow and succeed


Able to work as ‘one team’ to gain commitment and results to ensure success for all


Acts with integrity to deliver on commitments, ensuring the same for others


Ambitious and disciplined in setting and achieving goals

7. Key Interfaces:


  • PM, BA team, managers and stakeholders
  • BI (& MI) consumers at all levels within Amlin
  • Testing team
  • DBA team
  • BI Solution Delivery Team
  • BI Service Delivery Team
  • BI Development & Support team
  • Ops Strategy & Architecture team
  • IT Services

*** Mention DataYoshi when applying ***

Offers you may like...

  • Talent Relations

    Data Analist/Data Scientist
    Postcode 2408 in Alphen aan den Rijn

    Data Scientist / Data Analyst - Nantes
    Nantes (44)
  • Bangura Solutions

  • B 3 Group Inc

    Data Analyst
    North Chicago, IL
  • Save the Children

    Humanitarian Performance and Operational Data Anal...