> Markdown version of [/jobs/ext/2160837-bfsi-toad-data-modeler-big-data-data-vault-2-0-cloud-data-warehouse](https://www.wearedevelopers.com/jobs/ext/2160837-bfsi-toad-data-modeler-big-data-data-vault-2-0-cloud-data-warehouse). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # BFSI Toad Data Modeler - Big Data, Data Vault 2.0 & Cloud Data Warehouse - **Company:** Macpower Digital Assets Edge LLC - **Location:** Las Vegas, NV, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Sql Data Warehouse, Agile Methodology, Amazon S3, Data Analysis, Big Data, Cloud Computing, Cloud Database, Data Dictionary, Data Governance, Data Mapping, Data Profiling, Data Vault Modeling, Data Warehousing, IBM DB2, Relational Databases, Dimensional Modeling, Apache Hadoop, Apache Hive, Microsoft SQL Server, Oracle Databases, Oracle (Applications), Requirements Management, Toad Data Modeler, Snowflake, Er-Win, Data Lineage, Star Schema, Toad (Software), Data Management, Data Lakehouse, Amazon Redshift - **Published:** August 21, 2026 - **Apply:** https://www.careerbuilder.com/job-details/bfsi-toad-data-modeler-big-data-data-vault-2-0-cloud-data-warehouse-las-vegas-nv--65fb6f18-2cb8-4a2a-b6cb-7363ee6b2bab ## About the Role 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., * 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. 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 ## Description * 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. ## Related Videos - [Data Fabric in Action - How to enhance a Stock Trading App with ML and Data Virtualization](https://www.wearedevelopers.com/videos/253-data-fabric-in-action-how-to-enhance-a-stock-trading-app-with-ml-and-data-virtualization) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [DataForce Studio](https://www.wearedevelopers.com/videos/1657-dataforce-studio) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)