The Data Analyst will collect and cleanse data, validate datasets, capture shadow IT data, catalog applications, gather requirements, specify AI ticketing data needs, and support platform stabilization while ensuring process documentation and knowledge transfer.
CompassX is a boutique business and technology consulting firm. We help Fortune 500 and high-growth clients deliver their most strategic initiatives, from enterprise transformations to digital and data-driven projects. With over 15 years of proven results, we’ve expanded across industries including financial services, pharmaceuticals, aerospace, consumer products, and quick service restaurants.
We are honored to be recognized as a three-time winner of Consulting Magazine’s Best Boutique Firms to Work For, and previously recognized as a “Best Place to Work” in Southern California and one of INC.’s 5000 fastest-growing private companies in the U.S.
We are seeking a Data Analyst who has strong Business Analytical skills to support one of our Technology companies. This resource acts as the functional and data bridge required to successfully integrate the ServiceNow Software Asset Management (SAM) module and lay the data groundwork for the AI Ticketing Agent. The role is highly operational and data-intensive. This is an ideal role for someone who thrives at the intersection of data analytics and business analytics
What You'll Do
- 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.
- Knowledge Transfer: Document and transfer all processes, data mappings, and quality checks to the long-term operational team.
What We're Looking for
- Power Bi and advanced Excel skills and experience with SharePoint Lists.
- ServiceNow import/export and data profiling proficiency.
- SQL skills and experience with some experience in QA and validation methodologies.
- Strong business process documentation and requirements writing capabilities.
- Experience with technical inventories, including application cataloging and metadata definition.
- Ability to gather requirements and lead sessions with a variety of business stakeholders.
- Understanding of data integration, source-to-target mapping, and transformation logic.
- Track record of hands-on data operations in fast-changing or temporary environments.
- Excellent communication skills for documentation and knowledge transfer.
- Experience working within global or matrixed enterprise environments
Our consultants say CompassX is a place where they can truly find their own path. As part of a smaller firm, they see the impact of their work, have an identity, and know their voice matters. They value the freedom to take the reins of their careers, shape their client work, and maintain a direct line to leadership.
With CompassX’s focus on serving local Southern California clients, consultants not only build lasting relationships but also see the results of their work in the communities where they live.
At CompassX, you won’t just follow a path - you’ll create one.
Top Skills
Excel
Power BI
Servicenow
Sharepoint
SQL
Similar Jobs
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
The Solution Sales Executive leads market success for IT Workflows products, strategizes territory planning, coaches AEs, and supports customer digital transformation.
Top Skills:
Ai-Enhanced TechnologyCloud-Based Platform
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
This role involves generating new SaaS business sales revenue, building relationships with C-suite executives, and executing account strategies.
Top Skills:
AISaaS
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
The Sr. Business Process Consultant will lead customer engagements in implementing and optimizing Risk & Resilience solutions within ServiceNow, focusing on business process improvement and stakeholder collaboration.
Top Skills:
PowerPointRisk & ResilienceServicenowVisioWord
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
