Sr. IT Data Integration/CCI Specialist jobs in United States
cer-icon
Apply on Employer Site
company-logo

Terminix · 9 hours ago

Sr. IT Data Integration/CCI Specialist

Terminix, a member of the Rentokil family of companies, is a global leader in Pest Control and other services. The Data Integration Specialist is responsible for the execution of data migrations, ensuring accurate and secure data transfer into the Rentokil Terminix application suite while collaborating with functional leads and serving as a liaison with vendors.

Building MaintenanceCommercialConsumerFacilities Support ServicesHome ServicesProfessional ServicesService Industry
check
H1B Sponsor Likelynote

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

Qualification

SQLData migrationData mappingCRM systemsData reconciliationAnalytical skillsProblem-solvingCommunicationCollaborationOrganizational skills

Required

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
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
Experience in data reconciliation and data quality assurance processes

Preferred

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

Benefits

Multiple avenues to grow your career
Training and development programs available
Tuition Reimbursement benefits (for FT Colleagues)
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
401(k) retirement plan with company-matching contributions
Vacation days & sick days
Company-paid holidays & floating holidays
A company mindset that prioritizes health, safety, and flexibility

Company

Terminix

company-logo
Terminix specializes in providing residential and commercial pest control.

H1B Sponsorship

Terminix has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2021 (1)
2020 (5)

Funding

Current Stage
Late Stage
Total Funding
unknown
2021-12-14Acquired

Leadership Team

leader-logo
Mark Freeman
Chief Customer Officer
linkedin
Company data provided by crunchbase