Senior Data Integration Engineer

We believe being healthy should not require tradeoffs. SCN BestCo is a leading innovator developer and manufacturer of Vitamin Mineral & Supplement (VMS) Over-the-Counter (OTC) and prebiotics/probiotics in enjoyable forms such as gummies lozenges and chews. With over 50 years of excellence our team leads the way in changing how consumers make healthier choices. With unique food science expertise and proprietary processes weve pioneered many firsts. Our passion to create new to the world products has guided and continues to be core to our mission of making health and wellness more enjoyable. Come join us and become a part of our winning formula!

The Senior Data Integration Engineer is responsible for extracting and integrating data from SCN BestCos core systems including SAP JD Edwards (JDE) AMAPS and other enterprise applications into the Azure data platform. This role focuses on building and maintaining reliable scalable data pipelines using tools such as Boomi and Azure Data Factory to ensure consistent and timely delivery of data into staging environments. The Senior Data Integration Engineer partners closely with Data Warehouse and Analytics teams to enable accurate complete and accessible data for reporting and analysis.

• Design build and maintain data integration pipelines from SAP JDE AMAPS NetSuite and other systems into Azure using Boomi and Azure Data Factory.
• Extract data from source systems via APIs flat files database queries and middleware tools.
• Ensure reliable and efficient data ingestion into Azure Blob Storage and staging environments.
• Monitor troubleshoot and optimize data pipelines for performance and reliability.
• Partner with business and IT teams to understand data requirements and source system structures.
• Maintain data integration documentation including data flows mappings and dependencies.
• Support data validation and reconciliation processes to ensure accuracy and completeness.
• Collaborate with data warehouse engineering to ensure clean handoff of staged data for modeling.
• Identify opportunities to improve data acquisition processes and reduce manual effort.
• Travel as needed for system and stakeholder alignment (10%).

Education & Experience:

• Bachelors degree in computer science information systems engineering or related field.
• 6 years professional experience in data integration ETL/ELT development and/or data engineering.
• Hands-on experience with Azure Data Factory and/or similar data integration tools.
• Experience working with enterprise resource planning (ERP) systems such as SAP and JD Edwards (JDE).
• Experience with middleware tools such as Boomi or similar platforms.

Knowledge Skills & Abilities (KSAs):

• Strong understanding of data integration patterns and pipeline design.
• Ability to work with structured and semi-structured data formats.
• Strong SQL skills and experience querying enterprise systems.
• Ability to troubleshoot and resolve data pipeline and integration issues.
• Strong communication skills and ability to work cross-functionally.
• Ability to manage multiple priorities in a fast-paced environment.

• Ability to apply critical thinking in problem solving. Must be able to demonstrate practical problem solving and trouble shooting skills. Ability to demonstrate practical problem solving and trouble shooting skills. Ability to define problems collect data establish facts and draw valid conclusions. Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.
• Must have the ability to communicate effectively both verbally and in writing with internal staff and management. Ability to read analyze and interpret general business periodicals professional journals technical procedures or governmental regulations. Ability to write reports business correspondence and procedure manuals. Ability to effectively present information and respond to questions from groups of managers clients customers and the general public.
• Ability to work with mathematical concepts such as probability and statistical inference and fundamentals of plane and solid geometry and trigonometry. Ability to apply concepts such as fractions percentages ratios and proportions to practical situations.

• Experience with Azure cloud ecosystem (Data Factory Data Lake Synapse Fabric).
• Experience integrating multiple ERP systems in a complex environment.
• Familiarity with data governance and data quality practices.

Required Experience:

Senior IC