Piping Rock Health Products · 9 hours ago
Project Manager / Business Analyst - Data & Integration
3900 Veterans Memorial Highway, 3900 Veterans Hwy., Bohemia, New York, United States of America
Full-time
Onsite
Mid, Senior Level
$120K/yr - $130K/yr
5+ years expPiping Rock Health Products is a global vitamin and supplement manufacturer dedicated to creating quality wellness products. The IT Project Manager / Business Analyst - Data & Integration will support enterprise data and integration initiatives, managing projects and gathering requirements to ensure accurate and timely data across the organization.
FitnessHealth CareWellness
Responsibilities
Lead IT projects across data, integration, and analytics domains using Agile, Waterfall, or hybrid methodologies
Develop and manage project plans, timelines, risks, dependencies, and deliverables
Coordinate cross-functional teams including IT, business stakeholders, vendors, and EDI trading partners
Facilitate project status reporting, steering committee updates, and post-implementation reviews
Elicit, analyze, and document business and technical requirements for data and integration initiatives
Translate business needs into functional specifications, process flows, and data mappings
Serve as liaison between business users and technical teams to ensure alignment and clarity
Support user acceptance testing (UAT), defect triage, and solution validation
Support MDM initiatives for core CPG domains such as: Item / Bill of Materials (BOM); Vendor / Supplier / Customer
Assist in defining data governance policies, ownership, stewardship, and approval workflows
Support data quality analysis, profiling, issue remediation, and ongoing monitoring
Collaborate with business data stewards to improve data accuracy, consistency, and compliance
Support ETL and data integration processes between ERP, WMS, CRM, QA/QC, and BI platforms
Document source-to-target mappings and transformation logic
Assist with API-based integrations and middleware platforms
Coordinate testing and validation of integrations across systems
Support EDI onboarding and maintenance for customers, suppliers, and logistics partners
Work with EDI transactions such as: 850, 855, 810, 856, 940, 945, 944, 846, 997, 214 (as applicable)
Coordinate mapping, testing, and issue resolution with internal teams and external trading partners
Support EDI compliance and operational reliability
Gather and document requirements for BI reporting, dashboards, and analytics
Support KPI definitions related to sales, supply chain, inventory, manufacturing, quality, and finance
Partner with BI developers and data engineers to ensure accurate and usable reporting solutions
Assist in data validation, reconciliation, and user enablement
Qualification
Required
Bachelor's degree in Information Systems, Computer Science, Business, or related field
5+ years of experience as a Project Manager, Business Analyst, or hybrid role in an IT environment
Hands-on experience supporting data-driven systems in a CPG, manufacturing, or distribution environment
Strong understanding of MDM concepts and data governance
Strong understanding of ETL and data integration
Strong understanding of APIs and middleware platforms
Strong understanding of EDI processes and transactions
Strong understanding of BI/reporting tools
Preferred
Experience in nutritional supplements, food, pharma, or regulated manufacturing environments
Familiarity with ERP systems (e.g., Oracle, NetSuite, Dayforce)
Experience with BI tools (Power BI, Tableau, etc.)
PMP, CBAP, Agile, or similar certification a plus
Benefits
Medical
Dental
Vision
401K with Company Match
Pet insurance
Fun and exciting company events
Summer Picnic
Festive Packages
Holiday Celebrations
Associate referral bonuses
Company
Piping Rock Health Products
Who is Piping Rock? Piping Rock Health Products was founded in 2011 by industry icon Scott Rudolph with his son, Michael Rudolph.
501-1000 employees
H1B Sponsorship
Piping Rock Health Products has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2023 (1)
2022 (1)
2021 (2)
Funding
Current Stage
Late StageLeadership Team
S
Scott Rudolph
President
Recent News
Morningstar.com
2025-12-10
Company data provided by crunchbase