Lead Data Modeler

Position: Lead Data Modeler

Location: Mumbai/Pune

What Youll Do

• Develop conceptual, logical, and physical data models to represent various data domains, ensuring accuracy, consistency, and scalability.
• Define data structures, relationships, and attributes that capture business requirements and enable efficient data storage and retrieval.
• Collaborate with business stakeholders, analysts, and data consumers to gather and understand data requirements, ensuring that data models align with business needs.
• Translate business requirements into database schema designs, including normalization and denormalization techniques to optimize data integrity and performance.
• Ensure data integrity and quality by defining constraints, validation rules, and data governance policies within the data models.
• Define data quality standards and best practices and maintenance process for CDM/LDM/PDM/Semantic dimensional models.
• Create comprehensive documentation of data models, including entity-relationship diagrams, data dictionaries, and metadata definitions.
• Maintain up-to-date documentation as data models evolve over time.
• Collaborate with data scientists to provide structured data for analytical and machine learning purposes.
• Enforce data governance and compliance standards by incorporating security and privacy considerations into data models.
• Collaborate with legal and compliance teams to ensure adherence to data protection regulations.
• Keep up-to-date with industry trends, emerging technologies, and best practices in data modeling, database design, and data management.
• Provide regular updates for tasks, deliverables, including information on task status, est. target dates, % completed, priority, allocation percentage, % completed, issues, gaps, for all tasks worked on/planned.
• Lead a project team of Data Modelers
• Teradata seeks a Data Modelling professional to work closely with customer on the projects.

Professional developments offered:

• Training on the Teradata products.
• Opportunities to work on high-profile international projects.
• What Makes You a Qualified Candidate
• Bachelors Degree from a reputed Educational Institute.
• Must have 10+ years of IT experience.
• Must have 8+ years of Data Modeling relevant experience.
• Proven experience as a Data Modeler / Database Designer / Information Architect.
• Proficiency in data modelling tools such as ERwin, PowerDesigner, ER/Studio, or similar tools.
• Strong understanding of relational database concepts, normalization, and denormalization.
• Familiarity with various database systems (e.g. Vantage, SQL Server, Oracle, PostgreSQL).
• Experience with big data platforms and NoSQL databases is a plus.
• Excellent problem-solving skills and attention to detail.
• Knowledge of Insurance industry domain could be a plus.
• Experience with reference industry data models could be an advantage.
• Strong communication and collaboration skills.
• Ability to clearly and confidently articulate your thoughts.
• Ability to work in a fast-paced, dynamic environment.
• Knowledge of data governance and compliance regulations is desirable.
• Willing to travel – both short-term and long-term if required.

What You’ll Bring

• As a Data Modeler, you will contribute to the foundation of effective data management within the customer organization, ensuring that data is organized, accessible, and valuable for making informed business decisions.
• Your expertise in designing efficient and scalable data models will be essential for driving successful data-driven initiatives for different customers.
• Provide knowledge and expertise to other TERADATA professional services associates.
• Flexibility in working in off-working hours (shift work) including 24X7 Support if required
• Complete interaction with the customer to collaborate & resolve the issues.
• Strong communication and interpersonal skills, with the ability to articulate complex issues to technical and non-technical stakeholders.
• Strong understanding of relational database concepts, normalization, and denormalization.