Descripción de la oferta
Domain: Pharma and relevant domain is requiredExperience 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)SkillsConceptual, logical and physical modelling; standards and governanceEntity-Relationship (ER) modellingDimensional 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 modellingData analysis, profiling, data-quality assessment and root-cause analysisSQL and scripting (Python preferred)Source-to-target mapping, data warehousing and business intelligenceMaster/reference data, metadata and data cataloguingData visualisation, stakeholder communication and data literacyGood to have: semantic modelling and working with ontologies (e.G. RDF/OWL, knowledge graphs, controlled vocabularies)ExperienceDelivery of data models and analytical artefacts across multiple domainsProven experience in ER modelling and dimensional modellingExperience designing and modelling data products, ideally within a Data Mesh or domain-oriented data architectureHands-on experience with data warehouse design and deliveryHands-on SQL, scripting, visualisation and data-quality analysisTranslating business requirements into implementation-ready data designs and mappings#J-18808-Ljbffr