Data Modeler

Job Title : Data Modeler

Job Type : Contract ( No C2C)

Location : NY / NJ Preferred + Candidates in the Eastern US will also be considered.

Job description : About the Role

We are seeking an experienced Data Modeler with strong expertise in the Private Equity and Investment domain . The ideal candidate will have a proven track record of designing and implementing canonical data models , developing logical and physical models , and working within Databricks Medallion architecture . This role also involves data profiling and building data validations (source-to-target mappings) to ensure data quality, accuracy, and consistency across the enterprise. The Data Modeler will collaborate with cross-functional teams including data engineering, business stakeholders, and product owners.

Key Responsibilities

• Design and build canonical data models to support private equity and investment management business processes.
• Develop logical and physical data models that align with enterprise architecture and cloud strategy.
• Work within Azure Databricks Medallion architecture (Bronze / Silver / Gold layers) to design data flows and ensure consistency.
• Partner with data engineering teams to implement models and optimize for scalability and performance.
• Collaborate with business stakeholders, product owners, and analysts to gather requirements and translate them into data models.
• Ensure data standardization, lineage, and governance across applications and integrations.
• Document data models, business definitions, and metadata to support ongoing governance.
• Provide thought leadership on best practices for canonical modeling, financial data integration, and cloud data architecture

Required Qualifications

Must Have