Integration and Data Management Analyst

Job Description

Job Description

About Culligan Quench

Culligan Quench’s purpose is to impact people’s lives and improve the earth by helping to eliminate the 500 million plastic bottles consumed each year. We play a front-line role in the battle against single-use plastic water bottles by delivering on-demand filtered water solutions to more than 120,000 healthy and environmentally conscious customers across North America. Our bottle-free water coolers, ice machines, sparkling water dispensers and coffee brewers purify the existing water supply, providing an endless supply of clean water and water-based beverages for a fixed monthly fee, typically under a long term bundled service and rental subscription agreement. Culligan Quench has grown from a small regional company to an international leader that had a successful NYSE public offering in 2016 and is now a strategic company owned by private equity backed Culligan. Headquartered in King of Prussia, PA, Quench has more than 1,600 team members operating out of more than 90 locations across North America and Puerto Rico. For more information visit

About Culligan

There’s nothing more fundamental to life on Earth than water. At Culligan, we believe transforming water can transform the world. That's why we offer expert water services and industry-leading solutions globally. Local Culligan teams deliver better drinking water to people at work, at home and on the go. With expertise across service, science and sustainability, Culligan turns water you can live with into water you can love. For more information visit

Values: 5Cs

Culligan as One

Customers come first

Commitment to Innovation

Courage to do what's right

Consistently deliver exceptional results

Position Summary

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. 

Summary of Key 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 portions of smaller or less complex integrations over time. 

 

AI capability development with IT and process improvement: 

• Partner with IT, integration leadership, and business stakeholders to define, test, and refine AI-enabled capabilities that improve seller data intake, data cleaning, field mapping, exception identification, and seller follow-up workflows. 

• Help translate recurring seller data challenges into practical AI and automation use cases, including document/data extraction, automated validation, anomaly detection, workflow summarization, and integration status reporting. 

• Identify recurring data quality issues and recommend improvements to seller data request templates, validation rules, integration checklists, and standard operating procedures. 

• Support development of reporting and dashboards that track seller responsiveness, data readiness, open seller requests, migration status, exception resolution, customer onboarding, and post-close operating performance. 

• Document AI capability requirements, test results, adoption feedback, and process improvements to help IT scale repeatable integration tools across future acquisitions. 

 

Development path and continuous improvement: 

• Build the functional, technical, and cross-functional integration skills required to progress toward an Associate/Manager of Integration and Data Management role within 12–18 months. 

• Learn Quench’s acquisition integration playbook, system workflows, data standards, and cross-functional operating model through hands-on deal support. 

• Document lessons learned, common seller data challenges, and process improvement opportunities to make future integrations more repeatable and scalable. 

• Contribute insights from data analysis to help improve customer experience, reduce churn risk, support revenue continuity, and increase acquisition synergy value. 

 

Qualifications: 

• 2–4 years of professional experience, including 1–3 years of data analysis, data management, business analysis, system implementation, customer onboarding, or operational project support experience. 

• Strong Microsoft Excel skills, including data queries, pivot tables, LOOKUP functions, data cleaning, reconciliation, and structured file preparation. 

• Working knowledge of SQL, Microsoft Power BI, reporting tools, Salesforce.com, ERP systems, QuickBooks, CRM data, billing systems, or operational data platforms preferred. 

• Experience working with AI-enabled tools, automation, data extraction, workflow improvement, dat