Overview
Remote
Full Time
Part Time
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 6+ mon
Skills
go throgh the JD
Job Details
Position: Data Modeler
Location: Remote
Requirements:
- 10+ years of hands-on data modeling experience in enterprise environments.
- Expert proficiency with Erwin Data Modeler (version 9.x or higher preferred) including subject areas, model templates, and DDL generation.
- Advanced SQL skills and deep understanding of Oracle (11g/12c/19c/21c) and Microsoft SQL Server (2016+).
- Strong command of DDL creating and modifying tables, indexes, constraints, sequences, synonyms, and materialized views.
- Solid grasp of database internals: indexing strategies, partitioning, clustering, and query execution plans.
- Experience with data modeling best practices: normalization, denormalization, surrogate keys, slowly changing dimensions (SCD), and data vault (a plus).
- Familiarity with version control (e.g., Git) and model comparison/diff tools.
- Excellent communication skills ability to document models clearly and present to technical and non-technical audiences.
- Self-Motivated, with an ability to multi-task
- Capable of presenting to all levels of audience
- Experience with Hadoop/MongoDB a plus
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.