Connecting to LinkedIn...

BI Solutions Architect

Job Title: BI Solutions Architect
Contract Type: Permanent
Location: City of London, London
Salary: Up to £73000 per annum
REF: 14733/002_1536937314
Contact Name: Kieron Holmshaw
Contact Email:
Job Published: 4 months ago

Job Description

The aim of this role is to contribute to a vibrant, growing, Tableau installation and data warehouse, developing new reports, and working with stakeholder's right across the business to ensure their needs are met.

Purpose of Job:

Being an Architect with deep level subject matter expertise across the board, and proven ability to deliver projects in a fast paced and changing business environment.

Focus is primarily in delivering a data warehouse that is utilised by our Tableau based Analytics teams but should be available to any tooling. As such the main skills focus is SQL Server, SSIS, but the ideal candidate will need to understand end to end solutions with the aim to create Self-service environments and information sets

Key Responsibilities

The Information Solutions Architect will:

  • Architect and design Data Warehouse infrastructure and solutions

  • Gather and analyse business requirements and develop technical specifications and design documents

  • Develop, enhance, and integrate Data Warehouses/Data Marts and Business Intelligence Solutions to Enterprise standard solutions

  • Develop overall strategic data architecture direction and provide a comprehensive road map for the Enterprise Data Warehouse

  • Perform data profiling to detect patterns, trends and anomalies to gain more in-depth understanding of data requirements and needs to ensure model is fit-for-use

  • Test, deploy and maintain Data Warehouses/Data Marts

  • Continue the redesign the Current Data warehouse and scale it up into an Enterprise level solution.

  • Provision of a Certified information layer for Reporting and Self-Service

  • Mentor the more junior team members

Qualifications, Skills and Experience

  • 5+ years of experience with majority of exposure in Insurance working as Data Solution Architect / Data Modeller

  • In-depth understanding of Insurance based business model preferred In-depth SQL knowledge to enhance and develop the data architecture required to support SQL Server based applications and data warehouse environments essential.

  • Strong quantitative and analytic skills are required. Proven ability to quickly earn the trust of key stakeholders

  • Extensive experience implementing data warehousing, data architecture, & data modelling, including strong knowledge of various data modelling approaches and practices (Kimball Preferred)

  • Hands-on experience with complex database implementations in SQL Server 2012 onwards

  • In-depth understanding of data integration and interface platforms and technologies

  • ETL (Extraction, Transformation and Loading) experience required

  • Actively used Agile Scrum methodology in a Data warehouse environment

  • Experienced in using modelling tools Erwin & ER/Studio Data Architect