Data Analyst - Senior

Overview

Remote
110000 - 115000
Full Time
No Travel Required
Unable to Provide Sponsorship

Skills

Data Analyst

Job Details

Data Analyst  - Senior

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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.