Director, Information Architect

The Director, Information Architect will design, develop, and maintain scalable data models to support analytical, operational, and reporting needs across CIM's $35B+ portfolio. This role will establish data modeling standards and techniques from the ground up, developing and managing detailed data models deployed across Databricks Lakehouse.

Requirements

• 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

Benefits

• 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
• Up to 16 hours of volunteer time off
• Up to 16 weeks of Paid Parental Leave
• Ongoing professional development programs
• Wellness program