Data & ERP Systems Analyst

United Refrigeration Inc.•Philadelphia, PA

About The Position

We are seeking a technically driven ERP Data and Systems Architect with strong experience in ERP architecture (Net Link or similar), SQL, and Power BI. The core focus of this role is to own and improve the ERP system — its tables, logic, data structures, integrations, and implementation — so that reporting, forecasting, and automation naturally improves. This is not a business SME role; we will teach the business rules. We need someone who can analyze, fix, rebuild, and optimize the ERP environment at a technical level.

Requirements

Strong SQL experience (queries, stored procedures, and data modeling).
Hands-on experience with ERP systems (Net-Link, custom ERPs, or comparable platforms).
Experience translating business processes into data models.
Power BI proficiency (data models, DAX, performance optimization).
Understanding relational databases, table structures, and normalization principles.
Strong analytical thinking and root-cause problem solving.
Clear communication of technical issues to non-technical teams.
Organized, detail-oriented, and consistent in documentation.

Nice To Haves

Experience supporting or configuring ERP modules.
Experience with ETL tools or API-based integrations.
Ability to automate tasks (Python, PowerShell, or similar helpful but optional).
Ability to read RPG a plus.

Responsibilities

Diagnose and resolve data integrity issues inside the ERP (incorrect fields, broken relationships, and bad logic).
Redesign tables, workflows, and master data structures to support clean and consistent operations.
Ensure SKU data, BOM, customer, vendor, pricing, and inventory records remain structurally correct.
Work with IT on system changes, upgrades, integrations, and data flow improvements.
Optimize ERP modules and workflows used by operations, purchasing, accounting, and sales.
Identify inefficiencies, gaps, or broken business rules in system processes.
Recommend and implement ERP-related fixes that reduce manual work and eliminate data re-entry.
Support future expansion, addons, or ERP enhancement projects.
Trace incorrect numbers back to the originating ERP table, field, or process.
Document issues and implement permanent corrective actions.
Provide clear explanations of technical problems and solutions.
Build SQL views, queries, and data models that extract clean data directly from ERP tables.
Create stable, scalable data pipelines that support analytics, automation, and system integrations.
Validate the accuracy and consistency of all ERP-based datasets.
Document fields, tables, definitions, and data flows in the ERP.
Establish consistent definitions for business metrics and reporting logic.
Keep documentation updated as changes are implemented.