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

Macpower Digital Assets Edge LLC

Las Vegas, NV, United States

16 days ago

Apply on www.careerbuilder.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

7 years minimum

Working hours

Regular working hours

Job source

www.careerbuilder.com

Tech stack

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

+19 more

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

Job 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.

Requirements

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