Data Modeller

HCLTech; Bengaluru; On-site; INR 2,800,000 - 4,000,000; Full time

Job summary

HCLTech in Bengaluru, India is seeking a Data Modeller with 8–12 years of experience to help design and modernize data models across cloud platforms. You will translate legacy logic, define canonical layers, maintain data contracts, and document data lineage while applying data quality checks.

Experience in financial services is highly desirable. Strong SQL skills and familiarity with tools like Erwin, Hackolade, and dbt are expected.

Qualifications

• Core data modelling experience: 2–5 years
• Strong SQL and query optimization
• Cloud data platforms like Snowflake or AWS S3
• Financial services exposure desirable

Responsibilities

• Assist with Schema Design: build, update, and maintain data models.
• Translate legacy SQL to structured dimensional models in the cloud.
• Support the Canonical & Semantic Layers: document columns, keys, and metrics.
• Maintain Data Contracts: update YAML/schema files with metadata and test rules.
• Document Lineage & Catalogue: map end-to-end data lineage to dashboards and catalogue.
• Apply DQ Checks: integrate data quality tests into model definitions.

Skills

Data modelling

SQL

Cloud platforms

Data quality

Git

Tools

Erwin

Hackolade

dbt

Job description

We are looking for Data Modeller for HCL Tech

Experience: 8-12 years of experience

Notice Period: 0-30 Days

Key Responsibilities

• Assist with Schema Design: Help build, update, and maintain logical and physical data models. Any domain.
• Translate Legacy Logic: Analyze existing legacy SQL queries and help map them into clean, structured dimensional models in the cloud
• Support the Canonical & Semantic Layers: Collaborate with Analytics Engineers to document and define columns, keys, and metrics within the shared transformation layer.
• Maintain Data Contracts: Update YAML or schema files to ensure data products include required metadata, such as ownership, schema definitions, and automated test rules.
• Document Lineage & Catalogue: Map end-to-end data lineage from source systems to final dashboards, and ensure all entries are kept up-to-date in the data product catalogue.
• Apply DQ Checks: Integrate standard data quality tests (e.g., null checks, unique constraints, and data type validations) directly into the model definitions.

Required Skills & Experience

• Core Data Modelling: 2–5 years of experience in data modelling, with a solid understanding of relational databases and Kimball dimensional modelling (Stars and Snowflakes)
• Strong SQL: Advanced SQL skills with the ability to read, optimize, and reverse engineer complex legacy queries.
• Modern Cloud Exposure: Hands-on experience or strong working knowledge of cloud platforms like Snowflake or AWS S3/Lakehouses. Knowledge of Apache Iceberg is a strong plus.
• Financial Services Exposure: Prior experience in banking, wealth management, or financial services is highly desirable.
• Tooling Familiarity: Experience using data modelling tools (e.g., Erwin, Hackolade, or dbt) and version control systems (Git).

Interested candidates please share your resume to [e-mail] along with below details