CompassX Group · 3 weeks ago
Data Architect - Data Modeling (1099 contract, Remote, must be based in US)
United States
Full-time, Contract
Remote
Senior Level
$80/hr - $110/hrCompassX Group is a boutique business and technology consulting firm that helps Fortune 500 and high-growth clients with strategic initiatives. They are seeking a Data Architect focused on data modeling to design scalable data models for enterprise reporting and analytics, collaborating with various stakeholders to ensure alignment and interoperability.
Business DevelopmentConsultingInformation TechnologyManagement Consulting
No H1B
Responsibilities
Design and implement enterprise data models, including star schemas, fact and dimension tables, and semantic models to support analytics in Power BI
Build and optimize data architecture within Amazon Redshift, ensuring scalability, performance, and data consistency
Develop source-to-target (S2T) mappings, data dictionaries, and lineage documentation for key business domains
Translate business and functional requirements into robust data models that support end-to-end reporting
Collaborate with data engineers, analysts, and business stakeholders across global teams to ensure model alignment and interoperability
Work with a variety of key life sciences data sources to model commercial, sales, marketing, and CRM datasets
Define, maintain, and enforce modeling standards, best practices, and architectural patterns
Qualification
Required
Strong experience in data architecture and data modeling, particularly dimensional and semantic modeling
Hands-on experience with Amazon Redshift or a similar cloud data warehouse platform
Proficiency in building semantic models in Power BI
Strong SQL skills for model development, validation, optimization, and data quality checks
Solid understanding of data governance, metadata, and lineage
Excellent communication and collaboration skills with both technical and non-technical partners
Experience with ERWin or similar data modeling tools
Preferred
Familiarity with SAP S/4HANA, Oracle EPM, and Coupa data structures
Exposure to SAP Datasphere, Informatica, or other ETL/ELT platforms
Experience working within global or matrixed enterprise environments
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