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
Titan Placement Group
...Family Nurse Practitioner (FNP) Family Nurse Practitioner needed in Shenandoah, PA Titan Placement Group invites you a charming city that is known as the Kielbasi Capital of Eastern Coast. Best known for this Eastern European specialty are Capital Food Store, Lucky...
Texas A&M University
...Job Title Postdoctoral Research Associate Agency Texas A&M University Department Psychology Proposed Minimum Salary Commensurate Job Location College Station, Texas Job Type Staff Job Description Here's a Glimpse of the Job The...
Programmers.io
...communication, and regulatory compliance. Collaborate with cross-functional teams to understand business requirements and deliver data-driven solutions. Communicate findings and recommendations through reports, dashboards, and presentations. Work with data...
TSMG
A drone services company in New York is looking for a skilled Drone Pilot to manage aerial operations for various projects. The ideal candidate should possess an EASA certification and have proven experience in drone operation. Key responsibilities include flying drones...
The Ohio State University Wexner Medical Center
Screen reader users may encounter difficulty with this site. For assistance with applying, please contact ****@*****.***. If you have questions while submitting an application, please review these frequently asked questions. Current Employees And Students...