Data Architect - Data Modeling (1099 contract, Remote, must be based in US)

Strong experience in data architecture and data modeling, particularly with star schema and dimensional design Hands-on experience with Amazon Redshift or similar cloud data warehouse platforms Deep understanding of semantic modeling and how it supports Power BI and self-service analytics Strong SQL skills Experience working with Salesforce and/or Veeva data in a life sciences or pharmaceutical environment Solid grasp of data governance, lineage, and metadata management concepts Excellent communication skills

Design and implement data models (star schemas, fact and dimension tables, semantic models) Build and optimize data architecture within Amazon Redshift Develop and maintain data dictionaries, lineage, and documentation Partner with data engineers, analysts, and business stakeholders Define and enforce modeling standards and best practices Work with Salesforce and Veeva data sources Collaborate with global teams