Senior Data Modeler & Architect (ERwin/ER/Studio)

Stratacent; McLean (VA); On-site; USD 110,000 - 150,000; Full time

Job summary

Stratacent is seeking a skilled Data Modeler to design and implement conceptual, logical, and physical data models across traditional data stores and NoSQL, using ERwin and ER/Studio. This role emphasizes data standards and metadata management in a fast-paced IT services environment.

You will collaborate across teams, manage DDL in Git/Bitbucket, and work in Waterfall or Agile, with mortgage/finance data modeling experience preferred. Strong SQL and VB macro development are expected.

Qualifications

• Bachelor's degree 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.

Responsibilities

• Develop logical and physical data models for traditional data stores and NoSQL.
• 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

Data modeling

Metadata management

ERwin

ER/Studio

SQL

NoSQL data modeling

DB2

Oracle

GIT/Bitbucket

Mortgage/finance domain

XML/JSON schemas design

VB macro

Education

Bachelor's degree

Tools

ERWin

ER/Studio

Collibra

ClearCase

Git

Remedy

Job description

Stratacent is seeking a skilled Data Modeler to design and implement conceptual, logical, and physical data models across traditional data stores and NoSQL, using ERwin and ER/Studio. This role emphasizes data standards and metadata management in a fast-paced IT services environment.

You will collaborate across teams, manage DDL in Git/Bitbucket, and work in Waterfall or Agile, with mortgage/finance data modeling experience preferred. Strong SQL and VB macro development are expected.