Data Modeler

Solvex Solutions; Maryland; Hybrid; USD 90,000 - 130,000; Full time

Job summary

Solvex Solutions in Maryland/DC Metro Area is seeking an experienced Data Modeler to help develop a common enterprise data model and reusable data products for commercial pharma data.

The role demands strong SQL, Databricks, Delta Lake and medallion architecture knowledge, plus experience with pharma datasets (IQVIA, Symphony Health) and CRM data (Veeva); contract includes hybrid work and cross-functional collaboration.

Qualifications

• Strong SQL and hands-on data modelling experience.
• Experience with Databricks, Delta Lake and medallion architecture.
• Commercial life sciences/pharma data knowledge is essential.
• Ability to map business requirements to entity relationships and data grain.
• Experience with patient/provider data linkage or similar.

Responsibilities

• Design conceptual, logical and physical data models across multiple domains.
• Define modelling standards across Bronze, Silver and Gold Databricks layers.
• Establish harmonised Silver entities and Gold data products.
• Translate business requirements into data structures and relationships.
• Develop source-to-target mappings to support multiple data products.
• Collaborate with SMEs, architects and engineers on data governance and privacy.
• Support analytics use cases such as Patient Journey and HCP 360.

Skills

SQL

Databricks

Delta Lake

Dimensional Data Modelling

Pharma Data Knowledge

Data Modelling Standards

Data Product Knowledge

Tools

Veeva

IQVIA

Symphony Health

Job description

Location: Maryland / Washington DC Metro Area

Job Nature: Contract role with the possibility of extension and follows a hybrid work arrangement

Job Summary:

We are looking for an experienced Data Modeler with strong commercial pharmaceutical / life sciences data knowledge to help develop a common enterprise data model and reusable data products.

Key Responsibilities:

• Design conceptual, logical and physical data models across Patient, HCP, HCO, Product, Payer and Commercial Activity domains.
• Define modelling standards across Bronze, Silver and Gold Databricks medallion layers.
• Establish harmonised entities within the Silver layer and consumption-ready data products within Gold.
• Translate business requirements into entity relationships, data grain, shared dimensions, business definitions and historical tracking approaches.
• Develop source-to-target mappings and reusable data structures supporting multiple commercial data products.
• Partner with business SMEs, architects and engineers across identity resolution, data quality, lineage, governance and patient privacy.
• Support scalable commercial analytics use cases including Patient Journey and HCP 360.

Required Experience:

• Strong SQL and hands-on experience with enterprise, dimensional and canonical data modelling.
• Strong experience with Databricks, Delta Lake and medallion architecture.
• Commercial life sciences / pharmaceutical data experience is essential.
• Understanding of source structures, granularity, coverage limitations, refresh cycles and patient / provider linkage.
• Experience translating commercial pharma use cases into scalable data models.
• Previous experience supporting Patient Journey, Patient 360, HCP 360 or similar commercial data products would be highly desirable.

Strong working knowledge of datasets including:

• Prescription and claims data such as IQVIA and Symphony Health
• CRM platforms such as Veeva
• HCP / HCO reference and master data
• Specialty pharmacy and patient hub feeds