About the role

JOB DESCRIPTION:

Role: Data Modeler

Locations: India

Type: Full-time

Experience: 4–8 Years

Primary Skills: Data Modeling (Visio), Strong SQL

Job Description:

We are seeking a talented and experienced Data Modeler with strong expertise in MS Visio and SQL to

join our team. The ideal candidate will have a solid background in data modeling, database design, and

data analysis, and will play a key role in translating business requirements into scalable and efficient data

structures. This role requires a strong problem-solver who can collaborate across teams to design data

models that support analytics, reporting, and enterprise data initiatives..

Key Responsibilities

• Design, develop, and maintain conceptual, logical, and physical data models using MS Visio

• Work closely with business stakeholders, product owners, and data engineering teams to

translate banking and financial requirements into scalable data models

• Develop and maintain Entity Relationship Diagrams (ERDs), data dictionaries, and metadata

documentation

• Ensure data accuracy, consistency, normalization, and referential integrity across banking

systems.

• Perform impact analysis for data model changes and enhancements

• Write and optimize complex SQL queries for data analysis, validation, and reconciliation

• Support downstream teams with data extraction, transformation logic, and reporting needs

• Ensure compliance with data governance, risk, security, and regulatory standards followed in

banking environments

• Participate in design reviews, audits, and model validations

• Collaborate in an Agile delivery model and support sprint-based deliverables

Required Skills & Experience:

• 4–8 years of hands-on experience in Data Modeling

• Strong experience using MS Visio for data modeling

• Excellent SQL skills (joins, subqueries, CTEs, performance tuning)

• Strong understanding of relational databases (Oracle / SQL Server / PostgreSQL)

• Knowledge of banking/financial domain data (customers, accounts, transactions, risk, compliance

preferred)

• Experience with normalization and dimensional modeling techniques

• Strong communication and stakeholder management skills

Good to Have:

• Experience with data warehousing and ETL processes

• Exposure to regulatory reporting and financial risk data

• Prior experience working with banking clients or large financial institutions