Data Modeller

Purview Services; Nagpur District; On-site; INR 700,000 - 1,200,000; Full time

Job summary

Purview Services in Nagpur seeks a skilled Data Modeler to design, implement, and document data architectures across SQL, NoSQL, and cloud platforms. You will develop conceptual, logical, and physical data models and oversee stores such as data warehouses, data lakes, and data marts.

You will collaborate with business and IT teams to build data flows, follow standards, and perform hands-on modeling, tuning, and sandbox POC. Strong English, communication, and stakeholder management are essential.

Qualifications

• Strong communication skills, good oral English, and excellent stakeholder management.
• 3+ years hands-on experience with relational, dimensional, and/or analytics using RDBMS, dimensional and NoSQL data platforms, ETL, and data ingestion protocols.
• Experience with data warehouse, data lake, and enterprise big data platforms in multi-data-centre contexts.
• Knowledge of metadata management, data modelling and related tools (Erwin or Visual Paradigm or others).
• Strong financial domain and data analysis skills with requirements gathering, elicitation, gap analysis, data analysis, estimation, reviews, and translating requirements into technical data solutions.
• Dependable team player with ownership, problem-solving attitude, and ability to work in fast-paced, changing environments.

Responsibilities

• Develop conceptual, logical, and physical data models and oversee implementation of RDBMS, ODS, application databases, data marts, and data lakes on SQL/NoSQL/cloud/on-prem.
• Work with business and solution teams to implement data strategies, build data flows, and develop data models.
• Contribute to and follow published data modelling standards and best practices to meet business and technical requirements.
• Hands-on data modelling, design, configuration, installation, performance tuning, and sandbox POC.
• Work proactively and independently to address project requirements and communicate issues to reduce delivery risks.

Skills

Communication

English proficiency

Stakeholder management

Data modelling

RDBMS

Data warehouse

Data lake

NoSQL

Metadata management

Erwin

Visual Paradigm

ETL tools

Tools

Erwin

Visual Paradigm

Job description

The data modeler designs, implements, and documents data architectures and data models for solutions, which include the use of application, relational, dimensional, and NoSQL databases. These solutions support enterprise information management, business intelligence, operations, machine learning, data science, and other business interests.

The successful candidate will:

1. Be responsible for the development of the conceptual, logical, and physical data models, oversight of the implementation of RDBMS, operational data stores (ODS), application databases, data marts, and data lakes on target platforms (SQL/NoSQL/cloud/on-prem).
2. Contribute and understand the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively.

Responsibilities:

• Implement business and IT data requirements through new data strategies and designs across all data platforms (application, relational, dimensional, and NoSQL) and data tools (reporting, visualization, analytics, operations and machine learning).
• Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models
• Contribute in and follow the published data modelling and design standards, tools, best practices, and related development for enterprise data models, to fulfil both business as well as technical requirements and expectations.
• Hands-on data modelling, design, configuration, installation, performance tuning, and sandbox POC.
• Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks, collaborating with relevant stakeholders across IT and business.

Skills:

• Strong communication skill, good oral English, and excellent stakeholder management skills.
• 3+ years of strong hands-on experience on relational, dimensional, and/or analytics (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols).
• Experience with data warehouse, data lake, and enterprise big data platforms in multi-data-centre contexts required.
• Good knowledge of metadata management, data modelling, and related tools (Erwin or Visual Paradigm or others) required.
• Strong financial domain and data analysis skills with experience covering activities like requirement gathering, elicitation skills, gap analysis, data analysis, effort estimation, reviews, ability to translate the high-level functional data or business requirements into technical solution, database designing and data mapping.
• Dependable team player, having a sense of ownership and a problem solver attitude with solution‑seeking approach and ability to work and adapt in a fast‑paced and continuously changing environment.

Good to have:

• Experience in cloud data solutions (e.g., AWS, Azure, Google Cloud).
• Familiarity with big data technologies (e.g., Hadoop, Spark).
• Knowledge of industry models (BIAN, FSDM, BDW etc.) or experience in designing enterprise data models