ESM Architect

Role/Title: ServiceNow Senior Developer

Location: Denver, CO

 

Role purpose:

 

Provide subject-matter expertise for ServiceNow, recovering its true business entities and process flows and delivering reliable, well-governed API-based extraction into the Bronze layer for onward modelling to Gold.

 

Key responsibilities:

 

• Document the ServiceNow data model (CMDB, incident, change, request, task, CI relationships) as configured at Client Side.
• Reconstruct the underlying business processes — ITSM/ITIL flows in ServiceNow — and document where customization has altered standard behavior.
• Design and specify API-based extraction patterns, addressing incremental/CDC extraction, pagination, rate and API limits, bulk interfaces, authentication, and deleted-record handling.
• Produce Bronze → Silver → Gold source-to-target mappings, including picklist and reference-data normalization and documented data-quality defects.
• Define ServiceNow's contribution to DNA crosswalk keys (Customer/Account, Site, Asset/CI, Employee) and resolve identifier conflicts across systems.
• Define data-quality gates and confidence scoring for service-management KPIs and steward them through certification.
• Support pipeline development, observability, and automated testing for the ServiceNow source system.

 

Required qualifications and experience:

 

• 5+ years with ServiceNow in a data, integration, or platform capacity, with genuine hands-on depth.
• Practical experience with the ServiceNow Table and REST APIs, including rate-limit management.
• Demonstrated ability to design reliable incremental extraction from SaaS platforms into a data lake or warehouse.
• Strong SQL and data-profiling skills; ability to reverse-engineer heavily customized SaaS configurations.
• Understanding of ITSM/CMDB practice.

 

Preferred qualifications:

 

• ServiceNow platform certifications.
• Experience with Fabric, Databricks, Azure Data Factory or comparable ingestion tooling.
• CMDB governance or CI data-quality remediation experience.
• Familiarity with Microsoft Purview or comparable catalog tooling.
• Programme deliverables owned
• ServiceNow entity and process-flow documentation.
• API extraction design and specification for ServiceNow.
• Source-to-target mapping specifications and DNA key contributions.
• Service-management KPI definitions and certification evidence.