Integration and Data Management Analyst
About the role
Culligan Quench continues to grow through acquisition, requiring accurate and timely integration of acquired customer, contract, billing, service, route, asset, pricing, and operational data into core systems and workflows. The Integration and Data Management Analyst, Mergers & Acquisitions is a hands-on role designed for a high-potential analyst who will support acquisition integration execution while developing the skills required to progress into a broader integration leadership role within 12-18 months of hire. This role works directly with seller parties before closing and serves as a primary day-to-day coordination point for seller data collaboration. The Analyst will help sellers understand data requirements, required file formats, submission timelines, and issue-resolution needs while collecting, clarifying, validating, cleaning, normalizing, and mapping required data for due diligence analysis, Day 1 readiness, and ingestion into Culligan Quench systems. The Analyst will support the development and refinement of seller data files, including the seller flat file, and help ensure that acquired customers are onboarded accurately with minimal disruption to billing, service delivery, customer support, and sales assignment processes. The right candidate will combine data fluency, operational discipline, strong seller-facing communication skills, and curiosity about AI-enabled process improvement. This individual will work closely with IT and integration leadership to develop practical AI capabilities that improve seller data intake, automated validation, field mapping, exception identification, workflow summarization, and integration status reporting. Over time, these capabilities should reduce manual effort, improve data quality, accelerate seller follow-up, and make the integration process more repeatable and scalable.
Skills
Strong data fluency across the full integration lifecycle - collecting, clarifying, cleaning, normalizing, mapping, validating, and reconciling seller data from multiple source systems and templates. Confident and professional seller-facing communication as the primary day-to-day collaboration point - setting data requirements, file formats, and submission timelines, running structured follow-up routines. Comfort working with imperfect, inconsistent data from multiple seller systems, using disciplined validation and exception management to drive files to Day 1 readiness. Strong Excel and data preparation skills, with the ability to use templates, trackers, dashboards, AI-enabled tools, and automation to support integration readiness. Ability to maintain monthly KPI reporting, identify data quality trends, and provide clear updates on seller responsiveness, open requests, exception aging, migration progress, and integration readiness. Strong ownership, organization, and follow-through in a deadline-driven M&A environment, with the learning agility to progress toward a broader integration leadership role within 12-18 months.
Responsibilities
Seller Collaboration, Data Collection, And Integration Support Serve as a primary working contact for sellers during data collection, helping them understand integration requirements, data templates, file formats, timing expectations, and open issue resolution. Work directly and collaboratively with sellers to collect customer, contract, billing, service, route, asset, pricing, and operational data required for diligence and integration planning. Lead seller data follow-up routines by tracking open items, clarifying data definitions, resolving inconsistencies, coordinating responses, and escalating blockers that could impact Day 1 readiness. Validate seller-provided data for completeness, consistency, and usability, partnering with sellers to close gaps and improve file quality before migration. Prepare, clean, normalize, and map seller data into Quench integration templates to support upload into Qforce, ERP, billing, service, and reporting systems. Operational Execution And Day 1 Readiness Support acquisition integration workstreams by preparing seller data for ingestion and coordinating with IT, Finance, Customer Care, Field Operations, Billing, and Sales teams. Assist in building and maintaining our integration trackers, issue logs, data readiness checklists, and cutover materials to support accurate and timely Day 1 execution. Partner with project managers and senior integration team members to identify data-related risks, resolve exceptions, and document decisions impacting customer onboarding, billing, service, and support. Help test and reconcile migrated data to confirm that customer accounts, equipment, routes, pricing, billing schedules, and service requirements are accurately reflected in Quench systems. Develop working knowledge of Quench systems and integration processes to independently manage defined port