Be Inspired. Be Entrepreneurial. Be Local.

Data Architect – Data Modeling

Data EngineerData EngineerContractRemoteTeam 11-50Since 2009H1B No SponsorCompany Site LinkedIn

Location

United States

Posted

137 days ago

Salary

$80 - $100 / hour

EnglishAmazon RedshiftCloudSQL

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

Job 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