PR
Project Manager / Business Analyst -Data & Integration
full-time•Bohemia
About this role
The IT Project Manager / Business Analyst -Data & Integration will support enterprise data and integration initiatives for a fast-growing Consumer Packaged Goods (CPG) company specializing in nutritional supplements. This role bridges business and IT by managing projects, gathering and documenting requirements, and supporting data-centric platforms including Master Data Management (MDM), Data Governance, Data Quality, ETL/Data Integration, APIs, EDI, and Business Intelligence (BI).
The role partners closely with Supply Chain, Manufacturing, Quality, Regulatory, Sales, E-Commerce, Finance, and external trading partners to ensure accurate, trusted, and timely data across the enterprise.
Responsibilities:
Project Management
- 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
Business Analysis
- 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
Master Data Management (MDM) & Data Governance
- 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
Data Integration, ETL & Middleware
- 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
EDI & Trading Partner Integration
- 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
Business Intelligence & Analytics
- 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
Required Qualifications
- 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
- ETL and data integration
- APIs and middleware platforms
- EDI processes and transactions
- BI/reporting tools
Preferred Qualifications
- 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
Key Skills & Competencies
- Strong analytical and problem-solving skills
- Excellent written and verbal communication
- Ability to manage multiple initiatives in a fast-paced environment
- Strong stakeholder management and facilitation skills
- Detail-oriented with a focus on data accuracy and quality
We proudly offer: Medical, Dental, Vision, 401K with Company Match, Pet insurance and more!
We reward the hard work of our team members with fun and exciting company events, Summer Picnic, Festive Packages, Holiday Celebrations, and associate referral bonuses!
Founded in 2011, Piping Rock Health Products has gone on to win Long Island’s Top Workplaces Award 7 years in a row & securing the spot as Top Supplement Manufacturing Company 2024 by Food Business Review! Supported by a group of vitamin visionaries with over 40 years of industry experience and a carefully curated team of talented associates. Piping Rock is a global vitamin and supplement manufacturer with an unwavering commitment to creating quality wellness products. We believe that family always comes first, and that the dedication of our associates is the key ingredient to our success.
We are drug free workplace, regulated by the FDA, required to follow Federal Guidelines; therefore in order to start as well as maintain employment, you must be able to successfully clear drug screening processes, which include testing for all illegal substances per Federal Guidelines.
Piping Rock Health Products, INC. is an Equal Opportunity Employer.
What you'll do
- The Project Manager / Business Analyst will lead IT projects related to data and integration, ensuring collaboration across various departments. They will also gather and document requirements while supporting data-centric platforms.
About Piping Rock
Who is Piping Rock?
Piping Rock Health Products was founded in 2011 by industry icon Scott Rudolph with his son, Michael Rudolph. The father-son duo is supported by a talented group of vitamin visionaries with over 40 years of industry experience and a carefully curated team of talented associates.
We believe that family always comes first, and that the dedication of our associates is the key ingredient to our success. At Piping Rock, we take pride in rewarding hard work with lighthearted fun, celebrating our wins and showing our team members just how much they mean to us.
What is Piping Rock?
Piping Rock is a global vitamin and supplement manufacturer with an unwavering commitment to creating quality wellness products. Piping Rock is comprised of many successful brands including Nature’s Truth, Pink, Sundance, Lindberg Nutrition, and Fitness Labs, among others. Each brand adheres to Piping Rock’s commitment to quality, innovation, and customer satisfaction. Whether vitamins, supplements, herbs, or holistic oils, Piping Rock stays current with customers’ evolving needs and consistently meet demands with new products that are non-GMO, allergen free, and organic.
Piping Rock has flourished into a world-class company grounded by entrepreneurial ethics.
Where is Piping Rock?
Piping Rock manufactures and distributes products across the U.S. and all over the world. Headquartered in Bohemia, NY, Piping Rock has several locations and facilities in the NY Metropolitan area; Cleveland, Ohio area; Las Vegas, Nevada; and multiple office locations across Los Angeles, California. We also have several international satellite offices in countries such as India, Ukraine, Mexico, and the UK.
Join our growing family today!
Ready to join Piping Rock?
Take the next step in your career journey
Frequently Asked Questions
What does a Project Manager / Business Analyst -Data & Integration do at Piping Rock?
As a Project Manager / Business Analyst -Data & Integration at Piping Rock, you will: the Project Manager / Business Analyst will lead IT projects related to data and integration, ensuring collaboration across various departments. They will also gather and document requirements while supporting data-centric platforms..
Is the Project Manager / Business Analyst -Data & Integration position at Piping Rock remote?
The Project Manager / Business Analyst -Data & Integration position at Piping Rock is based in Bohemia, New York, United States. Contact the company through Clera for specific work arrangement details.
How do I apply for the Project Manager / Business Analyst -Data & Integration position at Piping Rock?
You can apply for the Project Manager / Business Analyst -Data & Integration position at Piping Rockdirectly through Clera. Click the "Apply Now" button above to start your application. Clera's AI-powered platform will help match your profile with this opportunity and guide you through the application process.