Back to jobs

ERP Data and Systems Architect

Pay
Pay not listedSimilar roles state $127K–$189K
Work setting
Not stated
Employment
Full-time — employment source
Employment type in the employer’s posting: FULL_TIME
From the employer’s posting

What you’ll work on

Full posting
  • Diagnose and fix ERP data integrity issues, broken relationships, and bad logic

  • Redesign tables, workflows, and master data structures for clean operations

  • Trace incorrect numbers back to the originating ERP table, field, or process

  • Build SQL views, queries, and data models that extract clean ERP data

  • Document ERP fields, tables, definitions, and data flows in a data dictionary

From the employer’s posting
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
Trace incorrect numbers back to the originating ERP table, field, or process
Build SQL views, queries, and data models that extract clean data directly from ERP tables
Document fields, tables, definitions, and data flows in the ERP

Before you apply

Employer’s visa record
1 H-1B petition approved in fiscal 2024 and 2025For the employer as a whole. This posting doesn’t say whether the role is sponsored. US Citizenship and Immigration Services.

What you’ll bring

All qualifications

Core experience

  • Strong SQL experience, including queries, stored procedures, and data modeling
  • Hands-on experience with ERP systems such as Net-Link, custom ERPs, or comparable
  • Power BI proficiency, including data models, DAX, and performance optimization
  • Experience translating business processes into data models
  • Understanding of relational databases, table structures, and normalization

Preferred experience

  • Experience supporting or configuring ERP modules.
Qualification wording
Strong SQL experience (queries, stored procedures, and data modeling)
Hands-on experience with ERP systems (Net-Link, custom ERPs, or comparable platforms)
Power BI proficiency (data models, DAX, performance optimization)
Experience translating business processes into data models
Understanding relational databases, table structures, and normalization principles
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.

Benefits in the posting

Full benefits wording
  • Dental Insurance Life Insurance Medical Insurance Paid Time Off Retirement Vision Insurance

From the employer’s posting.

Apply at United Refrigeration

Posting record

Report an error

Actively hiringFirst seen by us 3 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20263 days ago
Recorded sightings
5
Last seen by us
Nov 22, 2026
Employer says posted
Oct 1, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$127K–$189K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 2,448 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 3

Early. Similar jobs usually come down between day 6 and day 56.

From 14,766 similar postings that came down. Coming down is not always a hire.

United Refrigeration is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • Power BI
Where the posting names them
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
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
• 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.
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
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

Your next step

Complete your application on careers-uri.icims.com. The employer’s form will show what is required.

Applying through iCIMS

  • You start with your email. New applicants then create a login, and returning ones sign in.
  • Upload your resume before you fill anything in: iCIMS fills some profile fields from it.
  • Check your status on the employer’s iCIMS Dashboard, under Past Job Submittals.

Already applied? Track this application

Job description

View original posting ↗

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 Insurance Life Insurance Medical Insurance Paid Time Off Retirement Vision Insurance

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Philadelphia, PA

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.