Warehouse Data Modeller

6 months ago

London, United Kingdom Handelsbanken Full time

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 long-term 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 hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, data platform technologies and ETL & data ingestion protocols)
- Hands-on 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 in-depth 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 multi-data-centre 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

  • Data Modeler

    6 days ago

    London, United Kingdom Qualient Technology Solutions UK Limited Full time

    Job Description;- Responsibilities • Understand our existing data and architecture deeply (granular level) • Design Business Object, Canonical and Semantic Models at the enterprise and/or individual line of business and/or product level • Be responsible for the development of the conceptual, logical, and physical data models, the implementation of...

  • Data Modeler

    6 days ago

    London,, UK, United Kingdom L&G Recruitment Full time

    Skills:10+ years of experience in Data Modeling (relational, data warehouse, semi-structured) and advanced querying.10+ years of SQL programming experience.Expertise with SAP PowerDesigner or similar tools (e.g., Erwin, ER Studio).Familiarity with metadata management and tools.Experience with Microsoft Azure Synapse is a plus.Knowledge of ACORD Insurance...

  • Data Modeler

    3 days ago

    London, United Kingdom L&G Recruitment Full time

    Skills:10+ years of experience in Data Modeling (relational, data warehouse, semi-structured) and advanced querying.10+ years of SQL programming experience.Expertise with SAP PowerDesigner or similar tools (e.g., Erwin, ER Studio).Familiarity with metadata management and tools.Experience with Microsoft Azure Synapse is a plus.Knowledge of ACORD Insurance...

  • Data Modeler

    6 days ago

    London, United Kingdom L&G Recruitment Full time

    Skills:10+ years of experience in Data Modeling (relational, data warehouse, semi-structured) and advanced querying.10+ years of SQL programming experience.Expertise with SAP PowerDesigner or similar tools (e.g., Erwin, ER Studio).Familiarity with metadata management and tools.Experience with Microsoft Azure Synapse is a plus.Knowledge of ACORD Insurance...

  • Data Modeler

    1 week ago

    London, United Kingdom CV-Library Full time

    Job Description;- Responsibilities • Understand our existing data and architecture deeply (granular level) • Design Business Object, Canonical and Semantic Models at the enterprise and/or individual line of business and/or product level • Be responsible for the development of the conceptual, logical, and physical data models, the...

  • Data Modeler

    1 week ago

    London, United Kingdom Hexaware Technologies UK Ltd Full time

    Job Description:Data ModelerResponsibilitiesUnderstand our existing data and architecture deeply (granular level)Design Business Object, Canonical and Semantic Models at the enterprise and/or individual line of business and/or product levelBe responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS,...

  • Data Modeler

    6 days ago

    London, United Kingdom Qualient Technology Solutions UK Limited Full time

    We are Looking for Data Modeler Base din London, UK which is Hybrid mode Job Description: Responsibilities Understand our existing data and architecture deeply (granular level) Design Business Object, Canonical and Semantic Models at the enterprise and/or individual line of business and/or product level Be responsible for the development of the...

  • Data Modeler

    4 days ago

    London, United Kingdom Qualient Technology Solutions UK Limited Full time

    We are Looking for Data Modeler Base din London, UK which is Hybrid mode Job Description: Responsibilities Understand our existing data and architecture deeply (granular level) Design Business Object, Canonical and Semantic Models at the enterprise and/or individual line of business and/or product level Be responsible for the development of the...

  • Data Modeller

    2 months ago

    London, United Kingdom Data Careers Ltd Full time €85,000 - €95,000

    Data Architect (Central Government & Defence Sector) Location: England (Hybrid working, with some onsite requirement at offices in Southern UK) Security Clearance: SC clearance eligibility or existing SC clearance required. We are recruiting for a Data Architect to join a specialist consultancy that delivers high-impact solutions to central government and...

  • Actuarial Data Modeler

    1 month ago

    London, Greater London, United Kingdom Fresha Full time

    About FreshaFresha is a leading marketplace platform for beauty and wellness services.Our PlatformFresha is trusted by millions of consumers and businesses worldwide. We process over 1 billion appointments to date and have a presence in multiple global offices.The RoleWe are seeking a skilled Actuarial Data Modeler to join our team. In this role, you will be...

  • Data Modeller

    1 week ago

    City of London, United Kingdom CBSbutler Holdings Limited trading as CBSbutler Full time

    Data Modeller +6 months + +Fully remote working +£375 - £475 a day Skills Experience with Data Modelling for Data Warehouses Logical data modelling techniques - 3NF Should have exposure to Data Vault Modelling techniques. Data Transformation and ETL - Experience of Qlik Compose, AWS Glue ideal, but if not available possibly Datastage or SSIS or...

  • Data Modeller

    1 week ago

    City of London, United Kingdom CV-Library Full time

    Data Modeller +6 months + +Fully remote working +£375 - £475 a day Skills Experience with Data Modelling for Data Warehouses Logical data modelling techniques - 3NF Should have exposure to Data Vault Modelling techniques. Data Transformation and ETL - Experience of Qlik Compose, AWS Glue ideal, but if not available possibly Datastage or...

  • Data Modeler

    1 week ago

    London, South East, UK, United Kingdom Hexaware Technologies UK Ltd Full time

    Job Description:Data ModelerResponsibilitiesUnderstand our existing data and architecture deeply (granular level)Design Business Object, Canonical and Semantic Models at the enterprise and/or individual line of business and/or product levelBe responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS,...

  • Data Modeler

    5 days ago

    London Area, United Kingdom Qualient Technology Solutions UK Limited Full time

    We are Looking for Data Modeler Base din London, UK which is Hybrid modeJob Description: ResponsibilitiesUnderstand our existing data and architecture deeply (granular level)Design Business Object, Canonical and Semantic Models at the enterprise and/or individual line of business and/or product levelBe responsible for the development of the conceptual,...

  • Data Modeler

    4 days ago

    London Area, United Kingdom Qualient Technology Solutions UK Limited Full time

    We are Looking for Data Modeler Base din London, UK which is Hybrid mode Job Description: Responsibilities Understand our existing data and architecture deeply (granular level) Design Business Object, Canonical and Semantic Models at the enterprise and/or individual line of business and/or product level Be responsible for the development of the...

  • Data Modeler

    6 days ago

    London Area, United Kingdom Qualient Technology Solutions UK Limited Full time

    We are Looking for Data Modeler Base din London, UK which is Hybrid modeJob Description: ResponsibilitiesUnderstand our existing data and architecture deeply (granular level)Design Business Object, Canonical and Semantic Models at the enterprise and/or individual line of business and/or product levelBe responsible for the development of the conceptual,...

  • Enterprise Data Modeller

    3 weeks ago

    London, Greater London, United Kingdom Eames Consulting Full time

    **Role Description:** We are looking for an Enterprise Data Modeller to join our client's team on a 12-month contract. The successful candidate will be responsible for developing out the data model for the data warehouse and working closely with a Data Architect and a Data Engineer.This is a great opportunity to work on a cutting-edge project, developing a...

  • Senior Data Warehouse Engineer

    3 weeks ago

    London, Greater London, United Kingdom Data Science Festival Full time

    Data Science Festival is a leading entertainment organisation with a global presence, renowned for its innovative approach to data-driven decision making.Key ResponsibilitiesAs a Senior Data Warehouse Engineer, you will play a pivotal role in designing and implementing the company's data warehouse strategy.This involves working closely with the Data...

  • Data Infrastructure Specialist

    3 weeks ago

    London, Greater London, United Kingdom Data Science Festival Full time

    Data Warehouse Systems ExpertData Science Festival is seeking a highly skilled Data Warehouse Systems Expert to join our team. As a leading organisation in the entertainment industry, we're committed to harnessing the power of data to drive innovation and growth.In this role, you'll be responsible for designing and implementing data warehouse systems that...

  • Enterprise Data Architect

    3 weeks ago

    London, Greater London, United Kingdom Data Science Festival Full time

    Data Science Festival: Enterprise Data ArchitectWe are working with one of the largest entertainment organisations growing rapidly within their global operations. With innovation, creativity, and data at the heart of the company, we are looking for an Enterprise Data Architect to join the team.As an Enterprise Data Architect, you will be responsible for...