Director, Information Architect
About The Position
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.
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 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).
- 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.
- 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.
Nice To Haves
- 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 (for enterprise architecture alignment).
Responsibilities
- Business Partnership & Requirements Gathering
- Data Model Design & Development
- Databricks Lakehouse Architecture
- Multi-Platform Data Architecture
- Performance Optimization
- ETL/ELT Collaboration & Data Pipeline Design
- Data Governance & Standards
- Documentation & Knowledge Management
Benefits
- 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!
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
