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
Contract work,