ABOUT CIM GROUP:
CIM is a community-focused real estate and infrastructure owner, operator, lender, and developer. Our team of experts works together to identify and create value in real assets, benefiting the communities in which we invest. Back in 1994, our three founders focused on projects in Southern California neighborhoods. Today, we are a diverse team of 900+ employees with projects across the Americas. Our projects have delivered jobs; created comfortable places to live, work, and relax; and provided necessary and sustainable infrastructure. Our focus on enhancing communities is unwavering, and we strive to make an even greater impact in the years to come. Join us and make an impact today!
POSITION PURPOSE:
The Senior Information Architect will be responsible for designing, developing, and maintaining scalable, efficient, and well-documented data models that support analytical, operational, and reporting needs across CIM's $35B+ portfolio spanning real estate equity, infrastructure, and private credit investments.
This role will establish data modeling standards and techniques from the ground up, developing and managing detailed data models deployed across Databricks Lakehouse as the primary platform, with integration to Snowflake and MongoDB for specific use cases. The Senior Information Architect will play a foundational role in building enterprise data architecture capabilities where mature standards do not yet exist.
This highly collaborative role requires extensive partnership with business stakeholders across Fund Accounting, FP&A, Investor Relations, Sales, and Investments teams to understand data requirements and translate them into robust, high-performing data models. The Senior Information Architect will shape the enterprise data landscape, supporting analytics, governance, and operational data needs across Azure and modern data ecosystems.
RESPONSIBILITIES:
Business Partnership & Requirements Gathering
Partners extensively with business stakeholders across Fund Accounting, FP&A, Global Client Group, and Investments teams to understand data requirements, pain points, and use cases.
Translate complex business requirements into robust data models, asking questions first before proposing solutions to ensure alignment with actual business needs.
Collaborate with data analysts, data scientists, MLOps engineers, and application developers to understand technical requirements and ensure models support downstream use cases.
Build trust and influence across teams by demonstrating business value and explaining technical constraints in accessible terms.
Data Model Design & Development
Design and develop conceptual, logical, and physical data models for various data initiatives, including data warehouses, data lakes, operational data stores, and transactional systems.
Specialize in designing highly optimized dimensional models (star schemas, snowflake schemas) for analytical reporting and business intelligence applications.
Apply various data modeling techniques as appropriate: Dimensional Modeling (Kimball), 3NF (Inmon), Data Vault, and NoSQL modeling patterns.
Databricks Lakehouse Architecture
Design and implement medallion architecture (bronze/silver/gold) patterns within the Databricks Lakehouse, establishing standards where none currently exist.
Optimize data models leveraging Delta Lake features including ACID transactions, time travel, schema evolution, Z-ordering, and liquid clustering.
Design partitioning strategies that balance query performance with file management, avoiding over-partitioning while enabling partition pruning.
Implement Unity Catalog namespace hierarchy (catalog, schema, table) for multi-domain, multi-environment data organization and governance.
Collaborate with MLOps engineers on data models that support ML feature stores and GenAI/RAG applications.
Multi-Platform Data Architecture
Design and maintain relational database schemas for both operational and analytical workloads within Snowflake and other RDBMS, ensuring integration with Databricks Lakehouse.
Design and optimize data structures for NoSQL databases (e.g., MongoDB), considering document structures, indexing, and query patterns for specific application needs.
Develop frameworks for deciding when data belongs in Databricks Lakehouse vs. Snowflake vs. MongoDB based on workload characteristics and use cases.
Performance Optimization
Provide input and recommendations on query optimization, indexing strategies, and data partitioning based on data model design.
Diagnose and resolve performance issues including data skew, small files problems, and inefficient join strategies in Spark/Databricks environments.
Collaborate with database administrators and data engineers on OPTIMIZE, VACUUM, and ANALYZE strategies for Delta tables.
ETL/ELT Collaboration & Data Pipeline Design
Work closely with Data Engineers to ensure data models are efficiently implemented and align with ETL/ELT processes using Auto Loader, Delta Live Tables, or traditional Spark jobs.
Provide guidance on data mapping, transformation rules, schema evolution handling, and data loading strategies.
Design slowly changing dimension (SCD) patterns using Delta Lake MERGE operations and Change Data Feed for downstream propagation.
Data Governance & Standards
Establish and enforce data modeling standards, naming conventions, metadata management, and data governance policies—building these foundations where they do not currently exist.
Implement row-level and column-level security patterns using Unity Catalog for sensitive fund and investor data.
Design and maintain data lineage tracking from source systems through bronze/silver/gold layers to final reports.
Contribute to the development and maintenance of a comprehensive data dictionary and metadata repository.
Operate within compliance framework to ensure ethical data handling, regulatory compliance, and consistency across the enterprise.
Documentation & Knowledge Management
Create and maintain detailed data model documentation, including data dictionaries, entity-relationship diagrams (ERDs), data flow diagrams, and data lineage.
Document Lakehouse design patterns, medallion architecture implementations, and platform-specific best practices for team knowledge sharing.
Contribute to data quality initiatives by identifying potential data quality issues at the modeling stage and collaborating on solutions.
EDUCATION/EXPERIENCE REQUIREMENTS: (including certification, licenses, etc.)
Required:
Bachelor's or Master's degree in Computer Science, Engineering, Information Systems, or a related field.
10+ years of dedicated experience as a Data Modeler or Data Architect.
Extensive experience with various data modeling techniques: Dimensional Modeling (Kimball), 3NF (Inmon), Data Vault, and NoSQL modeling.
Strong expertise in SQL and experience with advanced SQL concepts for data analysis and modeling validation.
Proficiency with data modeling tools (e.g., ER/Studio, Erwin, DataGrip, SQL Developer, or similar).
Databricks Platform Requirements:
Hands-on experience designing and implementing medallion architecture (bronze/silver/gold) in Databricks Lakehouse environments.
Deep understanding of Delta Lake features: ACID transactions, time travel, schema evolution, Z-ordering, liquid clustering, and table maintenance.
Experience with Unity Catalog for data governance, access control, and lineage tracking.
Understanding Spark optimization, partitioning strategies, and performance tuning for large-scale data processing.
Familiarity with Databricks SQL Warehouses, Delta Live Tables, and data pipeline patterns.
Multi-Platform Experience:
Proven experience with Databricks/Delta Lake technologies - Experience modeling data within a data Lakehouse environment (Required).
Solid understanding of Azure Cloud Platform: Azure Data Lake Storage, Azure Databricks.
Experience with data ingestion concepts: Kafka, Azure Event Hubs, CDC, APIs and their impact on data structure and modeling.
Preferred:
Prior experience within financial services, private equity, or alternative investments sectors.
Experience building data architecture standards and practices from scratch in entrepreneurial environments.
Understanding investment data structures: fund hierarchies, investor allocations, NAV calculations, capital calls/distributions.
Experience supporting ML/AI use cases including feature engineering and data models for GenAI/RAG applications.
Desirable Certifications:
Databricks Certified Data Engineer Associate or Professional.
Microsoft Certified: Azure Data Engineer Associate.
Microsoft Certified: Azure Enterprise Data Analyst Associate.
TOGAF Certification (for enterprise architecture alignment).
ABOUT YOU:
The ideal candidate thrives in an entrepreneurial environment where mature processes and standards do not yet exist. You are energized by the opportunity to build data architecture foundations from scratch rather than inheriting established frameworks.
Key Competencies:
Entrepreneurial Mindset: Comfortable building standards, processes, and architecture where none currently exist; thrives with ambiguity and takes initiative without detailed specifications.
Business Partnership Excellence: Exceptional ability to collaborate with non-technical business stakeholders in Fund Accounting, FP&A, Investor Relations, Sales, and Investments teams—listening to understand problems before proposing solutions.
Relationship-Focused Collaboration: Proven track record of building trust and influencing without authority across diverse teams; success depends on partnership, not hierarchy.
Business Value Orientation: Ties technical decisions to business outcomes; prioritizes pragmatic, value-driven solutions over architectural perfection.
Communication Excellence: Translates complex technical concepts into accessible terms for non-technical audiences; adapts communication style to stakeholder needs.
Self-Direction & Initiative: Proactively identifies gaps, proposes solutions, and drives progress without waiting for detailed direction or approval on every decision.
Continuous Learner: Stays current with emerging data modeling techniques, Databricks platform evolution, and database technologies; recommends new approaches where appropriate.
What Success Looks Like:
Business teams across Fund Accounting, IR, and Investments view you as a trusted partner who understands their needs.
Data models you design are adopted, performing well, and enabling business value—not just technically elegant.
Standards and governance frameworks you establish become the foundation for CIM's data architecture practice.
You effectively navigate ambiguity, making progress without needing complete requirements upfront.
WHAT CIM OFFERS:
At CIM, we believe our success stems from our collective efforts, and we are committed to providing well-rounded support and resources for our employees. In addition to a competitive compensation plan, CIM offers a comprehensive benefits program for employees to thrive both inside and outside of work. Eligible employees can enjoy a wide range of benefits, including:
- A variety of Medical, dental, and vision benefit plans
- Health Savings Account with a generous employer contribution
- Company paid life and disability insurance
- 401(k) savings plan, with company match
- Comprehensive paid time off, including: vacation days, 10 designated holidays, sick time, and bereavement leave
- Up to 16 hours of volunteer time off
- Up to 16 weeks of Paid Parental Leave
- Ongoing professional development programs
- Wellness program, including monthly and quarterly prizes
- And more!
Actual base salary considers several factors including but not limited to geography, job-related knowledge, experience, and budget. The start of the salary range is typically associated with the minimum experience required. At CIM, base pay is one part of the total compensation package. For this role, bonus compensation may be a significant part of the total compensation. The anticipated base salary range for the position in Los Angeles, CA is $215,000 - $265,000.
#LI-BL1
HOW WE FEEL ABOUT DIVERSITY AND INCLUSION:
At CIM Group, we believe that the unique perspectives and backgrounds of our employees enhance everything we do. We are committed to fostering an inclusive environment where diversity is not only respected but celebrated. We strive to ensure that our workplace is free from discrimination and harassment, allowing everyone to contribute meaningfully and feel a sense of belonging. As an equal opportunity employer, we strictly prohibit any form of unlawful discrimination and adhere to the laws enforced by the EEOC. Our goal is to provide a safe and supportive environment where all employees can grow and make impactful contributions together.
*Applicants with disabilities may be entitled to reasonable accommodation under the terms of the Americans with Disabilities Act and certain state or local laws. A reasonable accommodation is a change in the way things are normally done which will ensure an equal employment opportunity without imposing undue hardship on CIM Group. Please inform our Talent team if you need any assistance completing any forms or to otherwise participate in the application process.
CIM is committed to maintaining the confidentiality and privacy of your personal and financial information. Please
click here for our Privacy Policy.
CIM does not accept unsolicited resumes from Agencies. Any unsolicited resumes received from Agencies will be considered property of CIM and no fees will be due or paid. If you wish to become an approved Agency with CIM or any of its Affiliates, please contact a member of the CIM Talent Acquisition Team.
