CompassX Group · 2 months ago
Data Architect - Data Modeling (1099 contract, Remote, must be based in US)
United States
Contract
Remote
Senior Level
$80/hr - $100/hrCompassX Group is a boutique business and technology consulting firm specializing in strategic initiatives for Fortune 500 and high-growth clients. They are seeking a Data Architect with a focus on data modeling to build scalable data models that support enterprise reporting and analytics in an Amazon Redshift and Power BI environment.
Business DevelopmentConsultingInformation TechnologyManagement Consulting
No H1B
Responsibilities
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
Qualification
Required
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
Company
CompassX Group
Business Management, IT Consulting
Founded in 2009
11-50 employees
Funding
Current Stage
Early StageRecent News
2025-01-11
Company data provided by crunchbase