Sr. Analyst EDI and Data Integration

Responsibilities

• Manage day-to-day integrations between platforms such as NetSuite, SPS Commerce, Azure Data Lake, and 3PL partners.
• Support data exchange operations across platforms like SPS Commerce, NetSuite, Azure Data Lake, and internal dashboards.
• Troubleshoot and resolve data integration errors, mapping mismatches, and failed transactions in a timely manner.
• Monitor and document data workflows and interface health using logs, alerts, and reconciliation reports.
• Track KPIs related to data integration performance, including success rates, issue resolution time, and transaction latency to drive continuous improvement.
• Ensure compliance with industry standards and regulations for data integration and EDI transactions.
• Maintain integration specifications and mapping documentation for each trading partner and system interface.

Data Coordination & Analytics

• Clean, validate, and reconcile data flowing into the Azure Data Lake to ensure accuracy across raw, curated, and semantic layers.
• Identify data gaps, mismatches, and transformation issues and work with Master Data and business teams to resolve root causes.
• Monitor data pipelines, mappings, and refresh processes to confirm data is complete, timely, and aligned across systems.
• Validate that datasets powering dashboards reflect correct business logic and support accurate reporting for all functions.
• Partner with business data analysts to translate reporting needs into clear data requirements and ensure the lake structure supports those needs.
• Document data flow rules, transformations, and dependencies to support consistent analytics development and troubleshooting.
• Perform periodic data quality checks and reconciliation to maintain trust in the dashboards and analytics ecosystem.

Projects

• Support & EDI Partner Enablement
• Participate in enhancement projects to improve automation, data quality, and reporting consistency.
• Participate in cross-functional projects to enhance data automation, minimize manual touchpoints, and support business scalability.