Data Analyst, Business-Facing, Data Prep

November 22

Apply Now

Receive Emails with Similar Jobs

CompassX Group

WebsiteLinkedInAll Job Openings

B2B • Consulting • Technology

CompassX Group is a business and technology consulting firm that specializes in delivering services across several sectors including financial services, healthcare, life sciences, and consumer discretionary. Their expertise includes technology advisory, data solutions, business resiliency, and agile product evolution, helping organizations to implement effective strategies and improve operational efficiencies.

11 - 50 employees

Founded 2009

🤝 B2B

📋 Description

• Data Collection and Cleansing: Collect and extract data from diverse sources such as Excel, SharePoint Lists, and shadow IT systems to support the SAM module and AI training pools. • Source Data Validation: Apply quality assurance by validating datasets with ServiceNow import/export and analysis tools for accuracy, consistency, and completeness before platform ingestion. • Shadow IT Data Capture: Identify, document, and collect data from shadow IT to ensure a full inventory for Application Portfolio Management and SAM. • Application Cataloging: Define necessary metadata and attribute data to support initial application cataloging within the SAM module. • Requirements Gathering: Lead targeted sessions with IT, Finance, and Asset Management stakeholders to establish business logic, compliance rules, and reporting needs for ServiceNow SAM. • AI Ticketing Data Specification: Specify requirements for structure, volume, and quality of historical ticket data to train and validate the AI Ticketing Agent model. • Data Flow and Mapping: Develop source-to-target mapping and transformation logic for data integration, ensuring new ServiceNow modules align with master data definitions. • Platform Stabilization: Support the initial build-out and stabilization of new data platforms and transition processes to the internal team upon completion.

🎯 Requirements

• Strong proficiency in Excel (for manual data prep) and Lucidchart (for diagrams). • You must be able to operate at a fast pace. The team is tenacious and focused on getting things done, so being proactive and a bias to action. • Experience with SQL/Power BI and other data tools is highly desirable but may not be needed on Day 1. • Experience with ServiceNow import/export and data profiling proficiency is highly desirable. • Strong business process documentation and requirements writing capabilities. • Ability to gather requirements and lead sessions with a variety of business stakeholders. • Understanding of data attributes, relationships, and hygiene, even if you aren't writing complex code all day. • Excellent communication skills for documentation and knowledge transfer.