In the high-stakes world of institutional real estate, data is often the most underutilized asset. For Cardinal Group Companies, a national leader in the United States managing over 100,000 student housing beds and 12,000 multifamily units, the challenge wasn't just managing properties—it was managing the explosion of data that came with rapid, organic growth.

As Cardinal scaled, they faced a classic enterprise dilemma: critical operational insights were trapped in third-party systems and scattered across disconnected cloud environments. To maintain their reputation for "challenging the status quo," Cardinal needed more than just a vendor; they needed a strategic consulting partner. Cardinal found this strategic alignment in Searce, a premier Google Cloud partner, helping enterprises modernize data platforms and infrastructure intelligently with AI at the core.

Together, they embarked on a multi-year digital maturity journey, moving from legacy "keep-the-lights-on" technology to a cutting-edge, AI-native enterprise.

Hear from Rachel Ibarra, VP of Data and Innovation, Cardinal Group of Companies about the partnership with Searce. Click here.

Phase 1: Data Unification & The Google Cloud Foundation

The journey began in late 2023 with a focus on Foundation. Searce identified that Cardinal's growth had created a "fragmentation problem" that significantly limited enterprise-wide reporting while also creating massive overhead.

• The Solution: Searce deployed robust Change Data Capture (CDC) pipelines and orchestrated complex workflows using Cloud Composer and DataProc.
• The Result: Raw property performance data was successfully centralized into Google Cloud's data platform

Phase 2: Operational Stability through Managed Services

By early 2025, the sheer volume of data began to strain Cardinal's internal bandwidth. To prevent infrastructure management from distracting the team from innovation, Cardinal shifted to a Managed Services model with Searce.

• The Shift: Searce took over 24/7 monitoring, security, and capacity planning.
• The Impact: The Data team was transformed from a cost center focused on cloud and infrastructure maintenance into a strategic partner capable of driving the next leap in technology.

Phase 3: The Data Renaissance with BigQuery

Mid-2025 marked a "Defining Move" for the organization. While data was centralized, legacy SQL databases created performance bottlenecks that limited the scale of analytical insights and hindered the ability to move toward a scalable and sustainable AI architecture.

• The Modernization: For Cardinal's data warehouse migration to BigQuery, Searce took on a massive undertaking. This included translating tens of thousands of lines of code, re-keying all surrogate keys to UUIDs for BigQuery compatibility, and conducting rigorous hash-based validation procedures on the results. Furthermore, they established Dataflow and Datastream pipelines to facilitate the movement of data between CloudSQL and BigQuery. Ultimately, Searce executed the complete production migration from CloudSQL to BigQuery on Cardinal's behalf.
• The Impact: This framework decoupled the system from upstream volatility, ensuring high availability and "time-travel" audit capabilities. By federating queries through BigLake, Cardinal secured high-performance BigQuery compute power without redundant storage costs, slashing end-to-end refresh times to under 90 minutes for a 40TB data lake.

Phase 4: Scaling the AI Frontier

By late 2025, Cardinal transitioned into a true AI-Enabled Organization. The goal was to make data accessible and actionable across the organization while also establishing a foundation for the next phase of agentic AI.

• The Innovation: Cardinal embarked on their Agentic AI initiative by adopting Gemini Enterprise.
• Generative Outcomes: Employees now use natural language to interact with Cardinal's vast, operationally critical enterprise knowledge. They are in the process of building agents to drive action and improve outcomes for clients and residents.

The Business Impact: From Reactive to Generative

Cardinal Group successfully transitioned from reactive data management to an AI-enabled enterprise where technology is invisible and insights are instant, achieving the following milestones:

• From Reactive to Generative: Methodically traversed the maturity curve—moving from fragmented silos to a stable managed infrastructure, predictive analytics, and finally, AI-empowered interactions via Gemini.
• Optimized SQL procedures execution by 97%: Migrating to BigQuery's serverless architecture slashed analytical query times to a mere 1/36th of their original duration, empowering the business to make instant, data-driven strategic pivots.
• Massive Scale, Minimal Latency: Built a scalable environment handling a 40TB data lake with a full end-to-end refresh (source to BI tool) in under 90 minutes.
• Operational Reallocation: By offloading 24/7 infrastructure management to Searce, Cardinal shifted its human capital from "maintaining" to "innovating," focusing entirely on high-value AI development and data insights.