Mid-Level Data Modeler (SQLDBM)
On-siteBengaluru, Karnataka, India
Job Summary
Design and maintain end-to-end conceptual, logical, and physical data models using SQLDBM to support enterprise analytics and reporting initiatives. Utilize SQLDBM for cloud data warehouse design, reverse-engineering existing databases, and maintaining visual documentation. Collaborate with data architects and business stakeholders to translate business requirements into clean, production-ready schema designs and optimize DDL scripts for deployment. Manage schema versioning, drift detection, and data governance standards while assisting in query optimization and indexing strategies. Ensure data lineage and metadata registries are strictly followed within the Snowflake environment.
Required Qualifications
- 3–5 years of professional experience in data modeling, data architecture, or data engineering
- Strong, hands-on proficiency with SQLDBM for visual modeling, schema generation, and collaboration
- Proven expertise in Dimensional Modeling (Kimball/Star Schema) as well as relational modeling (3NF)
- Advanced SQL skills for querying, data profiling, and analyzing complex data sets
- Direct experience modeling for modern cloud data warehouses, specifically Snowflake
- Proven track record of translating business needs into structured technical documentation and maintaining comprehensive data dictionaries
Desired Qualifications
- Experience integrating SQLDBM with Git repositories (GitHub/GitLab) for database schema CI/CD pipelines
- Experience working within Financial Services, Wealth Management, or FinTech sectors (understanding of security master systems or portfolio accounting data is a major plus)
- Familiarity with Python for data manipulation or automated testing
- Experience working in an Agile/Scrum development environment
- Snowflake Certified Core Support, SnowPro Core, or relevant data modeling certifications
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.