Looking for a Data Architect to design and implement cloud-based data models and pipelines for self-service analytics and Customer 360 experiences, using technologies like Snowflake, dbt, and Python.
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 to support one of our enterprise clients in designing and building a modern, cloud-based data architecture that powers self-service analytics and Customer 360 experiences.
This role is ideal for someone who can combine architectural vision with hands-on expertise in Snowflake, dbt, and Python, and help shape the foundation for scalable data products across the organization.
What you'll do
- Design and implement data models (star, snowflake, and semantic) to support analytics and Customer 360 use cases
- Architect end-to-end pipelines and transformation frameworks leveraging dbt and Python
- Define and maintain standards for self-service analytics, enabling business users through governed and reusable data assets
- Partner with engineering, analytics, and business teams to align on data definitions, governance, and architecture best practices
- Build and optimize data marts and semantic layers for downstream BI tools such as Power BI or Looker
- Guide the design and delivery of a Customer 360 / Member 360 platform, integrating multiple data sources to deliver unified insights
- Support cloud modernization efforts across Snowflake and BigQuery environments
- Apply DevOps and CI/CD practices using Git and modern orchestration frameworks (Airflow, Dagster, etc.)
What we're looking for
- 10+ years of experience in data architecture or advanced data engineering
- Strong hands-on experience with Snowflake (preferred) and/or BigQuery
- Expertise in dbt for modular data modeling, testing, and transformation
- Solid proficiency in Python, including automation and data processing libraries (Pandas, SQLAlchemy, etc.)
- Proven track record designing self-service analytics platforms or Customer 360 data products
- Understanding of data governance, lineage, and metadata management
- Background in Financial Services or Life Sciences is highly preferred
- Familiarity with orchestration and CI/CD tooling (e.g., Airflow, Dagster, GitHub Actions)
- Self-driven, detail-oriented, and able to standardize and own architectural solutions end-to-end
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
Airflow
BigQuery
Dagster
Dbt
Git
Looker
Power BI
Python
Snowflake
CompassX Group Irvine, California, USA Office
300 Spectrum Center Drive, Suite 400, Irvine, CA, United States, 92618
Similar Jobs
AdTech • Digital Media • Marketing Tech
The Principal Data Scientist will develop frameworks for measurement, attribution, and performance optimization, analyze large datasets, and work cross-functionally to enhance advertiser performance across Universal Ads.
Top Skills:
LookerPlotlyPythonRSQLTableau
AdTech • Digital Media • Marketing Tech
The Cloud Engineer at Comcast Advertising is responsible for designing and implementing innovative solutions, leading engineering functions, collaborating with cross-functional teams, and ensuring timely project delivery and operational support.
Top Skills:
Application DevelopmentCi/CdCloud EngineeringElasticsearchGitopsSoftware Development
AdTech • Digital Media • Marketing Tech
Design and develop APIs for customer-facing applications, analyze requirements, build data storage models, and maintain operational stability.
Top Skills:
Amazon Ec2AWSDockerGitNextjsPythonReact
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
