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 Now

Apply Now