Description

You will design and manage data models for ServiceNow CMDB and Snow Mirror environments, ensuring data integrity and reporting accuracy.

Responsibilities

• Design entity relationships, data flows, conceptual/logical data models, and data dictionaries for CMDB.
• Build Snow Mirror databases and manage data replication processes.
• Migrate ServiceNow CMDB data to external databases and map application fields to back-end schemas.
• Write complex SQL and Snowflake queries to join 20+ tables for denormalized reporting layers.
• Perform CMDB data cleaning, validate ER diagrams, and develop analytical layers for BI.

Required Skills

• 5+ years of experience in data modeling and CMDB architecture.
• Expertise in ServiceNow CMDB back-end database schema and relationships.
• Advanced SQL skills for writing complex, multi-table joins.
• Experience with Snowflake and Snow Mirror database configuration.
• Proficiency in AWS and RDS.
• Strong knowledge of CMDB quality, process compliance, and configuration management best practices.
• Ability to map ServiceNow application fields to back-end databases.

Preferred Skills

• Experience working within Agile methodologies.

Key Skills

Education

Any Graduate