Data Modeler Engineer

Job Description

Job Description

Total Required Experience in Years: Minimum 810+ Years

Mode of Work: Onsite (No Remote)

Job Description: Seeking an experienced Data Modeler Engineer to design and implement enterprise-grade data models supporting large-scale Snowflake and Data Warehouse modernization initiatives within a banking environment. The ideal candidate should possess strong expertise in data modeling, Snowflake architecture, SQL, ETL concepts, ER modeling, SAS data analysis understanding, and enterprise data warehousing. This role requires hands-on experience designing logical and physical data models, supporting Snowflake architecture, building scalable enterprise data warehouse schemas, optimizing data structures for performance, and ensuring data quality, governance, and metadata management while aligning technical solutions with business requirements.

Key Responsibilities:

• Design and implement enterprise logical and physical data models for scalable data platforms
• Define enterprise data modeling standards, structures, and best practices supporting Snowflake environments
• Conduct impact analysis and ensure model alignment with business and reporting requirements
• Engineer conceptual, logical, and physical ER models for enterprise-grade data platforms
• Design high-performance data warehouse schemas including Star and Snowflake schemas for analytics optimization
• Develop and optimize Fact and Dimension tables supporting reporting and BI workloads
• Apply dimensional modeling techniques including Kimball methodology and Data Vault 2.0 architecture
• Support Snowflake data modeling, clustering, query optimization, and performance tuning activities
• Utilize advanced SQL for data transformation, validation, and query optimization
• Collaborate with ETL teams to design scalable and efficient enterprise data pipelines
• Ensure enterprise data integrity, governance, metadata management, and data quality standards
• Translate business requirements into scalable, future-ready enterprise data models
• Design end-to-end Data Warehouse architecture across staging, core, and presentation/BI layers

Additional Responsibilities:

• Support enterprise modernization and data warehouse optimization initiatives
• Collaborate with business teams, architects, ETL developers, and stakeholders on enterprise data strategies
• Maintain enterprise modeling documentation, standards, and governance practices
• Support performance tuning and scalable data platform improvements
• Ensure alignment between business needs, enterprise architecture, and reporting requirements

Required Skills:

• Strong expertise in enterprise data modeling and ER modeling concepts
• Strong Snowflake experience including architecture, clustering, and performance tuning
• Advanced SQL skills supporting transformations, validations, and query optimization
• Strong understanding of SAS for data analysis and business logic interpretation
• Experience with ETL concepts, Data Warehousing, and scalable data pipeline design
• Experience designing Star and Snowflake schemas for reporting and analytics workloads
• Expertise in Dimensional Modeling (Kimball) and Data Vault 2.0 methodologies
• Strong experience developing Fact and Dimension tables for enterprise reporting systems
• Experience supporting enterprise data governance, integrity, and metadata management

Qualifications:

• Minimum 810+ years of strong hands-on Data Modeling and Data Warehouse experience required
• Experience supporting Snowflake modernization and enterprise analytics initiatives preferred
• Strong enterprise architecture, performance optimization, and stakeholder collaboration experience preferred
• Experience translating business requirements into scalable enterprise data solutions preferred