Warehouse Data Modeller - London, United Kingdom - Handelsbanken

Handelsbanken

Verified Company

London, United Kingdom

2 weeks ago

Posted by:

Tom O´Connor

beBee Recruiter

Description

Job Introduction

ABOUT HANDELSBANKEN:

Handelsbanken is a local relationship bank built on timeless and sustainable values.

The Bank specialises in providing personalised banking services to both businesses and individuals, as well as wealth and investment management services through its UK subsidiary Handelsbanken Wealth & Asset Management.

Handelsbanken operates a decentralised way of working, with a strong local presence due to a nationwide branch network and a long-term approach to customer relations.

Each Handelsbanken branch operates as a small business enabling it to make decisions at a local level and provide a service that is bespoke, with the focus always being on the needs of each individual customer.

Throughout the organisation, individuals enjoy wide-ranging responsibility, and the scope to pursue a unique career, within a culture of openness, equality and professionalism.

ROLE OVERVIEW

As we continue to develop our data warehouse to meet the ever increasing demands from the business in regard to both internal and external reporting requirements.

Main Responsibilities

ESSENTIAL DUTIES AND RESPONSIBILITIES:

Be required to design, implement and document data architecture and data modelling solutions which include the use of relational and dimensional databases: these solutions are required to support enterprise information management, business intelligence, reporting and analysis
Be responsible for the design and development of the conceptual, logical and physical data models of the data warehouse (including operational data store (ODS), info store, data marts)
Contribute to the expansion of existing data architecture and the optimisation of data query performance via best practices
Be able to work independently and collaboratively as part of the data warehouse team in a matrix environment
Be able to use existing models, map to data dictionary components and extend where required

Responsibilities

Understand and translate business needs into data models supporting longterm solutions for data analysis and reporting, preferably within financial services
Work with the data warehouse development team to design, develop and implement conceptual data models and build data flows in line with agreed data strategies
Create logical and physical data models using best practices to ensure high data quality and to meet the business requirements
Optimise and update logical and physical data models to support new and existing projects
Maintain conceptual, logical and physical data models along with corresponding metadata
Develop best practices for standard naming conventions and coding practices to ensure consistency of data models
Identify and recommend opportunities for reuse of data models in new environments
Evaluate data models and physical databases for variances and discrepancies
Validate business data objects for accuracy and completeness
Develop data models according to the organisation's group standards whilst catering for local data needs
Identify and recommend solutions on any project limitations and capabilities, performance requirements and interfaces

**SKILLS, EXPERIENCE AND QUALIFICATIONS: - Degree in computer/data science or relevant technical and related experience

5+ years of handson relational, dimensional, and/or analytic experience (using RDBMS, dimensional, data platform technologies and ETL & data ingestion protocols)
Handson modelling, design, configuration, installation, performance tuning, and sandbox POC
Ability to work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks
Detailed knowledge and experience in star schemas, ERDs and an indepth understanding of the difference between Kimball vs Inmon approach for building a data warehouse
Experience with data warehouse, enterprise data platforms and data marts in multidatacentre contexts
Good knowledge of metadata management, data modelling and related tools
Experience in collaborating with business SMEs to understand context of business operation and data usage
Experience with stakeholder engagement, communication and presentation

About The Company

Handelsbanken is a relationship bank with a decentralised way of working, a strong local presence thanks to a nationwide network of branches, and a long-term approach to customer relations.

Each Handelsbanken branch operates as a local business enabling it to make decisions at a local level and provide a bespoke service.

The focus is always on the need of the individual customer and not on the sale of specific products.

The Bank is deeply committed to embedding good equality and diversity practice into all of our activities. This is so that we are an inclusive, welcoming and inspiring place to work that encourages everyone to apply, regardless of socio-economic background, age, disability, pregnancy and/or parental status, race (including c