Job Details

Data Analyst, Modelling

£50,000 , Permanent

Posted: 21 hours ago


Data Analyst/ModellerLondon/HybridCirca £50k + bonus + benefits

SQL, ETL, Modelling

Junior Data Modeller required by thriving insurance group in the City of London. The successful candidate will play a pivotal part in producing technical requirements detailing the appropriate technical specification to support new requirements including source to target mappings and business cases. You will work closely with Data Architects, Business Analysts, Data Governance and ETL teams.


  • Responsible for composing data requirements, process flows and design into clear and consistent documentations.
  • Document and maintain data lineage.
  • Work with various business stakeholders to understand their needs and help to translate them into clear data requirements.
  • Help to design, maintain and document key database schemas to ensure they meet requirements.
  • Help maintain the integrity and security of all databases used by the group
  • Help to ensure up to date records are maintained at all times on the group systems.


  • Experience of working as ETL Developer, Data Analyst or similar role (at least 5 years).
  • Good knowledge of data warehouse dimensional modelling using Kimball methodology.
  • Experience in source to target mappings.
  • Able to compose requirements, process flows, and design into clear documentation.
  • Strong proficiency in Microsoft SQL Server (including the ability to query and investigate the data).
  • Experience in implementing ETL processes (including extracting, merging, and incrementally loading data).
  • Good understanding and creating entity-relationship models.
  • Experience using Azure Data Factory (ADF) and SQL Server Integration Services is an advantage.
  • Exposure to other MS products/platforms/technologies and tools.
  • BA/BSc degree in Computer Information Sciences or related field.
  • Strong interpersonal and problem-solving skills.?

For a full consultation on this role please email your CV to Arc IT ASAP.

Job Details

London, United Kingdom