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, we’ve 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 BestCo’s 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.
Essential Duties and Responsibilities
- 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%).
Required Qualifications
Education & Experience:
- Bachelor’s 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.
Preferred Qualifications
- 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.