JUMP TO CONTENT

Sr. IT Data Integration/CCI Specialist

  1. Information Technology (IT)
  2. Full-time

__jobinformationwidget.freetext.LocationText__

Raleigh, NC

Benefits Start Day 1 for Full-Time Colleagues - No Waiting Period!

For more information about our benefits, see below!

We are proud to be a member of the Rentokil family of companies, the global leader in Pest Control and other services across more than 90 countries. We pride ourselves on being a trusted partner to many of the world's leading brands and serve consumer and business customers across multiple industries. We are extremely proud of our legacy of excellence and constantly work to fulfill our mission to "protect people, enhance lives, and preserve the planet."

Job Summary

The Data Integration Specialist is a key technical expert responsible for the hands-on execution of data migrations. This role ensures that data from legacy systems is accurately, efficiently, and securely migrated into the Rentokil Terminix standard application suite (e.g., PestPac/WorkWave). The Specialist collaborates closely with Functional Leads to elicit, document, and validate data mapping and transformation rules. They serve as the primary technical liaison with 3rd-party vendors, execute data reconciliation strategies, and resolve complex data issues identified during testing. This role is critical to mitigating financial and operational risk, upholding data governance standards, and contributing to the development of a scalable, repeatable M&A integration playbook

 

Duties & Responsibilities

  • Collaborates with functional integration leads and business SMEs to elicit, review, and document data requirements, ensuring changes are formalized.

  • Owns and maintains the "rules and requirements" document, ensuring it serves as the single source of truth for all data mapping and transformation logic.

  • Works with functional teams to ensure data mapping documents are completed accurately and on time.

  • Translates complex business requirements into clear, technical specifications for the 3rd party CRM vendor (WorkWave).

  • Defines, documents, and executes the data reconciliation strategy throughout the project lifecycle to ensure data integrity.

  • Acts as the lead technical investigator for data-related issues reported during UAT and warranty/hypercare phases, researching root causes and proposing viable solutions.

  • Serves as a Subject Matter Expert (SME) for the PestPac (WorkWave CRM) application from a data integration and structure perspective.

  • Leads the discovery process for data migrations, asking critical questions to identify unique system configurations or data risks.

  • Manages the end-to-end credit card migration process, including mapping files and coordinating with payment processors (e.g., WorldPay) and vendors.

  • Escalates data-related risks (e.g., quality, timelines, scope) to the Data Integration Manager and provides recommendations for mitigation.

 

Candidate Requirements

 

Education

  • Bachelor's degree in information systems, computer science, business, or related field OR equivalent years of experience. Equivalent years of experience are defined as one year of applicable professional experience for each year of college requested.

 

Experience

  • 2-3 years of experience in a technical data-focused role (e.g., Data Analyst, Business Systems Analyst, ETL Developer).

  • Expertise in using SQL and advanced Excel to profile and reconcile complex datasets, with previous experience querying Snowflake tables considered a significant plus.

  • Proven experience with data migration projects, including data mapping, transformation, and validation.

  • Experience eliciting and documenting complex business and technical requirements. 

  • Hands-on experience with CRM systems (e.g., PestPac, Salesforce) and understanding of relational data models.

  • Experience working with 3rd party vendors on technical deliverables.

  • Prior experience with mergers and acquisitions (M&A) projects is highly preferred. 

  • Experience in data reconciliation and data quality assurance processes.

 

Skills & Competencies

  • Analytical and Detail-Oriented: Strong ability to analyze complex data sets, identify discrepancies, and ensure accuracy.

  • Problem-Solver: Proactive in identifying, researching, and resolving complex data issues. 

  • Structured and Organized: Ability to manage multiple tasks, maintain detailed documentation, and follow established governance processes. 

  • Strong Communicator: Ability to translate complex technical concepts for both business stakeholders and technical vendors, verbally and in writing.

  • Collaborative: Works effectively with cross-functional teams and external partners to achieve common goals.

  • Intellectual Curiosity and Business Acumen: A desire to understand how the business operates and how data supports its functions. 

  • Resilience: Ability to be optimistic and persistent in the face of challenging projects and tight deadlines.

Pay Range $85,600 - $111,200 / year

 

While starting pay falls within the given range, it can vary based on factors like geographic location, skills, education, and experience. Total earnings may also be affected by overtime, incentives, commissions, performance, and route assignment (where applicable).

Why Choose Us?

A career with the Rentokil family of companies can be a professional trajectory filled with opportunity. We pride ourselves on being a world-class team that rewards high performance, and we love to promote from within. We offer competitive pay and many of our roles offer performance incentives.

Below you'll find information about some of what we have to offer. All Full-Time Colleagues qualify for the following and Part-Time Colleagues qualify for most benefits after they meet certain criteria.


Click here to read more about our Total Rewards Program which includes: 

Professional and Personal Growth

  • Multiple avenues to grow your career

  • Training and development programs available

  • Tuition Reimbursement benefits (for FT Colleagues)


Health and Wellness

  • Health benefits including Medical, Dental, Vision, Disability, and Life Insurance plus much more

  • Full-time colleagues are eligible to begin enrollment immediately upon hire with benefits starting on day 1


Savings and Retirement

  • 401(k) retirement plan with company-matching contributions 

 
Work-Life Balance

  • Vacation days & sick days

  • Company-paid holidays & floating holidays

  • A company mindset that prioritizes health, safety, and flexibility


We are looking for individuals who want to make a difference where our customers live and work.  Is that you?
 

This company is a Drug Free workplace.

Rentokil is committed to complying with all Federal, State, and local laws related to the employment of qualified individuals with disabilities.

