Senior Data Modeler

6 - 9 years

6 - 9 Lacs

Posted:1 week ago| Platform: Foundit logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Senior Data Modeler

  • Key Responsibilities:

    Design, develop, and maintain

    relational, dimensional, and analytical data models

    for large-scale

    OLTP and analytical systems

    .
  • Perform hands-on

    data modeling, ER diagramming, and enterprise software design

    for diverse data ecosystems.
  • Define and enforce

    data modeling standards and best practices

    for scalable and high-performance solutions.
  • Work with

    SQL databases

    such as

    Oracle, PostgreSQL, Snowflake, and Teradata

    , optimizing performance and query tuning.
  • Collaborate with

    cross-functional teams (engineers, architects, product managers)

    to translate business requirements into

    effective data models

    .
  • Implement

    metadata management, data lineage, and data cataloging

    using tools like

    Alation and Collibra

    .
  • Ensure data

    accuracy, completeness, and consistency

    across data models and maintain comprehensive documentation.
  • Support

    history handling, time-series data warehousing, and complex data transformations

    .
  • Assist teams in

    adopting data modeling best practices

    for global, large-scale data-driven implementations.
  • Contribute to

    data governance

    initiatives and establish a

    centralized metadata repository

    .
  • Work in a

    fast-paced, agile environment

    with short release cycles and iterative development methodologies.
  • Required Skills:7+ years of experience

    in relational, dimensional, and analytical data modeling.
  • Strong

    SQL

    skills with hands-on experience in

    Oracle, PostgreSQL, Snowflake, and Teradata

    .
  • Experience with

    data modeling tools

    (Erwin, ER Studio, or similar).
  • Expertise in

    data governance processes

    and

    metadata repositories

    .
  • Knowledge of

    semantic data modeling concepts

    and

    multi-fact model

    designs.
  • Strong verbal and written communication skills to interact with

    engineers, architects, and product managers

    .
  • Ability to work on

    multiple projects/products simultaneously

    with minimal specifications.
  • Experience in

    Alation and Collibra

    for

    data cataloging and data lineage tracking

    .
  • Good to Have:

    Knowledge of

    Python

    for data processing.
  • Experience with

    Informatica

    for ETL and data integration.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You

Chennai, Tamil Nadu, India

Hyderabad, Pune, Chennai

Chennai, Tamil Nadu, India