ERP Data Architect: Streamline Data & Automate Reporting

United Refrigeration Inc.

Philadelphia (Philadelphia County)

On-site

USD 120,000 - 170,000

Full time

14 days+

Application generator

Turn this role into an interview — a resume and cover letter built around what this employer wants.

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

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

Get your free, confidential resume review.

or drag and drop your file here.