Data Modeler - Lead

Envision Technology Solutions; India; Remote; INR 1,400,000 - 3,200,000; Full time

Job summary

Envision Technology Solutions is seeking a skilled Data Modeler to design, develop, and maintain data models for diverse business needs. You will work with stakeholders and data engineers to translate requirements into robust data models across relational and non-relational systems.

The ideal candidate has 8+ years of data modeling and database design experience, strong SQL skills on Azure Synapse, and proficiency with ER/Studio or ERwin.

Qualifications

• 8+ years of experience in data modeling and DB design.
• Experience in Wealth Management/Finance domain is a plus.
• Proficient in data modeling tools and methodologies.

Responsibilities

• Collaborate with stakeholders, analysts, and data engineers to translate requirements into data models.
• Design and develop conceptual, logical, and physical data models.
• Perform data profiling to assess quality, structure, and relationships.

Skills

Data modeling

SQL

Analytical thinking

Communication

Tools

draw.io

ERwin

ER/Studio

Azure Synapse Analytics

Job description

Job Title: Data Modeler

We are seeking a talented and experienced Data Modeler to join our team. The Data Modeler will be responsible for designing, developing, and maintaining data models to support various business needs and initiatives. The ideal candidate will have a strong background in data modeling principles, database design, and data management best practices.

Responsibilities:

• Collaborate with stakeholders, business analysts, and data engineers to understand business requirements and translate them into conceptual, logical, and physical data models.
• Design and develop data models using industry-standard modeling techniques and tools.
• Perform data profiling and analysis to understand data quality, structure, and relationships.
• Optimize data models for performance, scalability, and usability.
• Define and enforce data modeling standards, best practices, and guidelines.
• Participate in data governance initiatives to ensure compliance with data management policies and standards.
• Work closely with database administrators and developers to implement data models in relational and non-relational database systems.
• Conduct data model reviews and provide recommendations for improvements.
• Stay updated on emerging trends and technologies in data modeling and data management

Requirements:

• 8+ years of experience in data modeling and database design and experience in the Wealth Management/Finance domain will be an added advantage.
• Proficiency in data modeling tools such as draw.io , ERwin, ER/Studio, or similar tools.
• Strong knowledge of SQL on Azure Synapse Analytics.
• Experience with ODS, data warehouse design and dimensional modeling.
• Excellent analytical and problem-solving skills.
• Strong communication and collaboration skills.
• Ability to work effectively in a fast-paced, dynamic environment.