Lead Data Modeler

EXL; Pune District, Gurugram District, Bengaluru; Hybrid; INR 2,500,000 - 4,500,000; Full time

Job summary

EXL in Pune is seeking an experienced Data Architect to translate business needs into robust data models and architectures. You will lead data modelling efforts, define standards for data movement, and collaborate with developers to build scalable data lakes, MDS/ODS, and relational stores.

The role requires hands-on mastery of ERwin/ERStudio/PowerDesigner and strong SQL, with a track record of delivering data vault or dimensional models while ensuring quality and governance across projects.

Qualifications

• 10+ Years industry implementation experience with one or more data modelling tools such as Erwin, ERStudio, PowerDesigner etc.
• Minimum of 8 years of data architecture, data modelling (Data Vault and Dimensional, 3NF) or similar experience

Responsibilities

• Understand and translate business needs into data models supporting long-term solutions.
• Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
• Create and maintain conceptual, logical and physical data models using best practices to ensure high data quality and reduced redundancy, along with corresponding metadata.
• Optimize and update logical and physical data models to support new and existing projects.
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Recommend opportunities for reuse of data models in new environments.
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Evaluate data models and physical databases for variances and discrepancies.
• Validate business data objects for accuracy and completeness.
• Analyse data-related system integration challenges and propose appropriate solutions.
• Develop data models according to company standards. Guide System Analysts, Engineers, Programmers and others on project limitations and capabilities, performance requirements and interfaces.
• Review modifications to existing software to improve efficiency and performance.
• Examine new application design and recommend corrections if required.
• Assist with and support setting the data architecture direction (including data movement approach, architecture / technology strategy, and any other data-related considerations to ensure business value,) ensuring data architecture deliverables are developed, ensuring compliance to standards and guidelines, implementing the data architecture, and supporting technical developers at a project or business unit level.
• Coordinate and consult with the project manager, client business staff, client technical staff and project developers in data architecture best practices and anything else that is data related at the project or business unit levels.

Skills

Analytical thinking

Problem solving

Communication

Stakeholder management

Tools

Erwin

ERStudio

PowerDesigner

SQL

NoSQL

Job description

The successful candidate will:

Provides technical expertise in needs identification, data modelling, data movement and transformation mapping (source to target), automation and testing strategies, translating business needs into technical solutions with adherence to established data guidelines and approaches from a business unit or project perspective.

Be responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).

Essential Duties:

• Understand and translate business needs into data models supporting long-term solutions.
• Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
• Create and maintain conceptual, logical and physical data models using best practices to ensure high data quality and reduced redundancy, along with corresponding metadata.
• Optimize and update logical and physical data models to support new and existing projects.
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Recommend opportunities for reuse of data models in new environments.
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Evaluate data models and physical databases for variances and discrepancies.
• Validate business data objects for accuracy and completeness.
• Analyse data-related system integration challenges and propose appropriate solutions.
• Develop data models according to company standards. Guide System Analysts, Engineers, Programmers and others on project limitations and capabilities, performance requirements and interfaces.
• Review modifications to existing software to improve efficiency and performance.
• Examine new application design and recommend corrections if required.
• Assist with and support setting the data architecture direction (including data movement approach, architecture / technology strategy, and any other data-related considerations to ensure business value,) ensuring data architecture deliverables are developed, ensuring compliance to standards and guidelines, implementing the data architecture, and supporting technical developers at a project or business unit level.
• Coordinate and consult with the project manager, client business staff, client technical staff and project developers in data architecture best practices and anything else that is data related at the project or business unit levels.

Required Qualifications:

• 10+ Years industry implementation experience with one or more data modelling tools such as Erwin, ERStudio, PowerDesigner etc.
• Minimum of 8 years of data architecture, data modelling (Data Vault and Dimensional, 3NF) or similar experience