ServiceNow Data Analyst jobs in United States
cer-icon
Apply on Employer Site
company-logo

CoreTek Labs · 1 day ago

ServiceNow Data Analyst

positionUnited States
timeContract
remoteRemote
senioritySenior Level, Lead/Staff
date12+ years exp

CoreTek Labs is seeking a Senior ServiceNow Data Analyst to support data analysis and management within their organization. The role involves writing complex SQL queries, investigating data discrepancies, and ensuring data quality and governance in ServiceNow environments.

Computer Software
badNo H1Bnote
Hiring Manager
Podila Satish
linkedin

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

Qualification

ServiceNow CMDB/CSDMSQLETL/ELT patternsData profilingGovernanceStakeholder interviewingAnalytical thinkingJSON/CSV/XML familiarityPower BIConcise documentation

Required

12+ Years of experience
Only H1B Visa holder – PP number is mandatory
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, 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
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

Preferred

BI dashboards (Power BI)
telecom/OSS/BSS familiarity

Company

CoreTek Labs

twittertwitter
company-logo
CoreTek Labs that specializes in Project Management, Product Engineering, Technology Consulting & Staff Augmentation.
dateFounded in 2021
location
Wilmington, Delaware, USA
people-size51-200 employees
web-link
https://www.coretek.io/

Funding

Current Stage
Growth Stage

Leadership Team

leader-logo
Pradeep Kanneganti
CEO and Founder
linkedin
Company data provided by crunchbase