

Data Modeler – Erwin (Pharma Commercial)
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Modeler – Erwin (Pharma Commercial) with a 12+ month contract, offering a competitive pay rate. Requires expertise in data modeling, SQL, and familiarity with Oracle, Postgres, and big data platforms, plus experience in pharmaceutical sales operations.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
-
🗓️ - Date discovered
June 26, 2025
🕒 - Project duration
Unknown
-
🏝️ - Location type
Unknown
-
📄 - Contract type
Unknown
-
🔒 - Security clearance
Unknown
-
📍 - Location detailed
United States
-
🧠 - Skills detailed
#Data Warehouse #Scripting #SQL (Structured Query Language) #Database Design #MDM (Master Data Management) #Data Modeling #Metadata #Snowflake #Data Lake #Oracle #BI (Business Intelligence) #Data Mart #Physical Data Model #Data Management #Big Data #Hadoop #Data Analysis #CRM (Customer Relationship Management) #ERWin
Role description
Heading 1
Heading 2
Heading 3
Heading 4
Heading 5
Heading 6
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Block quote
Ordered list
- Item 1
- Item 2
- Item 3
Unordered list
- Item A
- Item B
- Item C
Bold text
Emphasis
Superscript
Subscript
Data Modeler – Erwin (Pharma Commercial)
• 12+ years of experience in Conceptual, Logical and Physical Data Modeling experience.
• Erwin Data Modeling Software hands-on experience
• Create database objects.
• Create, review and tune SQL scripting.
• Good knowledge of metadata management, data modeling, and related tools (Erwin, ER Studio, Oracle Designer or PowerDesigner)
• Data analysis and Database design experience.
• Knowledge understanding of different database platforms, such as, Oracle, Postgres, Hadoop, Snowflake, Netezza, DB2.
• Proven experience in a data warehousing & Business intelligence
• Data Warehouse - Experience in data warehouse design and development, Experience with data warehouse, datalake, and enterprise big data platforms in multi-data-center contexts required.
• Knowledge and in depth exposure to modeling strategies, such as relational (logical, physical), star, snowflake, unstructured, to support OLTP, Warehousing and Data Marts, Data Lakes, MDM).
• Excellent organization, analytical, and communication skills.
Plus to have worked in Pharma Commercial on the following data sets
• Experience of Pharma Sales Operations, Marketing, and Market Access business functions.
• Strong knowledge of pharmaceutical data including an understanding of field sales roles including sales, managed markets, account-based teams, etc.
• Understanding of Pharmaceutical Commercial and Sales Operations group, including insights around Sales (Demand vs Forecast, Normalized Units), Channel Performance, Inventory (Days on Hand, Channel vs Warehouse), Calls (Reach, Frequency, Adherence)
• Understanding of processes & data related to Sales, Sales Operations, Marketing, Market Access etc. (e.g. Direct Sales, Self-Dispensing Pharmacy, Competitor Sales, Prescription, Shipment, Distribution Channel, CRM, Incentive Program, Physician Affiliations, Pricing decisions, Payer contracts, Speaker Program, etc.).