Data Modeller
Open Link Systems Ltd
Contact person: Veeranjaneyulu Katta
Barcelona, Spain
Medicine and PharmaceuticalsData AnalysisBuilding Information ModelingData ArchitectureData IntegrationData ModelingData WarehousingDatabase ModelsDigital Modeling and FabricationDimensional ModelingMolecular ModellingSAP PowerDesignerSystems ModelingToad Data ModelerModel-Driven ArchitectureIndustrial ModellingUser ModellingPhysical Data Models
Description
Role: Data Modeller
Location: Barcelona, Spain
1 or 2 days from office is preferred
Domain: Pharma and relevant domain is required
Role Type: Contract
Manager comment: experience in semantic modelling and working with ontologies will be a great fit.
Position details:
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.
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
Role description
· 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)