Cimgroup

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!

This listing is sourced directly from Cimgroup's careers page and normalized into a canonical job model.