Data & ERP Systems Analyst

Job Description

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