Sr.Data Modeler

Responsibilities

• Develop logical and physical data models in traditional data stores (e.g., DB2, Oracle) and NoSQL platforms (e.g., Snowflake, MongoDB).
• Define and enforce data standards, data management standards, and data modeling best practices.
• Manage DDL and database artifacts in GIT and/or Bitbucket.
• Develop, test, and implement scripts, programs, and related processes to collect, manage, and publish DEV and PROD metadata from data models.
• Promote data models into production metadata environments.
• Support DDL implementations.
• Support multiple efforts concurrently using Waterfall, Agile, or Modern Delivery methodologies.
• Develop Visual Basic macros and write SQL queries against databases.
• Design physical database structures in DB2, UDB, Oracle, Sybase, Snowflake, Postgres, MongoDB, and/or SQL Server using ER/Studio or ERwin.
• Utilize ER/Studio Data Architect or ERwin (minimum 4 years experience).
• Work with Collibra Metadata Management Tool.
• Model mortgage/finance industry data using the MISMO Mortgage Data Standard.
• Support XML and JSON schema design and modeling.

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.
• Proficiency in data management standards and data modeling practices.
• Ability to develop Visual Basic macros and write SQL queries.
• Experience designing physical data structures in DB2, UDB, Oracle, Sybase, Snowflake, Postgres, MongoDB, and/or SQL Server using ER/Studio or ERwin.
• Familiarity with version‑control tools such as ClearCase, GIT, and issue‑tracking tools like Remedy.
• Experience with Collibra Metadata Management Tool.
• Mortgage/finance industry data modeling experience, including use of the MISMO Mortgage Data Standard.

About the Company

Stratacent is an IT Managed Services firm headquartered in Jersey City, NJ, with global delivery centres in the New York City area and New Delhi, as well as offices in London, Canada, and Pune, India. The company focuses on Financial Services, Insurance, Healthcare, and Life Sciences, helping customers with digital transformation through cloud infrastructure, containers, AI, client & analytics, and automation. Partnerships include SAS, Automation Anywhere, Snowflake, Azure, AWS, and GCP. More information is available at www.stratacent.com.