Data Integration Engineer

1 month ago

exton, 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 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 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 Engineer, 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.

  • Data Integration Engineer

    2 months ago

    Exton, 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 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 offers a unique opportunity to...

  • Senior Data Integration Specialist

    4 weeks ago

    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,...

  • Senior Data Integration Specialist

    4 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...

  • Senior Data Integration Specialist

    1 month ago

    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...

  • Customer Data Analyst

    3 weeks ago

    Exton, United States Citadel Full time

    Job Overview The Customer Data Analyst is responsible for identifying and analyzing data regarding our customers and prospective customers, making recommendations, and providing insight to Citadel leadership in critical decision-making that drives attainment of strategic and business objectives, including growth and sales. The Analyst will be responsible for...

  • Customer Data Analyst

    3 weeks ago

    Exton, United States Citadel Full time

    Job Overview The Customer Data Analyst is responsible for identifying and analyzing data regarding our customers and prospective customers, making recommendations, and providing insight to Citadel leadership in critical decision-making that drives attainment of strategic and business objectives, including growth and sales. The Analyst will be responsible for...

  • Transportation Engineer III

    4 weeks ago

    Exton, Pennsylvania, United States Bowman Consulting Group, Ltd. Full time

    Job Summary:Bowman Consulting Group, Ltd. is seeking a highly skilled Transportation Design Engineer III to join our team in Exton, PA. As a key member of our transportation engineering team, you will be responsible for executing complex technical transportation engineering techniques, procedures, and criteria for transportation and infrastructure...

  • Electrical Design Engineer

    4 weeks ago

    Exton, Pennsylvania, United States Insight Global Full time

    Electrical Engineer Role Summary:As an Electrical Engineer at Insight Global, you will be responsible for designing and developing electrical systems for industrial, biotech, pharmaceutical, and food facilities. This includes preparing electrical system concepts, calculations for electrical loads, single line diagrams for power distribution, lighting...

  • Project Engineer

    3 weeks ago

    exton, United States Action Placements LLC Full time

    Position Description: We are seeking a professional with approximately 8+ years of experience and a range of knowledge and practice with remediation, environmental engineering design, construction and OM&M that can be integrated across our diverse portfolio of clients and projects. Preferred candidates will have experience working on complex remedial...

  • Project Engineer

    3 weeks ago

    Exton, United States Action Placements LLC Full time

    Position Description: We are seeking a professional with approximately 8+ years of experience and a range of knowledge and practice with remediation, environmental engineering design, construction and OM&M that can be integrated across our diverse portfolio of clients and projects. Preferred candidates will have experience working on complex remedial...

  • Associate Electrical Engineer

    3 weeks ago

    Exton, United States JCSI Full time

    ASSOCIATE ELECTRICAL ENGINEEROverview:We are seeking a dynamic Associate Electrical Engineer to join our team in Exton, PA. In this role, you will lead and collaborate on various electrical engineering projects within the industrial, biotech, pharmaceutical, and food sectors. You will be responsible for designing and overseeing complex design/build projects,...

  • Senior Systems Engineer, R&D

    4 weeks ago

    Exton, Pennsylvania, United States West Pharmaceutical Services Full time

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

  • Electrical Engineering Design Specialist

    4 weeks ago

    Exton, Pennsylvania, United States AtkinsRéalis Full time

    Electrical Engineering Design RoleAtkinsRéalis is a global firm that leverages the connection of people, data, and technology to create valuable partnerships and make a positive impact on the planet and its people. We are seeking an Electrical Engineering Design Associate to join our team in Exton, PA, to lead and work on various Electrical Engineer and...

  • Associate Electrical Engineer

    3 weeks ago

    Exton, United States JCSI Full time

    ASSOCIATE ELECTRICAL ENGINEER Overview: We are seeking a dynamic Associate Electrical Engineer to join our team in Exton, PA. In this role, you will lead and collaborate on various electrical engineering projects within the industrial, biotech, pharmaceutical, and food sectors. You will be responsible for designing and overseeing complex design/build...

  • Senior Electrical Design Engineer

    2 days ago

    Exton, Pennsylvania, United States JCSI Full time

    OverviewWe are seeking a skilled Senior Electrical Design Engineer to join our team in Exton, PA. This role involves leading and collaborating on various electrical engineering projects within the industrial, biotech, pharmaceutical, and food sectors.Salary$62-80K per yearJob DescriptionThis position is responsible for designing and overseeing complex...

  • Associate Electrical Engineer

    3 months ago

    Exton, United States JCSI Full time

    ASSOCIATE ELECTRICAL ENGINEER Overview:We are seeking a dynamic Associate Electrical Engineer to join our team in Exton, PA. In this role, you will lead and collaborate on various electrical engineering projects within the industrial, biotech, pharmaceutical, and food sectors. You will be responsible for designing and overseeing complex design/build...

  • FPGA Development Engineer

    2 days ago

    Exton, United States Innovative Solutions and Support Full time

    Job DescriptionJob DescriptionInnovative Solutions & Support, Inc. seeks an engaged, curious, and skilled FPGA Development Engineer as a key addition to our Staff. Competitive salary Superior benefits packageOn-site in Exton, PAWho We AreInnovative Solutions & Support (IS&S) transforms leading edge technologies into sophisticated, cost-effective solutions...

  • Mechanical Engineer

    4 weeks ago

    Exton, Pennsylvania, United States AtkinsRéalis Full time

    Job Summary: AtkinsRéalis is seeking a skilled Mechanical Engineer to join our Exton, PA office. As a Pipe Stress Analysis Engineer, you will be responsible for performing pipe stress analysis for power piping and industrial systems using stress software to verify piping flexibility, stability, and qualification of equipment nozzle loads.Key...

  • Senior Mechanical Engineer Position

    1 month ago

    Exton, Pennsylvania, United States AtkinsRéalis Full time

    About UsAtkinsRéalis is a world-renowned design, engineering, and project management consultancy with over 50 years of experience in providing infrastructure planning, engineering, construction, environmental consulting, urban planning, architecture, and program management services to public and private clients across the United States.Job SummaryWe are...

  • Supplier Quality Engineer

    2 weeks ago

    exton, United States United Safety & Survivability Corporation Full time

    "Develop and establish processes for analyzing supplier performance.” 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. As the global leader in our industry, we push boundaries by utilizing innovation to highly...