Data Architect – Data Modeling

Job Description:

• Design and implement

data models

(star schemas, fact and dimension tables, and semantic models) to support analytics and reporting in

Power BI

• Build and optimize

data architecture

within

Amazon Redshift

, ensuring scalability, performance, and data consistency

• Develop and maintain

data dictionaries, lineage, and documentation

for key business domains

• Partner with data engineers, analysts, and business stakeholders to translate requirements into effective data models
• Define and enforce

modeling standards and best practices

, ensuring consistency across projects

• Work with

Salesforce

and

Veeva

data sources to model key life sciences datasets (e.g., sales, marketing, CRM, and field activities)

• Collaborate with global teams to ensure model alignment and data interoperability across business units Requirements:
• 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 for model development, validation, and optimization

• 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 — able to collaborate effectively with technical and business stakeholders Benefits: Apply tot his job