Sr.Data Modeler
About The Position
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. This role involves developing and managing data models, promoting them into production metadata environments, and supporting DDL implementations across various delivery methodologies. The position requires expertise in relational, dimensional, and NoSQL data modeling, as well as experience with data management standards and best practices. The Data Modeler will also be involved in script development, metadata management, and supporting multiple concurrent efforts.
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
Nice To Haves
- ER/Studio Data Architect or ERWin, minimum 4 years
- Collibra Metadata Management Tool
- Use of the MISMO Mortgage Data Standard
Responsibilities
- Developing logical and physical data models, in Traditional Data Stores (e.g. DB2, Oracle) and in NoSQL (e.g. Snowflake, MongoDB)
- Defining 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
- Supporting XML and JSON Schemas design and modeling
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
