Sr.Data Modeler

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

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

About Us:

Stratacent is an IT Managed Services firm, headquartered in Jersey City, NJ, with two global delivery centres in New York City area and New Delhi area plus offices in London, Canada and Pune, India.

We are a leading IT services provider focusing in Financial Services, Insurance, Healthcare and Life Sciences. We help our customers in their digital transformation journey and provide solutions around cloud infrastructure, containers, AI, Client & Analytics and Automation.

We have partnerships with SAS, Automation Anywhere, Snowflake, Azure, AWS and GCP.

(To learn more: www.stratacent.com).

Stratacent is an equal opportunity employer. As such, to the extent defined by federal, state, and municipal law, Stratacent will not discriminate against any employee or applicant for employment on the basis of race, color, creed, religion, age, sex, national origin, ancestry, handicap, or any other factor protected by law.