Cimgroup
Director, Information Architect
Los Angeles, CA · Director
Sponsorship not specifiedDetected 146 days ago
Data StructuresSQLNoSQLMongoDBSnowflakeDatabricksAzureCloud PlatformsKafkaMachine LearningSparkData AnalysisData EngineeringRAGMLOpsComplianceAccountingFP&AUnityCommunicationCollaboration
About the role
- Back in 1994, our three founders focused on projects in Southern California neighborhoods.
- Our projects have delivered jobs; created comfortable places to live, work, and relax; and provided necessary and sustainable infrastructure.
- The Senior Information Architect will shape the enterprise data landscape, supporting analytics, governance, and operational data needs across Azure and modern data ecosystems.
Responsibilities
- 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.
- 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.
- 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.
Requirements
- The ideal candidate thrives in an entrepreneurial environment where mature processes and standards do not yet exist.
- 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).
- Experience with Unity Catalog for data governance, access control, and lineage tracking.
- 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).
Nice to have
- Prior experience within financial services, private equity, or alternative investments sectors.
Skills
- Provide guidance on data mapping, transformation rules, schema evolution handling, and data loading strategies.
- 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.
- Contribute to data quality initiatives by identifying potential data quality issues at the modeling stage and collaborating on solutions.
- Azure Data Lake Storage, Azure Databricks.
Compensation
- In addition to a competitive compensation plan, CIM offers a comprehensive benefits program for employees to thrive both inside and outside of work.
Benefits
- A variety of Medical, dental, and vision benefit plans
- Health Savings Account with a generous employer contribution
- Company paid life and disability insurance
- Up to 16 hours of volunteer time off
- Up to 16 weeks of Paid Parental Leave
- Wellness program, including monthly and quarterly prizes
Company info
- 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.
- Today, we are a diverse team of 900+ employees with projects across the Americas.
- 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!
Apply directly at Cimgroup →Create a free account for alerts like thisView Cimgroup immigration profile
This listing is sourced directly from Cimgroup's careers page and normalized into a canonical job model.