Data Analyst

We are seeking a Data Governance / Application Inventory Analyst (contract) to support a focused initiative to improve the completeness, accuracy, and governance of our Business Application Inventory (CMDB). This role will partner with Data Governance, CMDB, Enterprise Architecture, and Application SMEs to reconcile application inventories, improve data quality, and standardize application inventory definitions.

Key Responsibilities

1. Data Reconciliation & Analysis

• Reconcile application records across multiple sources (CMDB, vendor systems, EA tools, SSO/discovery datasets)
• Identify missing, duplicate, and mismatched applications
• Perform fuzzy matching and mapping across inconsistent naming conventions
• Analyze gaps and document findings

2. Data Quality Improvement

• Cleanse and normalize application data: o Standardize naming conventions o Align vendor/application relationships o Remove duplicates and resolve conflicts

• Identify and remediate data quality issues (incomplete records, inconsistent fields, misclassification)

• Recommend improvements to data validation rules

3. Application Inventory Definitions

• Apply and help refine inventory definitions
• Support development of an application classification approach
• Categorize applications consistently across inventories

4. CMDB & Inventory Enrichment

• Update and enrich CMDB records with: o Ownership (business owner, technical owner) o Vendor alignment o Classification

• Ensure alignment between CMDB and vendor/application inventory systems

5. Process & Documentation Support

• Document current-state ("as-is") issues in onboarding and recertification processes
• Provide input into future-state ("to-be") process improvements
• Create clear documentation of data rules, definitions, and mapping logic

Core Skills

• Strong data analysis and data cleansing experience

• Experience working with application inventories, CMDBs, or IT asset data

• Proficiency in: o Excel (advanced formulas, pivot tables) o SQL (preferred)

• Experience with data matching, deduplication, and normalization techniques

Data Governance & Domain Knowledge

• Familiarity with: o Data quality management principles o Metadata, taxonomy, and classification frameworks

• Understanding of enterprise application landscapes (SaaS, vendor tools, internal systems)

Tools (any combination of the below)

• Familiarity with: o ServiceNow (CMDB) - strongly preferred o OneTrust or vendor risk platforms - nice to have

• Data tools (Alteryx, Python, Power BI, etc.) - plus

• Experience using AI-assisted tools for data classification is a bonus

Soft Skills

• Strong attention to detail and data accuracy
• Ability to work through ambiguity and incomplete data
• Clear communication and documentation skills
• Ability to engage SMEs and validate assumptions

Preferred Qualifications

• Experience in financial services or regulated environments
• Exposure to application lifecycle or IT governance processes
• Experience supporting data reconciliation or inventory cleanup initiatives 3-6 months Business Application Inventory. 100 tasks with 1000-1500 lines 9-10 Different lists Need to be a Problem Solver Perform Rapid research Perform Fuzzy Matching Excel, Cursor AI, or CoPilot needed