Data Modeler

NextLink Group; Thiruvananthapuram, Ernakulam, Chennai, Bengaluru; Presencial; INR 3.500.000 - 6.500.000; Jornada completa

Descripción de la vacante

NextLink Group is seeking a Senior Data Modeler to design, develop, and implement scalable data models on the Databricks Lakehouse platform. You will work with Data Vault 2.0, Star/Snowflake schemas, and medallion architecture to support enterprise data needs in Insurance/Financial Services as applicable.

You will collaborate with data architects, engineers, and stakeholders to translate business requirements into robust models, ensure data quality and governance, and optimize SQL for

Formación

• 10+ years of experience in data modeling and data architecture.
• Strong hands-on experience in Data Vault 2.0 implementation.
• Extensive experience with Databricks, Lakehouse, Delta Lake, and Unity Catalog.
• Strong expertise in dimensional modeling, including Star and Snowflake schemas.
• Advanced SQL skills, including query optimization and performance tuning.
• Hands-on experience designing and implementing Bronze, Silver, and Gold data models.
• Strong understanding of metadata management, data lineage, data governance, and data quality.
• Experience in the Insurance or Financial Services domain.
• Hands-on experience with data modeling tools such as ERwin, SQLDBM, and ER/Studio.
• Working knowledge of Microsoft SQL Server 2019.
• Knowledge of data architecture best practices and modern data engineering principles.
• Experience implementing data governance and metadata management frameworks.
• Experience Required: 10+ years
• Primary Skills: Databricks, Data Vault2.0, Data Architecture, Data Modeling, Microsoft SQL Server 2019

Responsabilidades

• Design and implement enterprise data models using Data Vault 2.0 principles and best practices.
• Develop and maintain scalable data models on the Databricks Lakehouse platform, leveraging Delta Lake and Unity Catalog.
• Design and implement dimensional data models, including Star and Snowflake schemas.
• Create and optimize Bronze, Silver, and Gold data models following the Medallion Architecture.
• Write, optimize, and troubleshoot complex SQL queries to support data transformation and processing requirements.
• Establish and maintain metadata management, data lineage, data quality, and governance standards.
• Collaborate with data architects, engineers, business stakeholders, and other technical teams to translate business requirements into effective data models.
• Ensure data models are scalable, reliable, maintainable, and aligned with enterprise data architecture standards.
• Use data modeling tools to design, document, and maintain conceptual, logical, and physical data models.

Conocimientos

Data Modeling

Data Vault 2.0

Databricks

Lakehouse Architecture

Delta Lake

Unity Catalog

Dimensional Modeling

Star Schema

Snowflake Schema

Advanced SQL

Query Optimization

Performance Tuning

Metadata Management

Data Governance

Data Quality

ERwin

SQLDBM

ER/Studio

Microsoft SQL Server 2019

Herramientas

ERwin

SQLDBM

ER/Studio

Microsoft SQL Server 2019

Descripción del empleo

Trivandrum, Chennai, Bangalore, Kochi, India

What is the mission about?

Nextlink is seeking an experienced Senior Data Modeler with strong expertise in Databricks and Data Vault 2.0 to design, develop, and implement scalable, high-performance data models within a modern lakehouse architecture. The ideal candidate will have extensive experience in enterprise data modeling, advanced SQL, data architecture, and data governance, preferably within the Insurance or Financial Services domain

Job Description

Role Overview

Nextlink is seeking an experienced Senior Data Modeler withstrong expertise in Databricks and Data Vault 2.0 to design, develop, andimplement scalable, high-performance data models within a modern lakehousearchitecture. The ideal candidate will have extensive experience in enterprisedata modeling, advanced SQL, data architecture, and data governance, preferablywithin the Insurance or Financial Services domain.

Key Responsibilities

• Design and implemententerprise data models using Data Vault 2.0 principles and bestpractices.
  
• Develop and maintainscalable data models on the Databricks Lakehouse platform,leveraging Delta Lake and Unity Catalog.
  
• Design and implementdimensional data models, including Star and Snowflake schemas.
  
• Create and optimizeBronze, Silver, and Gold data models following the Medallion Architecture.
  
• Write, optimize, andtroubleshoot complex SQL queries to support data transformation andprocessing requirements.
  
• Establish and maintainmetadata management, data lineage, data quality, and governance standards.
  
• Collaborate with dataarchitects, engineers, business stakeholders, and other technical teams totranslate business requirements into effective data models.
  
• Ensure data models arescalable, reliable, maintainable, and aligned with enterprise dataarchitecture standards.
  
• Use data modeling toolsto design, document, and maintain conceptual, logical, and physical datamodels.
  

Requirements

Essential Skills and Qualifications

• 10+ years of experience in data modeling anddata architecture.
  
• Strong hands-onexperience in Data Vault 2.0 implementation.
  
• Extensive experiencewith Databricks, Lakehouse, Delta Lake, and Unity Catalog.
  
• Strong expertise indimensional modeling, including Star and Snowflake schemas.
  
• Advanced SQL skills,including query optimization and performance tuning.
  
• Hands-on experiencedesigning and implementing Bronze, Silver, and Gold data models.
  
• Strong understanding ofmetadata management, data lineage, data governance, and data quality.
  
• Experience in theInsurance or Financial Services domain.
  
• Hands-on experience withdata modeling tools such as ERwin, SQLDBM, and ER/Studio.
  
• Working knowledge ofMicrosoft SQL Server 2019.
  
• Knowledge of dataarchitecture best practices and modern data engineering principles.
  
• Experience implementingdata governance and metadata management frameworks.
  
• Experience Required: 10+ years
  
• Primary Skills: Databricks, Data Vault2.0, Data Architecture, Data Modeling, Microsoft SQL Server 2019