Senior Data Analyst with ServiceNow/ETL experience

CanadaOnsiteContractSeniorPosted 2 months ago

Is this role right for you?

Upload your resume and get a skill-by-skill breakdown — see exactly where you match, where you're close, and what to highlight. Not a mystery percentage.

Get a tailored resume highlighting what this role needs.

Role summary

We are seeking a Senior Data Analyst with immediate experience in ServiceNow and ETL processes. The role involves writing complex SQL queries, analyzing data, and investigating root causes for data mapping discrepancies. Responsibilities include profiling legacy data sources, mapping data to ServiceNow's CMDB/CSDM, defining identity and reconciliation rules, designing data ingestion processes, driving data quality through rules and monitoring, and governing data through documentation and controls. The analyst will also validate test cases and facilitate stakeholder decisions. Experience with infrastructure data, application/service modeling, and data governance principles is essential.

Job Description

We are looking for ServiceNow Data analyst immediately with experience in ServiceNow, ETL.

Job Summary:

Senior Data Analyst

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 Cl 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

Ready to apply?

You'll be redirected to COGNITO INC's application page.