Data Modeler – BIG4s – Consultant/Senior Consultant – Multiple Locations

Location: Bangalore Chennai Gurgaon Kolkata Mumbai Pune
Job Type: Permanent
Years of Experience: 6-10 Years
Industry: Strategy / Management Consulting Firms
Functional Area: Other

Job Role: Consultant/Senior Consultant

Salary: 10 LPA to 27 LPA

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

Mandatory Skills: Data Modeling, Erwin, Erstudio

Recruiter Name: Shubham

Job Description

We are hiring for the position of Data Modeler – Consultant/Senior Consultant at our BIG4 client for multiple locations including Mumbai, Pune, Gurugram, Chennai, Bengaluru, and Kolkata. The successful candidate will work with subject matter experts to build Conceptual Data Models, convert business requirements into technical ones, and build logical/physical models that meet business needs.

Primary Skills:

  1. Experience in building Conceptual Data models in coordination with SMEs.
  2. Ability to convert business requirements into technical ones and ensure they are supported by an efficient data model.
  3. Experience in building Logical/Physical Models using best practices.
  4. Hands-on experience with Dimensional models, Corporate Information Factory & Data Vault methodologies.
  5. Experience in building Data Lake / Data Warehouse on Hadoop.
  6. Knowledge of optimizing logical/physical models to support new requirements.
  7. Proficiency in SQL, NoSQL, and data analysis.
  8. Familiarity with ER/Studio or other industry standard data modeling tools.
  9. Ability to analyze challenges around data integration and propose appropriate solutions.
  10. Experience in implementing data strategy, building efficient data flows, and testing data loads.


  1. Design and maintain conceptual and logical data models.
  2. Develop and implement best practices and processes around naming standards for consistency across models.
  3. Perform reverse engineering of physical models from existing databases and scripts.
  4. Work with development and consumption teams to implement data strategy and explain data model usage.
  5. Contribute to end-to-end Data Architecture & Design.
  6. Identify and implement ways to improve data reliability, efficiency, and quality.
  7. Collaborate with multiple IT roles, including Data Analysts, Solution Architects, and Information Architects.
Share this job

Apply for this position

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