Data Modeler

PURVIEW
Barcelona, Spain
2 days ago
Apply on www.jobleads.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours

Tech stack

Artificial Intelligence Data Analysis Data Architecture Data Integration Data Mapping Data Visualization Data Warehousing Dimensional Modeling Entity Relationship Models Graph Database Interoperability Python (Programming Language)
+8 more
Metadata Meta-Data Management Reference Data Data Mesh SQL Databases Scripting Data Management Physical Data Models

Job description

Domain: Pharma and relevant domain is required

Experience in semantic modelling and working with ontologies will be a great fit.

The consultant will mostly be working towards an organisation in US and need to be able to have some overlap with their time zone (EST). Best of all if the consultant is based in Barcelona and is able to work on-site.

  • Adds value to the organisation by ensuring that systems and applications are conceptually modelled, helping business stakeholders and architects understand the concepts (entities) involved in the requirements.
  • Provides logical and physical data model schemas where required and applicable, helping teams understand the data at a granular level and guiding data engineers on how the models can be physically engineered.
  • Designs and models data products in line with Data Mesh principles, defining domain-oriented, reusable and well-documented data assets that scientists can discover and trust.
  • Applies Entity-Relationship (ER) modelling for source and transactional systems and dimensional modelling for data warehouse and analytical layers.
  • Requires deep knowledge of data analysis and data modelling, along with good knowledge of key data management areas such as Reference Data Management, Master Data Management and Metadata Management.
  • Supports the solution blueprint for data/information-related sections and supports FAIR assessments/workbooks where required.
  • Contributes to semantic modelling and ontology work that enables data integration, interoperability and AI-driven use of data (nice to have)

Skills

  • Conceptual, logical and physical modelling; standards and governance
  • Entity-Relationship (ER) modelling
  • Dimensional modelling (facts, dimensions, star and snowflake schemas)
  • Understanding of Data Mesh architecture (domain ownership, data as a product, self-serve data platform, federated governance)
  • Data product design and modelling
  • Data analysis, profiling, data-quality assessment and root-cause analysis
  • SQL and scripting (Python preferred)
  • Source-to-target mapping, data warehousing and business intelligence
  • Master/reference data, metadata and data cataloguing
  • Data visualisation, stakeholder communication and data literacy
  • Good to have: semantic modelling and working with ontologies (e.g. RDF/OWL, knowledge graphs, controlled vocabularies)

Experience

  • Delivery of data models and analytical artefacts across multiple domains
  • Proven experience in ER modelling and dimensional modelling
  • Experience designing and modelling data products, ideally within a Data Mesh or domain-oriented data architecture
  • Hands-on experience with data warehouse design and delivery
  • Hands-on SQL, scripting, visualisation and data-quality analysis
  • Translating business requirements into implementation-ready data designs and mappings

Requirements

Experience in semantic modelling and working with ontologies will be a great fit., * Conceptual, logical and physical modelling; standards and governance

  • Entity-Relationship (ER) modelling
  • Dimensional modelling (facts, dimensions, star and snowflake schemas)
  • Understanding of Data Mesh architecture (domain ownership, data as a product, self-serve data platform, federated governance)
  • Data product design and modelling
  • Data analysis, profiling, data-quality assessment and root-cause analysis
  • SQL and scripting (Python preferred)
  • Source-to-target mapping, data warehousing and business intelligence
  • Master/reference data, metadata and data cataloguing
  • Data visualisation, stakeholder communication and data literacy
  • Good to have: semantic modelling and working with ontologies (e.g. RDF/OWL, knowledge graphs, controlled vocabularies)

Experience

  • Delivery of data models and analytical artefacts across multiple domains
  • Proven experience in ER modelling and dimensional modelling
  • Experience designing and modelling data products, ideally within a Data Mesh or domain-oriented data architecture
  • Hands-on experience with data warehouse design and delivery
  • Hands-on SQL, scripting, visualisation and data-quality analysis
  • Translating business requirements into implementation-ready data designs and mappings

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.jobleads.com
Prepare application

Good distractions

Loading talks and stories from around this role…