Job Title: Data Modeler

Location: Mumbai, Bhubaneshwar, Chennai, Bangalore, Hyderabad

Year of Experience- 10 to 15 years

Required skill set

- Bachelor's/Masters degree in a relevant field (e.g. Computer Science, Software engineering, Data Science, AI/ML).
7+ years of experience Developing, deploying, and monitoring end to end data and analytics solutions with extensive knowledge of evaluation metrics and best practices.
7+ years Data Warehouse/Data Lake Architecture and Development.
5+ years Data Modeling & Architecture with experience in implementing at least one market leading banking and financial services data model i.e. from Oracle, Teradata, IBM
Experience on data modelling tools such as Erwin, ER Studio, SQL modeler is preferred
Experience in ETL/ELT, data Pipelines, Data Quality, blueprints development.
Non-Relational Database experience (Document DB, Graph DB, etc.)
Understanding of data structures, data modeling and data architecture
Strong communication skills and ability to work with ambiguity.
Able to provide direction/support to data modelling team members.
Strong architectural knowledge for data analytics systems patterns and their pros and cons.
Strong knowledge of data quality, metadata management, security frameworks / tools implemented for data on cloud architecture
Skillful resource to understand customer needs and provide target solutions, which is scalable, reliable, and highly available.

Desired Competencies (Technical/Behavioral Competency)

Must-Have

Technical:

Data architecture framework design

ER, Dimensional & Data Vault modelling

Cloud-based data solution architecture experience

7+ yrs Data Warehouse/Data Lake architecture

5+ yrs Data modelling in BFS models (Oracle/Teradata/IBM)

Strong SDLC knowledge (Agile + Waterfall)

ETL/ELT, data pipelines, streaming, ingestion

Data security aligned to GDPR/CCPA

Metadata mgmt, data quality, data governance

Experience with data virtualization (e.g., Denodo)

Experience with non-relational DBs (Document DB, Graph DB)

Architecture patterns knowledge for analytics systems

Strong understanding of data structures & architecture

Behavioral:

Strong communication skills & comfort with ambiguity

Stakeholder engagement (incl. Clevel & partners)

Ability to mentor and lead modelling/architecture teams

Ability to translate requirements into data models

Agile leadership

Team collaboration

Problemsolving & analytical approach

Drive for results

High integrity & honesty

Communicate powerfully and prolifically

Data Modeler