ERP Data & Systems Architect: Streamline, Model & Automate

United Refrigeration, Inc.

Philadelphia (Philadelphia County)

Hybrid

USD 130,000 - 180,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

Job summary

United Refrigeration, Inc. is seeking an ERP Data and Systems Architect to own and optimize the ERP environment, focusing on data structures, integrations, and reporting. You will design data models, improve workflows, and ensure data integrity for analytics and automation.

The ideal candidate has strong SQL, Power BI, and ERP experience, and can translate business processes into robust data models while maintaining comprehensive data dictionaries.

Qualifications

Experience building SQL views, queries, and data models from ERP tables.
Strong experience with ERP systems (Net-Link or similar).
Experience translating business processes into data models.
Power BI data models, DAX, and performance optimization.
Ability to create stable, scalable data pipelines for analytics.
Document fields, tables, data flows, and definitions in a data dictionary.

Responsibilities

Own ERP data structure and data dictionary.
Improve ERP configuration, processes, and data flow.
Investigate root causes and document fixes.
Develop SQL data models and data pipelines for analytics.
Maintain documentation for ERP and data definitions.
Ensure reporting accuracy and reliable metrics.

Skills

SQL

ERP systems

Power BI

Data modeling

ETL

RPG

Tools

Net-Link

Power BI

Job description

The ideal candidate has strong SQL, Power BI, and ERP experience, and can translate business processes into robust data models while maintaining comprehensive data dictionaries.

Get your free, confidential resume review.

or drag and drop your file here.