CoreTek Labs · 5 hours ago
ServiceNow Data Analyst
CoreTek Labs is seeking a ServiceNow Data Analyst to manage and analyze data within the ServiceNow platform. The role involves writing complex SQL queries, investigating data discrepancies, and ensuring data quality and governance across various systems.
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, Integration Hub 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
Qualification
Required
Write complex SQL queries to pull data and analyze results
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, Integration Hub 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
ServiceNow CMDB/CSDM
CSDM modelling; core CMDB tables/relationships
Identification & Reconciliation, CMDB Health; Import Sets/Transform Maps/Coalesce; Integration Hub ETL/Flow Designer
SQL; profiling and normalization; reference data management
ETL/ELT patterns, idempotency, dedupe/survivorship; JSON/CSV/XML; REST familiarity
Infra (servers/VMs/containers/network/storage); cloud resource models and tagging
Application vs service modelling and dependencies
Naming/taxonomy; DQ KPIs; ownership/stewardship; audit/change controls; privacy basics (PII/SOX/PCI)
Preferred
BI dashboards (Power BI)
telecom/OSS/BSS familiarity
Company
CoreTek Labs
CoreTek Labs that specializes in Project Management, Product Engineering, Technology Consulting & Staff Augmentation.
H1B Sponsorship
CoreTek Labs has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (19)
2024 (26)
2023 (16)
Funding
Current Stage
Growth StageCompany data provided by crunchbase