Project Manager / Business Analyst - Data & Integration

Piping Rock • Bohemia, NY

3d

About The Position

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.

Requirements

• 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
• 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

Nice To Haves

• 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

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

Benefits

• 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!

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 501-1,000 employees