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

  • $57 Per Hour

Highlights

Apply best practices in Data Warehousing , Data Profiling , Data Quality , Master Data Management (MDM) , Data Lineage , Data Mapping , Data Dictionary , and Data Governance . Job Overview: We are seeking a highly experienced and motivated Senior Data Modeler from Financial Services Domain with over 7 years of expertise in data modeling and data analysis.

Numbers & Facts

LocationLas Vegas, NV
Salary$57 Per Hour

Description

Job Overview: We are seeking a highly experienced and motivated Senior Data Modeler from Financial Services Domain with over 7 years of expertise in data modeling and data analysis. The ideal candidate should possess strong communication and leadership skills, along with hands-on experience in Big Data, cloud data warehouses, and modern data architecture concepts.
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.
  • Proven 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.
Preferred:
  • Experience in the Financial Services domain.

Similar Jobs