Scn Bestco

Job Summary:
SCN BestCo is a leading innovator in the Vitamin, Mineral & Supplement industry, committed to making health and wellness enjoyable. The Senior Data Integration Engineer will extract and integrate data from core systems into the Azure data platform, ensuring reliable and scalable data pipelines for analytics and reporting.
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%).
Qualifications:
Required:
• 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.
• 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:
• 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.
Company:
SCN BestCo develops and manufactures pharmaceutical dosage forms for the OTC drug, vitamin, and supplement marketplace. Founded in 1968, the company is headquartered in Santa Cruz, USA, with a team of 1001-5000 employees. The company is currently Late Stage.