ServiceNow Data Analyst
Role summary
We are seeking a full-time, remote ServiceNow Data Analyst to join our team immediately. The role involves writing complex SQL queries, investigating data discrepancies, and profiling legacy data sources. Key responsibilities include mapping data to CMDB/CSDM, defining identity and reconciliation rules, designing data ingestion processes using tools like Import Sets and IntegrationHub ETL, driving data quality initiatives, and governing data through documentation and controls. The analyst will also be responsible for validating data and facilitating stakeholder decisions. Experience with ETL/ELT patterns, data governance, and infrastructure domain knowledge is essential.
Position Name – ServiceNow Data Analyst
Type of hiring – Fulltime
Location – Remote Canada
We are looking for Data Analyst immediately with experience in ServiceNow, ETL.
Job Description:
Top responsibilities
- 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.
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
