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.
Qualifications:
- 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.