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

CompassX is a boutique business and technology consulting firm seeking a Data Architect (Data Modeling Focus) to support a life sciences client. The ideal candidate will thrive at the intersection of data design, business understanding, and analytics enablement.

Requirements

• 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

Benefits

• Generous hourly rate ($80 - $110 an hour)