Data Modeler
Company not disclosed
- Pay
- ₹25–40 lakh a year
- Location
- Bangalore/ Pune/Hyderabad · Hybrid
- Job type
- Full-time
- data modeling (conceptual, logical, physical)
- Qlik
- Gather
- Microsoft Fabric Lakehouse
- Medallion architecture
- SQL
- schema design
- metadata management
About the role
Preserve business logic and reporting structures while modernizing legacy data models. Enable migration from legacy BI platforms to Microsoft Fabric Lakehouse. Ensure data governance, lineage, and metadata standards are met.
What you’ll do
- Review and document existing Qlik/Gather data models, schemas, and business rules
- Redesign legacy models into Microsoft Fabric Lakehouse structures, following Medallion architecture (Bronze, Silver, Gold layers)
- Translate legacy calculations, joins, and transformations into Fabric equivalents
- Ensure models comply with governance, lineage, and metadata standards
- Work closely with architects, BI consultants, and migration teams to ensure functional parity and business continuity
- Streamline and normalize models for scalability, performance, and future extensibility
- Provide clear technical and functional documentation for migrated models
What we’re looking for
Must have
- data modeling (conceptual, logical, physical)
- Qlik
- Gather
- Microsoft Fabric Lakehouse
- Medallion architecture
- SQL
Nice to have
- BI/data platform migration projects
- Azure ecosystem
- Synapse
- Databricks
- Power BI
- data governance tools
What makes this role challenging
- Translating complex legacy business logic and relationships into modern Fabric/Medallion structures without loss of functionality
- Balancing functional parity with modernization and performance goals during migration
- Documenting and mapping legacy Qlik/Gather models with potentially incomplete or outdated schemas
What success looks like
- First 30 days
- Ramp on the legacy Qlik/Gather data models, understand the current schemas and business rules, and begin documenting them against the target Fabric/Medallion architecture.
- By 90 days
- Translate a core legacy model into the Fabric Lakehouse structure (Bronze/Silver/Gold), map business logic and joins, and produce clear documentation for the prototype migration.
- First year
- Own the end-to-end migration of a legacy BI platform, driving redesign, governance alignment, and optimization, while mentoring peers on Fabric/Medallion best practices and establishing reusable migration playbooks.
Job Title: Data Modeler Company: the company Location: Bangalore/ Pune/Hyderabad About the company: the company is a global consulting and technology services firm specializing in data, analytics, and digital transformation solutions. With deep expertise in cloud platforms such as Microsoft Azure, Snowflake, and Databricks, the company helps organizations modernize their data ecosystems and drive business insights. The company focuses on delivering scalable data engineering, business intelligence, and AI-driven solutions across industries, enabling clients to make faster, data-driven decisions and achieve measurable business outcomes. Job Information Job Description: Role Overview The Data Modeler will be responsible for analyzing and documenting legacy BI/data platform models (e.g., Qlik, Gather), and redesigning them into modern, scalable data models aligned with Microsoft Fabric Lakehouse and Medallion architecture principles. This role ensures that business logic, relationships, and reporting structures are preserved while enabling modernization. Key Responsibilities
- Legacy Model Analysis: Review and document existing Qlik/Gather data models, schemas, and business rules.
- Model Recreation: Redesign legacy models into Microsoft Fabric Lakehouse structures, following Medallion architecture (Bronze, Silver, Gold layers).
- Business Logic Mapping: Translate legacy calculations, joins, and transformations into Fabric equivalents.
- Data Governance Alignment: Ensure models comply with governance, lineage, and metadata standards.
- Collaboration: Work closely with architects, BI consultants, and migration teams to ensure functional parity and business continuity.
- Optimization: Streamline and normalize models for scalability, performance, and future extensibility.
- Documentation: Provide clear technical and functional documentation for migrated models. Required Skills & Experience
- Strong expertise in data modeling techniques (conceptual, logical, physical).
- Hands on experience with legacy BI/data platforms (Qlik, Gather, or similar).
- Knowledge of Microsoft Fabric Lakehouse and Medallion architecture design.
- Proficiency in SQL, schema design, and metadata management.
- Ability to capture and translate business functionality into modern models.
- Strong communication and documentation skills. Preferred Qualifications
- Experience in BI/data platform migration projects (legacy → Fabric).
- Familiarity with Azure ecosystem (Synapse, Databricks, Power BI).
- Exposure to data governance tools (Purview, lineage tracking).
- Industry experience in telecom, finance, or enterprise scale environments.