Data Modeler

Job Description

Position: Data Modeler, Hyderabad

Department: Information Technology | Role: Full-time | Experience: 8 to 12 Years | Number of Positions: 1 | Location: Hyderabad

Skillset:

Data Modeler, Private Equity, Canonical models, Azure Data Bricks, Medallion Architecture, SQL, Dimensional Modeling, ETL/ELT Process, Data Governance, Metadata, Data Cataloging, Cloud based Architecture, Financial Regulatory Reporting, Excellent English Communication Skills

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 English communication and stakeholder engagement skills to work across business and technical teams

Must Have:

Experience in 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

Additional Information:

This is a 5-days/week, work from office role (No Hybrid/ Remote option available)

Domain expertise in Private Equity, Investment Management, or Asset Management (fund structures, portfolio data, investor reporting, valuations)

Interview process:

2 to 3 virtual rounds and 1 compensation discussion

Required Qualification:

Bachelor of Engineering / Bachelor of Technology (B.E./B.Tech.) - IT/CS/E&CE/ MCA

With a fast-growing analytics, business intelligence, and automation MNC