Data Modeler

Stratacent; McLean (VA); On-site; USD 140,000 - 160,000; Full time

Job summary

Stratacent seeks a Senior Data Modeler to translate business requirements into robust data models across traditional and NoSQL stores. You will work with DB2, Oracle, Snowflake, and MongoDB, using ER/Studio DA or ERWin, and contribute to metadata management and production deployment.

Requirements include 8–10 years in data modeling, experience with MISMO mortgage standards, XML/JSON schema design, and proficiency in SQL.

Qualifications

• Bachelor’s degree in IT, business, or engineering.
• 8–10 years data modeling and metadata management experience.
• Experience with relational, dimensional and NoSQL data modeling.
• Knowledge of data management standards and model practices.
• Experience with ER/Studio DA or ERWin for data modeling.
• Proven ability to work with mortgage/finance domain data standards.

Responsibilities

• Develop logical and physical data models for diverse data stores.
• Promote data models into production metadata environments.
• Support DDL development and metadata publishing processes.
• Collaborate with teams in Waterfall, Agile, or Modern Delivery.

Skills

SQL

ER/Studio

ERWin

Data modeling

Metadata management

NoSQL

DB2

Oracle

Snowflake

Postgres

Git / Bitbucket

XML/JSON schemas

MISMO Mortgage Data Standard

Education

Bachelor's degree in Business, IT, or Engineering

Tools

ER/Studio DA

ERWin

ClearCase

Remedy

Collibra

Job description

Stratacent is seeking a Sr. Data Modeler will work closely with project teams to understand business requirements and provide data modeling subject matter expertise. Strong quantitative and analytic skills are required.

The Sr. Data Modeler must have experience in:

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

Educational and Work Requirements

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

Additional Qualifications

Proven ability to quickly earn the trust of key stakeholders

Thrives in an environment with changing priorities

Sound business and technical acumen

Focused and versatile team player that is comfortable under pressure

Excellent problem-solving and critical-thinking skills

Able to navigate through a large corporate environment and ensure appropriate processes are met.