ERP Data Architect & Analytics Lead

United Refrigeration, Inc.; Philadelphia (Philadelphia County); On-site; USD 120,000 - 190,000; Full time

Benefits offered by this job

Dental Insurance

Life Insurance

Medical Insurance

Paid Time Off

Retirement

Vision Insurance

Job summary

United Refrigeration, Inc. is seeking a technically focused ERP Data and Systems Architect to own and optimize the ERP environment—its tables, logic, data structures, and integrations—so reporting, forecasting, and automation improve.

This is a hands-on role where business rules will be taught. You will build data models, SQL views, and data pipelines while collaborating with IT to implement changes, upgrades, and integrations, ensuring data integrity and scalable analytics across the

Qualifications

• Strong SQL experience with queries, stored procedures, and data modeling.
• Hands-on ERP system experience (Net-Link or similar) and data architecture.
• Ability to translate business processes into robust data models.
• Power BI data modeling, DAX, and performance optimization.

Responsibilities

• Own ERP data structures and ensure data integrity.
• Redesign tables, workflows, and master data structures.
• Optimize ERP modules across operations, purchasing, accounting, and sales.
• Develop SQL data pipelines and ensure data quality.
• Maintain ERP data dictionary and documentation.

Skills

SQL

Power BI

ERP systems

Data modeling

Relational databases

Tools

ETL tools

APIs integrations

Python

PowerShell

Job description

United Refrigeration, Inc. is seeking a technically focused ERP Data and Systems Architect to own and optimize the ERP environment—its tables, logic, data structures, and integrations—so reporting, forecasting, and automation improve.

This is a hands-on role where business rules will be taught. You will build data models, SQL views, and data pipelines while collaborating with IT to implement changes, upgrades, and integrations, ensuring data integrity and scalable analytics across the