ERP Data and Systems Architect

United Refrigeration Inc.

Philadelphia (Philadelphia County)

On-site

USD 120,000 - 170,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Dental Insurance
Life Insurance
Medical Insurance
Paid Time Off
Retirement Plan
Vision Insurance

Job summary

United Refrigeration Inc. is seeking an ERP Data and Systems Architect to own and optimize the ERP environment, including tables, logic, data structures, and integrations. You will enable accurate reporting, forecasting, and automation through strong technical leadership.

The ideal candidate will design data models, build stable ETL pipelines, and collaborate with IT to implement system enhancements while maintaining comprehensive documentation.

Qualifications

  • Strong SQL experience across queries, stored procedures, and data modeling.
  • Experience with ERP systems (Net-Link or similar) and data architecture principles.
  • Power BI proficiency for data modeling and performance optimization.

Responsibilities

  • Own ERP data structure, integrity, and master data management.
  • Redesign tables, workflows, and data structures to support accurate reporting and automation.
  • Collaborate with IT on ERP changes, upgrades, integrations, and data flow improvements.
  • Develop SQL views and data pipelines for analytics and integrations.
  • Maintain a formal ERP and Data Dictionary with clear definitions.

Skills

SQL development
ERP systems
Power BI
Data modeling
Root-cause analysis
ETL knowledge
Python/PowerShell

Education

Bachelor's degree in CS/IS/Engineering

Tools

Net-Link ERP
SQL Server

Job description

Overview

Role Overview: 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.


Responsibilities

Primary Responsibilities

1. ERP Data Structure Ownership



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


2. ERP Configuration & Process Logic 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.


3. Technical Issue Investigation & Root-Cause Analysis



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


4. Data Modeling & SQL Development for ERP Data



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


5. Maintain a Formal ERP & Data Dictionary



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


Qualifications

What Success Looks Like


  • Clean, accurate, and consistent ERP and reporting data

  • A fully maintained enterprise data dictionary used across departments

  • Reliable, automated reporting with trusted metrics

  • Faster and more confident business decision-making

  • Improved alignment between business operations and IT


Ideal Candidate Profile

Technical Skills (Required)


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


Preferred Skills


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


Soft Skills


  • Strong analytical thinking and root-cause problem solving.

  • Clear communication of technical issues to non-technical teams.

  • Organized, detail-oriented, and consistent in documentation.


Benefits

Dental InsuranceLife InsuranceMedical InsurancePaid Time OffRetirementVision Insurance

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

ERP Data and Systems Architect
ERP Data and Systems Architect

United Refrigeration, Inc. • Philadelphia

Hybrid
USD 130,000 - 180,000
Dental Insurance
Life Insurance
Medical Insurance
+2
ERP Analyst
ERP Analyst

Dreams 2 Reality Recruitment • Palo Alto (CA)

On-site
USD 110,000 - 150,000
BisTrack Business Support Specialist
BisTrack Business Support Specialist

The Planet Group • South Carolina

On-site
USD 60,000 - 85,000
PTO 2–3 weeks
Benefits after 60 days
401(k) with company 3% contribution
+1
ERP Business Systems Manager
ERP Business Systems Manager

CBX Solutions Recruiting Team • Winston-Salem (NC)

On-site
USD 120,000 - 180,000
Technical Business Systems Analyst
Technical Business Systems Analyst

Lucas Oil • Indianapolis (IN)

Hybrid
USD 90,000 - 130,000
ERP Administrator
ERP Administrator

Grey Search + Strategy • Elk River (MN)

On-site
USD 90,000 - 130,000
ERP Systems Analyst
ERP Systems Analyst

Plastpro,Inc • Los Angeles (CA)

On-site
USD 120,000 - 160,000
ERP Analyst V
ERP Analyst V

DataMap LLC • Overland Park (KS)

On-site
USD 120,000 - 150,000
Unlimited vacation
Health insurance with employer contribution
401(k) with employer match
+1
Technical Business Systems Analyst
Technical Business Systems Analyst

Lucas Oil Products • Indianapolis (IN)

On-site
USD 85,000 - 115,000
Technical Business Systems Analyst
Technical Business Systems Analyst

Lucas Oil Corporation • Indianapolis (IN)

Hybrid
USD 85,000 - 120,000