Job Description

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

• 5+ years of experience as a Data Modeler or in a similar data architecture role.
• Strong domain expertise in Private Equity, Investment Management, or Asset Management (fund structures, portfolio data, investor reporting, valuations).
• Proven experience creating canonical models and developing logical & physical data models .
• Hands-on experience with Azure Databricks and Medallion architecture (Bronze/Silver/Gold layers) .
• Proficiency in SQL, relational databases, dimensional modeling, and data integration patterns .
• Strong understanding of ETL/ELT pipelines and collaboration with data engineering teams.
• Excellent communication and stakeholder engagement skills to work across business and technical teams .

Must Have

• Experience with financial data standards and regulatory reporting frameworks.
• Private Equity domain knowledge and experience
• Familiarity with data governance, metadata, data cataloging
• Background in cloud-based data architecture and modern data platforms .

Job Tags

Similar Jobs