ERP Data and Systems Architect
United Refrigeration Inc. and Affiliates
Philadelphia, PA · Posted September 23, 2026
Will your résumé get you an interview here?
Drop your résumé and see in seconds how well it matches what United Refrigeration Inc. and Affiliates asks for. Free, no account needed.
Just laid off? Start here: a plan for the first weeks
More in Pennsylvania job market · Data & Analytics jobs
More roles at United Refrigeration Inc. and Affiliates
- Recruiting Coordinator · Philadelphia, PA
- Branch Manager · Mesa, AZ
- Branch Manager · Cincinnati, OH
Similar jobs
- Intermediate Data Scientist - Healthcare AI & Data Harmonization - Remote · NTT Data · Philadelphia, PA
- Payer Analytics Business Analyst, Senior Associate · PwC · Philadelphia, PA
- Senior Analyst, Data Science · Kabbage · New York, NY
- AI Engineer III - Core Technologies · Kabbage · Phoenix, AZ
- Data Quality Analyst · Ascension · Wichita, KS
- Senior Associate, Sales Reporting and Analytics - Chase Media Solutions · JPMorgan Chase · New York, NY
Where Philadelphia, PA ranks
Where Philadelphia, PA placed in our monthly rankings, month by month. Each month stays online at its own address.
November 2026
- #2Best cities for finance pay after cost of living$123k · of 38
- #3Cities hosting the most business conferences in the Mid-Atlantic25 conferences · of 9
- #3Best cities for sales pay after cost of living$117k · of 46
- #3Cities with the most jobs that do not need a four-year degree in the Northeast192 jobs · of 37
- #3Cities with the most jobs that do not need a four-year degree in the Mid-Atlantic192 jobs · of 54
- #4Best cities for software and engineering jobs in the Northeast214 openings · of 51
Rankings about data & analytics jobs
- Best cities for data and analytics jobs #1 New York (1,904 openings)
- Best cities for data and analytics pay after cost of living #1 San Mateo ($184k)
- Most requested AI skills in data and analytics jobs #1 Machine learning engineering (17.1%)
- AI tools named most often in data and analytics jobs #1 Databricks (7.6%)
- Employers with the most data and analytics jobs #1 Amazon (606 roles)
Data & Analytics jobs · Top Data & Analytics employers · All rankings
Skills this job asks for
Say which you have and which you want to build. We use it to match you to jobs like this one.
About the job
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