Back to Jobs
Other

Sr. Data Modeler

Intake IT SolutionsMcLean, VA🇺🇸United States

Why this role stands out

This role offers an exceptional opportunity to advance your expertise in complex data architecture and metadata management within the fast-paced finance industry. You will thrive in this position if you are a detail-oriented professional who excels at designing sophisticated data models and enjoys collaborating with a high-performing team on diverse, impactful projects. Apply today to elevate your career and make a significant contribution to cutting-edge database solutions.

Quick overview

SeniorityMid Senior
Work modeOn Site
LocationMcLean, VA, United States
MongoDBOracleSQLGitSnowflakeWaterfallSQL ServerAgile

Job description

Title: Sr. Data Modeler
Location: Mclean, VA (5 days onsite)

Job Description:
Stratacent is looking for a skilled Data Modeler with strong experience in designing and implementing conceptual, logical, and physical data models using ERwin and ER/Studio.

Responsibilities:

Developing logical and physical data models, in Traditional Data Stores (e.g. DB2, Oracle) and in NoSQL (e.g. Snowflake, MongoDB)
Data standards, data management standards and data modeling best practices
Managing DDL and database artifacts in GIT and/or Bitbucket
Developing, testing, and implementing scripts, programs, and related processes to collect, manage, and publish DEV and PROD metadata from data models
Promoting data models into production metadata environments
Supporting DDL implementations
Supporting multiple efforts concurrently, in Waterfall, Agile or Modern Delivery.
Visual Basic macro development and SQL
SQL Querying of databases
Physical database structure design in DB2, UDB, Oracle, Sybase, Snowflake, Postgres, MongoDB and/or SQL Server using ER/Studio or ERWin
ER/Studio Data Architect or ERWin, minimum 4 years; Collibra Metadata Management Tool
Mortgage/finance industry data modeling; Use of the MISMO Mortgage Data Standard
Supporting XML and JSON Schemas design and modeling

Skills Required:

Bachelor's degree from an accredited university with coursework in Business, Information Technology, or Engineering.
8-10 years of data modeling and metadata management experience.
Experience with relational, dimensional and NoSQL data modeling
Experience with data management standards and data model practices
Experience with query capabilities such as Visual Basic macro development and SQL
Experience with physical data structure design in DB2, UDB, Oracle, Sybase, Snowflake, Postgres, MongoDB and/or SQL Server using ER/Studio DA or Erwin
Experience using ClearCase, GIT, Remedy, ER/Studio DA (Or ERWin)
Mortgage/finance industry data modeling experience

Similar jobs