By applying to this job, you agree to receive initial texts from systems used on behalf of Rentokil North America, Inc., possibly including Workday, Loop, and HireVue. These systems utilize text messages to communicate with you throughout the application, interview, and pre-hire processes. You can set your communication preferences or opt out of text messages from each system at any time following the initial message. Message and data rates may apply.

List #1

Articles you might be interested in

Making a Difference: How Our Teams in Brunei are Restoring the Planet

Teaser

Making A Difference

Content Type

Blog

Publish date

11/28/2025

Summary

🌳 Making a Difference: Planting a Greener Future in BruneiAt Rentokil Initial, our purpose is simple yet vital: Protecting People, Enhancing Lives, and Preserving Our Planet. While our service

Teaser

Beyond Pest Control: Find out how our teams are planting 100 trees in the oldest forest reserves to create a #GreenerFuture.

Read more
From a Six-Month Temp Role to a 30-Year Career Trailblazer

Teaser

Career Development

Content Type

Blog

Publish date

09/11/2025

Summary

Jay Pillay's career story is a powerful testament to how a temporary opportunity can blossom into a lifelong professional growth and success journey. When she joined Rentokil Initial in February

Teaser

Jay Pillay's incredible 30-year journey at Rentokil Initial is a powerful story of how a six-month temporary role can evolve into a fulfilling career.

Read more
Rentokil Initial July 2024 Andy Ransom Quote (Facebook Post)
Delivering Service That Counts, Together

Teaser

The Front line

Content Type

Blog

Publish date

07/01/2025

Summary

At Rentokil Initial, we know that true excellence isn't just about what we do, but how we do it. It's about the connections we build, the support we offer each other, and the shared comm

Teaser

Are you ready to be part of a team where your service counts and your contributions are appreciated?

Read more
A white ice cream van with "Rentokil Initial" branding serves a smiling person, while a queue forms on a sunny street in London, celebrating the company's 100-year anniversary.
Sweet Treats & Pest Control: How We Kicked Off Our 100th-Year Anniversary in the UK

Teaser

Company update

Content Type

Blog

Publish date

06/16/2025

Summary

Who knew pest control could be so sweet? At Rentokil Initial, we love to celebrate, and what better way to kick off our monumental 100th anniversary than with a truly unique and deliciously surp

Teaser

Discover how Rentokil Initial UK celebrated its 100th anniversary with an unexpected treat!

Read more
Black and white photo of four women working with early office machinery, possibly accounting or computing machines, in a Rentokil office from an earlier era, with 'Rentokil 100 Years' logo overlaid.
A Century of Impact: Celebrating 100 Years of Innovation and Opportunity at Rentokil

Teaser

Company update

Content Type

Blog

Publish date

06/05/2025

Summary

A Century of Impact: Celebrating 100 Years of Innovation and Opportunity at RentokilWe have marked a monumental milestone for Rentokil – our 100th anniversary! For a century, we've been at the

Teaser

Join us as we celebrate a century of leading pest control innovation, global growth, and impactful careers. Discover how you can be part of our future

Read more
Louis, posing in front of our reception at Rentokil Initial headquarters
Living Our Values: Louis's Career Journey at Rentokil Initial

Teaser

Our Values in Action

Content Type

Blog

Publish date

03/20/2025

Summary

Learn, Grow, and Thrive: Louis's Career Journey at Rentokil Initial We recently sat down with Louis, a Learning Content Developer from our Group HR - Learning and Development team, to hear a

Teaser

Want to know what it's really like to work at Rentokil Initial? Join us as we chat with Louis from our Learning and Development team about his inspiring career journey and how our values come to life.

Read more
A picture of Sarah Lane, a young white female with blonde hair, in her early twenties smiling in front of the Rentokil Initial Logo
Life at Rentokil Initial: A New Starter's Journey

Teaser

Company update

Content Type

Blog

Publish date

01/02/2025

Summary

Starting a new job can be exciting and nerve-wracking, but Rentokil Initial strives to create an experience filled with support, growth, and a welcoming atmosphere. Take it from Sarah Lane, one of

Teaser

Get the inside scoop from Sarah on what it's REALLY like to join our team!

Read more
An image of a white female with brown shoulder length hair, smiling warmly
Want a Career at Rentokil Initial? Here's the Inside Scoop from Our Recruitment Manager

Teaser

Career Pathways

Content Type

Blog

Publish date

12/11/2024

Summary

Landing your dream job can be tricky. Acing that application? Even tougher! But don't worry, we're here to help. We sat down with Jo Sharpe, one of our top Recruitment Managers, to get the insid

Teaser

Want the inside scoop on how to land a job at Rentokil Initial? Our Recruitment Manager spills the secrets!

Read more
Sam Schader I.T Director at Rentokil-Initial
From Graduate to IT Director: Follow Sam's Journey

Teaser

Company update

Content Type

Living RI

Publish date

04/08/2024

Summary

Sam Schrader is the UKIB Region & Corporate Functions IT Director at Rentokil Initial. She first joined Rentokil Initial as a graduate student in the RI Management program in April 2005, where

Teaser

Read about Sam Schrader's fantastic journey from a new graduate to becoming the IT Director at Rentokil Initial. Sam's story shows us how learning from others, trying out different jobs, and always being willing to learn can lead to great success in the IT and business industry. Explore her story to see what it takes to build a successful career.

Read more
Person typing on a keyboard and tapping a futuristic illustration of people icons
Unveiling our new careers site!

Teaser

Company update

Content Type

News

Publish date

11/29/2023

Summary

We are thrilled to announce the launch of our brand-new career site, a platform designed to help you find the perfect job at Rentokil Initial and showcase our vision and values. Why the c

Teaser

We are thrilled to announce the launch of our brand-new career site, a platform designed to help you find the perfect job at Rentokil Initial and showcase our vision and values.

Read more

Search

Browse Jobs