Sr.Data Modeler

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

• Developing logical and physical data models in traditional data stores (e.g. DB2, Oracle) and in No
  
  SQL (e.g. Snowflake, Mongo
  
  DB)
• Adhering to 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, Mongo
  
  DB and/or SQL Server using ER/Studio or ERWin
• Experience with ER/Studio Data Architect or ERWin, minimum 4 years; experience with Collibra Metadata Management Tool
• Mortgage/finance industry data modeling using the MISMO Mortgage Data Standard
• Supporting XML and JSON schema design and modeling

• 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 No
  
  SQL data modeling.
• Experience with data management standards and data modeling 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, Mongo
  
  DB and/or SQL Server using ER/Studio DA or ERWin.
• Experience using Clear Case, GIT, Remedy, ER/Studio DA (or ERWin).
• Mortgage/finance industry data modeling experience.

• 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.

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.