Required skills
- Data Modeling
- Data Vault 2.0
- Snowflake
- Pharma
- Life Sciences
- Conceptual Data Modeling
- Logical Data Modeling
- Physical Data Modeling
- ETL
- Data Governance
- Data Lineage
- HIPAA
Languages: German
Job description
Experienced Data Modeler with Data Vault 2.0 and Snowflake expertise needed for a remote EU-based project in the Pharma/Life Sciences sector. The role involves designing and maintaining data models, integrating data, and collaborating with various teams.
Project overview
For a pharmaceutical project of a leading consulting firm, we are looking for an experienced Data Modeler with proven experience in the pharmaceutical or life sciences sector. The role is possible remotely within the EU.
Responsibilities
- Conception and maintenance of conceptual, logical, and physical data models according to Data Vault 2.0 (Hubs, Links, Satellites, PIT and Bridge tables).
- Modeling of commercial life sciences domains, including HCP and HCO, product, territory and alignment, sales and call activities, claims and Rx, specialty pharmacy, patient services, as well as payer, market access, and promotional or marketing data.
- Integration of third-party data.
- Building the Information Mart layer in star and snowflake schemas as a basis for dashboards, field reporting, and advanced analytics.
- Definition and enforcement of modeling standards, naming conventions, and metadata practices.
- Close collaboration with Data Engineers on ETL pipelines, performance tuning, and Snowflake design, including clustering, micro-partitions, warehouse sizing, and cost optimization.
- Coordination with the business departments Commercial Ops, Sales Analytics, Brand, and Market Access, translation of requirements into data models, and establishment of a common business glossary.
- Support for Data Governance, Lineage, Data Quality, and Master Data Management, including HCP/HCO and product mastering.
- Ensuring compliance requirements, especially HIPAA, handling of PHI and PII, as well as consent and data protection rules.
- Documentation of the models and mentoring of team members on best practices in data modeling.
Requirements
Application
Please send your profile with hourly rate and earliest possible availability date. Every application will be read by a consultant and you will receive feedback in any case.
- Proven project experience in Pharma or Life Sciences is mandatory.
- Sound experience in data modeling according to Data Vault 2.0.
- Very good Snowflake knowledge.
- Experience with a data modeling tool, preferably SQLDBM or comparable.
- Availability 40 hours per week.
- Residence within the EU.
Project details
- Start: ab sofort
- Remote: hybrid
- Location: Düsseldorf, Deutschland, DE
- Languages: German
Indexed by 9am's meta-search. You are a job provider? Claim or manage this listing
Found on FreelancerMap DE