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