Job Description
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
Job Tags
Hourly pay, Full time, Part time, Seasonal work,
Similar Jobs
Cornerstone Building Brands
...a well-regarded brand portfolio including the #1 position in windows, vinyl siding, metal accessories, metal roofing and wall systems... ...:~12 years of general construction or building material installation experience preferred.~12 years of fenestration...
Menu Pros
_We are looking for a personal virtual assistant who is reliable, available, and a coachable team player who is focused and fluent in written... ..._* _Good verbal skills_* _Excellent multitasking, time management and organizational skills_* _Go getter (ability...
Royal Caribbean Cruises, Inc.
VEHICLE GENERATOR MECHANICThe Vehicle/Generator Mechanic is responsible for the operation and inspection, repair, assessing, diagnosing, and maintaining the main generators and fuel distribution system, the portable generators, engines, and auxiliaries. This position...
Independent Software
...What You Will Do At Independent Software, we understand that proactive security testing is critical to defending mission systems. As a Penetration Tester, you will serve as a subject matter expert in assessing the security of networks, systems, and applications. You...
Stop & Shop
...Category/Area of Expertise: Asset Protection Job Requisition: 470468 Address: USA-NY-New Rochelle-2425 Palmer Ave Store Code: SS - Store Admin (2500440) At Stop & Shop, we've been serving our customers and neighborhoods while taking care of each other for...