Login
Sign-Up

Team Leader - BI DWH Specialist - SQL Server - Insurance

INFORMATION ABOUT THIS JOB

Job Title Team Leader - BI DWH Specialist - SQL Server - Insurance
Contract Type Permanent
Location City of London, London
Salary £85 - £105000 per annum + with excellent bonus & benefits
Job Published 10 days ago
REF BBBH7975_1528990619
Contact Name James Neale
Contact Email jneale@venquis.com

Job Description

Team Leader Data Warehouse and Business Intelligence - SQL Server - Insurance

London - City

£85,000 - 105,000 with excellent bonus & benefits

Urgent requirement for an experienced Datawarehousee (DWH) and Business Intelligence (BI) Team Leader for an international Reinsurance business. Applicants will require comprehensive SQL Server ability and will ideally have experience with v2016.

Job summary
The Leader of the Data Warehouse (DW) and Business Intelligence (BI) team is primarily responsible for setting the DW / BI strategy and architecture in line with the overall business and IT strategy.

The position demands strong experience and knowledge across the entire project lifecycle, within the data warehouse development and reporting arena; several years of experience in designing relational data models is a must, as well as mastering ETL concepts and having solid hands-on expertise in ETL development. Multidimensional data modelling is also required, with a robust understanding of the concepts related to fact tables and dimensions, the Kimball-style BI, and being well versed with OLAP tools.

The role expects additionally a high level of experience and capability to build and enhance reinsurance financial reporting solutions and data presentation to reinsurance finance and technical accounting business users. The ability to have discussions with the reinsurance finance department to obtain indications, offer solutions and to present results is key to this role. The capability to work independently and to manage different tasks in a fast paced business and technical environment is also a key for success, together with strong curiosity, attention to details without losing sight of the big picture, and the willingness to stay abreast of new technologies and ideas.

Main Responsibilities

  • Managerial and technical lead of the DW / BI team
  • Setting the DW / BI strategy in line with the overall business and IT strategy
  • Setting the DW / BI architecture, structure, and procedures in line with the development of, and changes in the surrounding business applications and systems
  • Assuring day to day operations are successful
  • Interact with business departments, especially reinsurance finance, to discuss new matters or corrections
  • Develop new data projections in reports and multidimensional cubes
  • Develop new ETL logic and components or mending the existing ones
  • Develop TSQL code for both maintenance and business data manipulation
  • Carry on data analysis for new developments or for investigation
  • Create new SQL Server structures at all levels, carry on maintenance and tuning
  • Create new environments, maintain existing production and non-production systems
  • Support business users, especially reinsurance finance, in their analysis or on technical issues
  • Offer guidance and proactive support on all the matters gravitating around the data side
  • Take responsibility on tasks or projects accordingly to the company's needs

Knowledge and Skill Level Required

  • At least 5 to 10 years of experience in managing DW / BI teams
  • At least 7 to 10 years of experience in designing, building, and implementing a DW / BI strategy, architecture, and structure
  • At least 7 to 10 years of profound experience with MSSQL, ideally from 2008 to 2014; SQL 2016 is an advantage
  • At least 7 to 10 years of experience of developing reporting solutions for both relational and dimensional data with Microsoft Reporting Service, with a strong knowledge of reinsurance finance and a focus on reinsurance financial reporting
  • Mastering of the MSSQL tools at several levels is mandatory, as well as a strong DBA expertise
  • At least 7 to 10 years of solid experience with Analysis Service. Fact, DIM, SCD, Many-To-Many; Tabular Nice to have
  • At least 7 to 10 years of hands-on experience with SSIS; solid concepts of ETL designing and best practises
  • A strong familiarity with Excel is also required, ideally in its latest forms, with Power View, Power Pivot and Power BI all nice to have
  • At least 7 to 10 year hands-on usage of TSQL, both in relational as well as dimensional environments; ideally knowledge and expertise in other languages, such as C#, MDX, DAX
  • Several years of operating in distributed architecture, solid understating of Windows Server 2012, experience to work with Visual Studio in team. Knowledge of solutions for data distribution such as Replication and Always-On nice to have, as well as advanced concepts for data manipulation such as Change Tracking, Columnar Indexes, Partitioning, etc.
  • Familiarity with other areas and processes such as Change Management, Environment Segregation, Release Management, as well as High Availability, Disaster Recovery, Business Continuity, etc. is an additionally asset that completes the profile

Team Leader Data Warehouse and Business Intelligence - SQL Server - Insurance

London - City

£85,000 - 105,000 with excellent bonus & benefits

Ref: BBBH7975_1528990619 | Published: 14th Jun 2018

SHARE THIS JOB

SIMILAR JOBS

City of London, London
Published: 4 days ago
City of London, London
Published: 4 days ago
City of London, London
Published: 24 days ago
Munich / München
Published: about 2 months ago

Social stream