BFSI Toad Data Modeler - Big Data, Data Vault 2.0 & Cloud Data Warehouse

Job Overview

Key Responsibilities

• Lead and contribute to complex data modeling initiatives (100+ entities/tables) across both on-premises and cloud environments.
• Design and develop data models using Data Vault 2.0, star, and snowflake schemas for cloud platforms and big data ecosystems.
• Collaborate with cross-functional teams including product managers, developers, DBAs, business stakeholders, and data governance teams to gather requirements and deliver scalable solutions.
• Implement data warehouse design methodologies including Bill Inmon and Ralph Kimball approaches.
• Analyze and model data from various big data sources and tools such as Hive, S3, Trino, and HUE.
• Utilize data modeling tools like Erwin, ER/Studio, or Toad Data Modeler to design normalized, denormalized, relational, and dimensional models.
• Apply best practices in Data Warehousing, Data Profiling, Data Quality, Master Data Management (MDM), Data Lineage, Data Mapping, Data Dictionary, and Data Governance.
• Provide thought leadership in emerging architecture patterns such as Data Lakehouse.

Required Qualifications

• 7+ years of experience in data modeling and data analysis.
• 4–7 years of hands-on experience with Big Data and Hadoop ecosystems.
• Strong expertise in cloud data warehouse platforms, especially Snowflake.
• Prominent experience in Data Vault 2.0 modeling methodology.
• Solid knowledge of big data tools and platforms (e.g., Hive, S3, Trino).
• Deep understanding of both on-prem and cloud-based data architectures.
• Extensive experience with relational databases such as Oracle, SQL Server, DB2, and Redshift.
• Excellent collaboration and communication skills; experience working in cross-functional and agile environments.