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 are seeking a Data Architect (Data Modeling Focus) to support one of our life sciences clients. This consultant will play a pivotal role in designing scalable, well-structured data models that underpin enterprise reporting and analytics. This is an ideal role for someone who thrives at the intersection of data modeling, business domain 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 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
What we're looking for
- 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
- 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
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
CompassX Group Irvine, California, USA Office
300 Spectrum Center Drive, Suite 400, Irvine, CA, United States, 92618
Similar Jobs
Cloud • HR Tech • Information Technology • Software
The Corporate Sales Executive will manage enterprise accounts, drive sales cycles, engage C-level executives, and execute account plans for revenue growth.
Top Skills:
Sales Management Software
Artificial Intelligence • Information Technology • Machine Learning • Natural Language Processing • Productivity • Software • Generative AI
Lead and manage Partner Managers to drive partner-sourced revenue, develop sales strategies, and foster relationships with distributors and resellers while ensuring alignment with company goals.
Top Skills:
Crm SystemsPartner Management ToolsSalesforce
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Design software for managing production databases, collaborate with stakeholders, enforce software engineering best practices, and ensure reliable, scalable solutions.
Top Skills:
CentosGoJenkinsKubernetesMariadbMySQLOraclePostgresPuppetPythonRedhatRubyTeamcity
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
