Data & ERP Systems Analyst

United Refrigeration, Inc.; Philadelphia (Philadelphia County); On-site; USD 85,000 - 110,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 Data & ERP Systems Analyst (IT Liaison) to enhance ERP data accuracy and usability. You will bridge business operations and IT, supporting data governance, reporting, and analytics initiatives to drive efficiency and strategic decisions.

You will oversee data definitions, validation across ERP and reporting platforms, and coordinate system improvements with functional and technical teams to ensure reliable metrics and trusted insights for leadership.

Qualifications

• Bachelor’s degree in Information Systems, Business Analytics, Computer Science, Finance, or related field.
• Minimum 3 years of experience in ERP systems, business analytics, reporting, or data management.
• Strong understanding of ERP data structures and business operations.
• Experience with Power BI, SQL, and advanced Excel.
• Excellent communication and cross-functional collaboration skills.

Responsibilities

• Identify and resolve inaccurate, duplicated, or inconsistent ERP data.
• Partner with IT to correct system fields, tables, workflows, and data logic.
• Collaborate with Accounting, Product, Inventory, and Operations to maintain master data.
• Develop and maintain a centralized enterprise data dictionary.
• Build and enhance dashboards and reports for leadership and departments.
• Translate business requirements into technical specifications and system requests.
• Coordinate ERP enhancements, reporting needs, and data correction initiatives.
• Ensure consistent data definitions across departments.

Skills

ERP data management

Data analysis

Problem solving

Cross-functional collaboration

Education

Bachelor’s degree in Information Systems, Business Analytics, Computer Science, Finance, or related field

Tools

Power BI

SQL

Excel

Job description

Overview

The Data & ERP Systems Analyst (IT Liaison) is responsible for improving the accuracy, consistency, and usability of enterprise data across the organization. This role acts as the bridge between business operations and IT, ensuring ERP data, reporting systems, and analytics tools effectively support operational efficiency and strategic decision-making.

This individual will oversee data integrity initiatives, maintain enterprise data definitions, support reporting and analytics, and coordinate system improvements between functional teams and technical resources.

Responsibilities

Essential Duties & Responsibilities

ERP Data Management

• Identify and resolve inaccurate, duplicated, or inconsistent ERP data.
• Partner with IT to correct system fields, tables, workflows, and data logic.
• Collaborate with Accounting, Product, Inventory, and Operations teams to maintain accurate:
• • SKU data
  • Bills of Materials (BOMs)
  • Pricing structures
  • Customer and vendor records
  • Operational master data

Data Governance & Documentation

• Develop and maintain a centralized enterprise data dictionary.
• Document key business definitions, tables, fields, KPIs, calculations, and reporting standards.
• Establish and maintain consistent data definitions across all departments.
• Update documentation as business processes and systems evolve.

Reporting & Business Intelligence

• Build and enhance dashboards and operational reports for leadership and functional departments.
• Validate data accuracy between ERP systems and reporting platforms.
• Partner with IT and business stakeholders to develop and improve data integrations and feeds.
• Maintain report refresh schedules, data models, and reporting reliability.

Business & IT Coordination

• Serve as the primary liaison between business teams and IT.
• Translate business requirements into technical specifications and actionable system requests.
• Coordinate ERP enhancements, reporting needs, and data correction initiatives.
• Ensure alignment and communication between technical and non-technical stakeholders.

Data Analysis & Issue Resolution

• Investigate discrepancies in reports, dashboards, and operational metrics.
• Trace data issues to source systems, fields, calculations, or processes.
• Recommend corrective actions and oversee implementation through resolution.

Operational Support & Analytics

• Provide ad hoc analysis and reporting to support operational and strategic decision-making.
• Analyze business trends, variances, forecasting accuracy, and operational performance.
• Deliver actionable insights to improve efficiency and business performance.

Qualifications

Qualifications

• Bachelor’s degree in Information Systems, Business Analytics, Computer Science, Finance, or related field preferred.
• Minimum 3 years of experience in ERP systems, business analytics, reporting, or data management.
• Strong understanding of ERP data structures and business operations.
• Experience with reporting and BI tools such as Power BI, SQL, and advanced Excel.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication skills with the ability to work across technical and operational teams.
• Experience documenting business processes, reporting logic, and data definitions preferred.

Preferred Skills

• ERP administration or support experience
• SQL querying and data validation
• Power BI dashboard development and data modeling
• Knowledge of inventory, purchasing, accounting, and operational workflows
• Strong organizational and project coordination skills

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

Benefits

• Dental Insurance
• Life Insurance
• Medical Insurance
• Paid Time Off
• Retirement
• Vision Insurance