The Data Architect will design and implement scalable data models for analytics in Power BI, focusing on Amazon Redshift, while collaborating with data teams and ensuring data governance.
CompassX is a boutique business and technology consulting firm. We help Fortune 500 and high-growth clients deliver their most strategic initiatives, from enterprise transformations to digital and data-driven projects. With over 15 years of proven results, we’ve expanded across industries including financial services, pharmaceuticals, aerospace, consumer products, and quick service restaurants.
We are honored to be recognized as a three-time winner of Consulting Magazine’s Best Boutique Firms to Work For, and previously recognized as a “Best Place to Work” in Southern California and one of INC.’s 5000 fastest-growing private companies in the U.S.
We’re looking for a Data Architect (Data Modeling Focus) to support one of our life sciences clients. This role is ideal for someone who thrives at the intersection of data design, business understanding, and analytics enablement.
You’ll focus on building scalable, well-structured data models that serve as the foundation for enterprise reporting and analytics in an Amazon Redshift and Power BI environment.
What you'll do
- 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
What we're looking for
- 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
Our consultants say CompassX is a place where they can truly find their own path. As part of a smaller firm, they see the impact of their work, have an identity, and know their voice matters. They value the freedom to take the reins of their careers, shape their client work, and maintain a direct line to leadership.
With CompassX’s focus on serving local Southern California clients, consultants not only build lasting relationships but also see the results of their work in the communities where they live.
At CompassX, you won’t just follow a path - you’ll create one.
Top Skills
Amazon Redshift
Power BI
Salesforce
SQL
Veeva
Similar Jobs
Computer Vision • Healthtech • Information Technology • Logistics • Machine Learning • Software • Manufacturing
As a Customer Experience Lab Technician, you will provide real-time support to clinicians, assist in treatment planning, and facilitate communication between doctors and lab teams, leveraging your expertise in dental design workflows.
Top Skills:
3Shape Cad/Cam
Computer Vision • Healthtech • Information Technology • Logistics • Machine Learning • Software • Manufacturing
The Change Control Coordinator will oversee the change control process, ensuring compliance with regulatory standards while collaborating with various teams on implementation.
Top Skills:
Dot ComplianceG-SuitesMicrosoft Office Suite
Big Data • Food • Hardware • Machine Learning • Retail • Automation • Manufacturing
Lead a team focusing on commercial growth for Toblerone in North America. Develop strategies for customer expansion and manage pricing, relationships, and market insights to drive sales.
Top Skills:
Market AnalysisPricing StrategyPromotion PlanningRevenue Management
What you need to know about the Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
