Director, Information Architect

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

Partner with business stakeholders across Fund Accounting, FP&A, Global Client Group, and Investments to understand data requirements; Translate complex business requirements into robust data models; Design conceptual, logical, and physical data models for data warehouses, data lakes, operational data stores, and transactional systems; Design highly optimized dimensional models (star schemas, snowflake schemas) for analytical reporting; Implement medallion architecture (bronze/silver/gold) patterns in Databricks Lakehouse; Optimize data models using Delta Lake features such as ACID transactions, time travel, schema evolution, Z-ordering, and liquid clustering; Implement Unity Catalog namespace hierarchy for data organization and governance; Design relational database schemas in Snowflake and optimize NoSQL structures in MongoDB; Provide input on query optimization, indexing strategies, and data partitioning; Work with Data Engineers on ETL/ELT processes and data loading strategies; Establish and enforce data modeling standards, naming conventions, metadata management, and data governance policies; Create and maintain documentation including data dictionaries, ERDs, data flow diagrams, and data lineage

Requirements

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 Dimensional Modeling (Kimball), 3NF (Inmon), Data Vault, and NoSQL modeling; Strong expertise in SQL and advanced SQL concepts; Proficiency with data modeling tools (ER/Studio, Erwin, DataGrip, SQL Developer, or similar); 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 of Spark optimization, partitioning strategies, and performance tuning for large-scale data processing; Familiarity with Databricks SQL Warehouses, Delta Live Tables, and data pipeline patterns; Proven experience with Databricks/Delta Lake technologies and data modeling within a data Lakehouse environment; 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

Nice to have

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; Databricks Certified Data Engineer Associate or Professional; Microsoft Certified: Azure Data Engineer Associate; Microsoft Certified: Azure Enterprise Data Analyst Associate; TOGAF Certification

Benefits

Medical, dental, and vision benefit plans; Health Savings Account with 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; Bonus compensation