Mid -Level Data Modeler (SQLDBM)

Position Overview
Location - Bangalore/Pune/Chennai/Remote

We are seeking a skilled and detail -oriented Mid -Level Data Modeler to join our data
engineering and architecture team. In this role, you will bridge the gap between business
requirements and technical execution by designing, developing, and maintaining
conceptual, logical, and physical data models.
The ideal candidate has hands -on experience utilizing SQLDBM for cloud data warehouse
modeling (e.g., Snowflake) and possesses a deep understanding of modern data
architecture, normalization, and dimensional modeling techniques. You will collaborate
closely with data architects, analytics engineers, and business stakeholders to ensure our
data infrastructure is scalable, performant, and aligned with organizational goals.

Job Duties & Responsibilities

• Data Modeling & Design: Design and maintain end -to -end conceptual, logical, and
physical data models to support enterprise analytics and reporting initiatives.

• Platform Management: Utilize SQLDBM as the primary tool for cloud data
warehouse design, reverse -engineering existing databases, and maintaining up -to
date visual documentation.

• Architecture Collaboration: Work alongside Data Architects to implement robust
architectural standards, establish data symbology, and support asset classification
or master data management frameworks.

• Pipeline Support: Collaborate with data engineers and business analysts to
translate complex business requirements (BRDs/RDDs) into clean, production
ready schema designs.

• Forward/Reverse Engineering: Generate, review, and optimize DDL scripts from
SQLDBM for deployment, and manage schema versioning and drift detection.

• Data Governance: Maintain data dictionaries, definitions, and metadata registries
within SQLDBM to ensure data lineage and governance standards are strictly
followed.

• Performance Tuning: Assist in optimizing SQL queries, indexing strategies, and
clustering keys to ensure high -performance data retrieval.

Must -Have

• Experience: 3–5 years of professional experience in data modeling, data
architecture, or data engineering.

• Tooling: Strong, hands -on proficiency with SQLDBM for visual modeling, schema
generation, and collaboration.

• Methodologies: Proven expertise in Dimensional Modeling (Kimball/Star
Schema) as well as relational modeling (3NF).

• Technical Skills: Advanced SQL skills for querying, data profiling, and analyzing
complex data sets.

• Cloud Data Platforms: Direct experience modeling for modern cloud data
warehouses, specifically Snowflake.

• Documentation: Proven track record of translating business needs into structured
technical documentation and maintaining comprehensive data dictionaries.

Nice -to -Have (Preferred Qualifications)

• Version Control: Experience integrating SQLDBM with Git repositories
(GitHub/GitLab) for database schema CI/CD pipelines.

• Domain Knowledge: Experience working within Financial Services, Wealth
Management, or FinTech sectors (understanding of security master systems or
portfolio accounting data is a major plus).

• Programming: Familiarity with Python for data manipulation or automated testing.

• Agile Frameworks: Experience working in an Agile/Scrum development
environment.

• Certifications: Snowflake Certified Core Support, SnowPro Core, or relevant data
modeling certifications.