CMDB Data Analyst

Top responsibilities
Write complex SQL queries to pull data and analyze results. (DoD App Retirement specific)
Find cases and investigate root causes when one record from data source maps to multiple records in ServiceNow and vice-versa.
Profile legacy sources: schema/PK-FK, volumes/frequency, lineage, owners, and data issues.
Map to CMDB/CSDM: place entities into correct CI classes/relationships; align lifecycle and environments.
Define identity and reconciliation: coalesce keys, dedupe/survivorship, reference resolution.
Design ingestion: Import Sets/Transform Maps, IntegrationHub ETL, MID/JDBC/API, idempotent schedules.
Drive data quality: DQ rules/KPIs, CMDB Health monitoring, remediation workflow.
Govern and document: RACI, data contracts, naming/taxonomy, domain separation/ACLs, attestations.
Validate and sign off: test cases, reconciliation counts, negative tests, rollback plan; facilitate stakeholder decisions.

Top skills
ServiceNow CMDB/CSDM
CSDM modeling; core CMDB tables/relationships.
Identification & Reconciliation, CMDB Health; Import Sets/Transform Maps/Coalesce; IntegrationHub ETL/Flow Designer
Data
SQL; profiling and normalization; reference data management.
ETL/ELT patterns, idempotency, dedupe/survivorship; JSON/CSV/XML; REST familiarity.
Domain
Infra (servers/VMs/containers/network/storage); cloud resource models and tagging.
Application vs service modeling and dependencies.
Governance
Naming/taxonomy; DQ KPIs; ownership/stewardship; audit/change controls; privacy basics (PII/SOX/PCI).
Soft skills
Stakeholder interviewing/facilitation; concise documentation/visuals; analytical, hypothesis-driven thinking.
Nice-to-haves
BI dashboards (Power BI), telecom/OSS/BSS familiarity