Project Manager / Business Analyst -Data & Integration

Piping Rock•Bohemia, NY

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