Senior Data Integration Specialist

3 weeks ago


Exton, Pennsylvania, United States Spinnaker Search Group, LLC Full time

We are partnering with a leading end-to-end supply chain and manufacturing company to find a Senior Data Integration Specialist for their growing team. This company has experienced significant growth through strategic acquisitions and is looking for a skilled professional to lead their data integration efforts. This position offers a unique opportunity to define and lead the processes for integrating data from acquired companies' systems into the standard systems of our client's environment. The role focuses on developing repeatable, scalable, and expeditious methods for data conversion and integration.

This is a full-time, Direct-Hire position that will work on a hybrid basis (3 days per week on-site) out of their location in Exton, PA.

The Role You'll Play

As the Senior Data Integration Specialist, you'll be responsible for all aspects of data conversion and integration. Your key responsibilities will include:

  • Performing analyses of varied source and target systems and their data models to facilitate effective data extraction, transformation, and loading from legacy systems to go-forward systems.
  • Collaborating with Business Analysts and Solution Architects for identifying and documenting data conversion requirements.
  • Strategizing and designing methods for effective, reusable, and repeatable data conversion processes.
  • Working closely with the IT development organization to implement data conversion designs.
  • Participating in the execution and testing of defined data conversion processes.
  • Identifying and solving data anomalies.
  • Collaborating with stakeholders to understand data elements and perform data validation resulting from conversion activities.
  • Defining and continuously improving data conversion processes, best practices, and methodologies.
  • Developing business acumen related to Master Data, Transactional Data, and general business processing to enable effective discussions with non-technical personnel.
  • Assisting in defining data conversion project tasks and timelines, and executing against them.

Background Profile

The ideal candidate will possess a strong blend of technical expertise and business acumen, with a focus on data integration and conversion. Key qualifications include:

  • Bachelor's degree in Computer Science, Information Systems, or related field.
  • Minimum of 5 years of experience performing data extraction, transformation, and loading from legacy systems to go-forward systems.
  • Solid ability to dissect large and small relational databases and understand relationships between tables.
  • Proven leadership experience in designing and performing data conversions from varied source systems/files, including ERP, Accounting, Customer Relationship, Manufacturing, and Warehouse and Transportation Management Systems.
  • Technical skills including:
  • AS/400 based ERP (preferably S2K, JDA, or similar)
  • Exceptional Database Structure knowledge and Database Management
  • Strong knowledge of SQL and ability to write complex queries (T-SQL)
  • Strong experience with SSIS or other ETL tool (with a deep understanding of the ETL process)
  • Experience with ftp/sftp
  • Proficiency in Access, FileMaker, Excel, XML, Java, or similar technologies
  • Exceptional problem-solving abilities and attention to detail.
  • IT experience in Distribution and/or Manufacturing industries is highly desirable
  • Strong written and verbal communication skills, able to describe complex problems and solutions in simple terms.
  • Ability to consider upstream and downstream process impacts and implications.
  • Proven ability to execute swiftly without compromising quality.
  • Experience in a virtual work environment, requiring high levels of independence and self-motivation.

