ServiceNow Data Analyst (ServiceNow, ETL)

Position Name – ServiceNow Data Analyst

Type of hiring – Fulltime

Location – Remote Canada

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