Data Modeler Expert – BIG4 – Multiple Locations

Location: Bangalore Delhi/NCR Kolkata Pune
Job Type: Permanent
Years of Experience: 5-10 Years
Industry: IT Services & Consulting
Functional Area: IT Services & Consulting

Job Role: Data Modeler Expert - Consultant/Senior Consultant

Salary: 15 LPA to 24 LPA

Qualification: B.E./B.Tech/MCA/M.Tech/MBA degree or equivalent.

Mandatory Skills: ERWin and ER/Studio

Recruiter Name: Mayuri

Job Description

Are you ready to design data models that drive strategic decision-making? A leading Big4 firm is looking for a Data Modeler to join our consultancy team in various strategic locations across India, including Delhi/NCR, Pune, Bangalore, and Kolkata.

Hiring For: EY India

Key Responsibilities:

  • Engage with SMEs to craft Conceptual Data Models and translate business needs into robust data strategies.
  • Create Logical/Physical Models in Azure, ensuring alignment with business requirements and SLAs.
  • Implement leading data modeling methodologies such as Dimensional models (Ralph Kimball), Corporate Information Factory (Bill Inmon), and Data Vault.
  • Develop and optimize data lakes and warehouses on Azure, with proficiency in ADLS, ADF, ADB, and SQL.
  • Use industry-standard tools like ER/Studio to enrich logical/physical models with metadata.
  • Establish best practices for naming standards and model versioning, ensuring consistency across the enterprise.
  • Reverse engineer physical models from databases and scripts for improved data utility and performance.
  • Foster reusability of data models, tackle data integration/mastering challenges, and propose viable solutions.
  • Support the development team in creating efficient data flows, model implementation, and load testing.
  • Guide consumption teams in data model utilization and modifications for optimized data access.
  • Maintain data modeling artifacts, contributing to end-to-end Data Architecture & Design.


  • Work Experience: 5 to 10 years in data modeling.
  • Mandatory Skills: Proficiency in ERWin and ER Studio.
  • Education: B.E./B.Tech/MCA/M.Tech/MBA degree or equivalent.

What We Offer:

  • A competitive salary ranging from 15 LPA to 24 LPA.
  • The chance to work with a Big4 firm known for excellence in IT Services & Consulting.
  • A role in a firm that values innovation and offers a collaborative environment for professional growth.

If you’re a problem-solver, an efficient data modeler, and ready to take your career to new heights, this role is for you.

Share this job

Apply for this position

Allowed Type(s): .pdf, .doc, .docx, .rtf