Other Competencies

  • Change Management: Ability to personally adapt and lead change effectively within an evolving professional environment.
  • Knowledge Sharing: Willingness to continually educate and update business functions and IT departments.
  • Business Savvy: Ability to speak in business terms, translating technical concepts into business terminology.
  • Service Mindset: Excellent customer service skills, real-time communication, and ability to simplify complex concepts.


  • Exton, Pennsylvania, United States AmerCareRoyal Full time

    Job Title: Senior Data Integration SpecialistAbout the Role:AmerCareRoyal is seeking a highly skilled Senior Data Integration Specialist to join our team. As a key member of our IT department, you will be responsible for designing and implementing data integration solutions that meet the needs of our business units.Key Responsibilities:* Perform analyses of...


  • Exton, Pennsylvania, United States Spinnaker Search Full time

    We are partnering with a leading end-to-end supply chain and manufacturing company to find a Senior Data Integration Specialist for their growing team.This company has experienced significant growth through strategic acquisitions and is looking for a skilled professional to lead their data integration efforts.This position offers a unique opportunity to...


  • Exton, Pennsylvania, United States AmerCareRoyal Full time

    Job SummaryAmerCareRoyal is seeking a highly skilled Senior Data Integration Specialist to join our team. As a key member of our IT organization, you will be responsible for defining and leading end-to-end data integration processes to bring data from acquired companies' systems into our standard systems. Your expertise in data conversion planning,...


  • Exton, Pennsylvania, United States Spinnaker Search Group, LLC Full time

    Senior Data Integration EngineerWe are partnering with a leading end-to-end supply chain and manufacturing company to find a Senior Data Integration Engineer for their growing team. This company has experienced significant growth through strategic acquisitions and is looking for a skilled professional to lead their data integration efforts.This position...


  • Exton, Pennsylvania, United States AmerCareRoyal Full time

    Job SummaryWe are seeking a highly skilled Senior Data Integration Engineer to join our team at AmerCareRoyal. As a key member of our IT department, you will be responsible for designing and implementing data conversion processes to integrate data from acquired companies' systems into our standard ACR defined systems.Key Responsibilities:Perform analyses of...


  • Exton, Pennsylvania, United States Frontage Laboratories Full time

    Job SummaryFrontage Laboratories is seeking a highly skilled Data Management Specialist to manage data transfers between our company and clients, as well as internal reporting from data systems. The ideal candidate will have a strong understanding of company SOPs and relevant regulations.Key Responsibilities:Participate in project meetings to understand...


  • Exton, Pennsylvania, United States Zenith LifeScience Full time

    Job Title: Senior Quality Assurance SpecialistWe are seeking a highly skilled Raw Materials Expert to join our team at Zenith LifeScience. As a Senior Quality Assurance Specialist, you will be responsible for ensuring the quality and suitability of raw materials for our production processes.This role involves working closely with cross-functional teams to...


  • Exton, Pennsylvania, United States West Pharmaceutical Services Full time

    Job SummaryWe are seeking a highly skilled Senior Engineer to join our R&D team at West Pharmaceutical Services. As a key member of our team, you will be responsible for designing and developing innovative medical devices, collaborating with cross-functional teams, and driving process efficiency.Key ResponsibilitiesPlan and execute projects through all...


  • Exton, Pennsylvania, United States West Pharmaceutical Services Full time

    Job SummaryThe Senior Technical Site Support Specialist will work collaboratively with the regional and global D&T team to maintain all aspects of the site's infrastructure, end-user device functionality, and workload prioritization in line with documented procedures while adhering to all corporate guidelines.This role demands a blend of technical expertise,...


  • Exton, Pennsylvania, United States West Pharmaceutical Services Full time

    About the RoleWe are seeking a highly skilled Senior Engineer to join our R&D team at West Pharmaceutical Services. As a key member of our team, you will be responsible for designing and developing innovative solutions for our integrated systems.Key ResponsibilitiesPlan and execute projects through all phases, with a focus on design and qualification through...


  • Exton, Pennsylvania, United States AXA Group Full time

    About the RoleWe are seeking a highly skilled Infrastructure Operations Specialist to join our team at AXA Group Operations. As a key member of our Workplace Virtualisation team, you will be responsible for providing specialist technical capability and delivery of virtual desktop infrastructure.Key ResponsibilitiesDesign, integration, and delivery of new and...


  • Exton, Pennsylvania, United States United Safety and Survivability Corporation Full time

    Job Description:United Safety and Survivability Corporation is committed to delivering the most innovative and reliable safety and survivability solutions our customers can trust to protect life and property. Currently, we're seeking a highly skilled Senior Lean Transformation Specialist to join our team.Key Responsibilities:Develop and deploy the Lean...


  • Exton, Pennsylvania, United States Frontage Laboratories Full time

    Job Title: Senior IT Strategy and Portfolio ManagerFrontage Laboratories is seeking a Senior IT Strategy and Portfolio Manager to provide organizational, operational, and strategic leadership to align IT strategy with business strategy to support business growth by enhancing and effectively leveraging the organization's technology platforms, leading...


  • Exton, Pennsylvania, United States Frontage Laboratories Full time

    Job Title: Senior IT Strategy and Portfolio ManagerFrontage Laboratories is seeking a Senior IT Strategy and Portfolio Manager to provide organizational, operational, and strategic leadership to align IT strategy with business strategy and support business growth by enhancing and effectively leveraging the organization's technology platforms, leading...

  • Senior IS Developer

    3 weeks ago


    Exton, Pennsylvania, United States Convergix Automation Full time

    Job DescriptionConvergix Automation Solutions is seeking a highly skilled Senior IS Developer to join our team. As a key member of our development team, you will be responsible for designing, developing, and implementing innovative information systems solutions for our clients.Key Responsibilities:Design and develop complex software systems for...


  • Exton, Pennsylvania, United States Joulé Full time

    Job Summary: We are seeking a highly experienced Senior Quality Control Manager to lead our Quality Control team. The ideal candidate will have a strong background in Quality Control, with a minimum of 10 years of experience in the biologics industry. The successful candidate will be responsible for managing a staff of Quality Control analysts and...


  • Exton, Pennsylvania, United States Frontage Laboratories Full time

    Job Title: Senior IT Strategy and Portfolio ManagerFrontage Laboratories Inc. is a leading Contract Research Organization (CRO) operating over 25 state-of-the-art laboratories across the US, Canada, and China. Our core competencies include drug metabolism, pharmacokinetics/pharmacodynamics (PK/PD), safety and toxicology, bioanalytical services, chemistry and...


  • Exton, Pennsylvania, United States Citadel Full time

    Job OverviewThe Customer Data Insights Analyst is responsible for uncovering and analyzing customer data to inform strategic business decisions at Citadel. This role involves collaborating with cross-functional teams to identify key customer segments, develop targeted marketing campaigns, and optimize customer experiences.The ideal candidate will possess...


  • Exton, Pennsylvania, United States West Pharmaceutical Services Full time

    Job SummaryIn this role, the Senior Quality Engineer provides quality direction, governance, and Quality Management System best practices to syringe and drug containment programs.This is a global role that will oversee multiple concurrent projects to ensure regulatory and quality compliance is maintained throughout the product development lifecycle into...


  • Exton, Pennsylvania, United States Frontage Laboratories Full time

    Job SummaryAs a senior leader and subject matter expert, the Team Leader, Computer System Validation and Application Support will define and maintain Frontage Laboratories' computer system validation program. This includes testing, implementation, validation, and ongoing support of software applications.Key ResponsibilitiesEnsure the computer system...