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

Macpower Digital Assets Edge Private Limited

Las Vegas, NV

JOB DETAILS
SALARY
$57–$57 Per Hour
SKILLS
Amazon Simple Storage Service (S3), Apache Hadoop, Apiary/Beekeeping, Best Practices, Big Data, Cloud Computing, Communication Skills, Cross-Functional, Data Analysis, Data Mapping, Data Modeling, Data Modeling Tools, Data Profiling, Data Quality, Data Warehousing, Dimensional Modeling, Ecosystems, Embarcadero ER/Studio, Financial Services, IBM DB2, Leadership, Master Data Management (MDM), Microsoft SQL Server, Oracle Database, Quest Software TOAD, Relational Databases (RDBMS), Requirements Management, Snowflake Schema, Star Schema, Team Player, Thought Leadership, erwin Data Modeler
LOCATION
Las Vegas, NV
POSTED
9 days ago
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.

About the Company

M

Macpower Digital Assets Edge Private Limited