ERP Analytic Report Specialist

Hanes Supply; Buffalo (NY); On-site; USD 57,000 - 69,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k) plan

PTO

Job summary

Hanes Supply in Buffalo, NY seeks an ERP Analytic Report Specialist to lead ERP pricing re-evaluation and build enterprise reporting dashboards. The role bridges business operations and technology, working directly with transactional data and delivering actionable recommendations.

The ideal candidate has strong SQL skills, experience with Infor CloudSuite, and a solid grasp of pricing, margins, and BI reporting. Infor CloudSuite experience is highly desired. This is an on-site position.

Qualifications

• Experience with ERP systems, preferably Infor CloudSuite.
• Strong SQL skills to extract, join and validate data from transactional systems.
• Experience building reports and dashboards using BI/reporting tools.
• Demonstrated ability to use AI tools for analysis, development and documentation.
• Practical understanding of pricing, cost and margin concepts in distribution/manufacturing.
• Strong understanding of business processes and system workflows.
• Ability to translate data analysis into clear recommendations for executives.

Responsibilities

• Re-evaluate ERP pricing matrix to improve gross margin.
• Extract and analyze multi-year transactional data from Infor CloudSuite.
• Model pricing scenarios and quantify margin impact.
• Present pricing recommendations to IT leadership, Sales and executives.
• Implement, test, and maintain pricing changes within the ERP.
• Develop and maintain a company intranet with operational reporting dashboards.
• Write and optimize SQL queries feeding reports and analytics tools.
• Gather reporting requirements from department managers and translate to practical reports.
• Use AI tools to accelerate report/dashboard development and surface exceptions.
• Maintain access controls for sensitive data.

Skills

ERP systems

SQL

Reporting dashboards

AI tools

Pricing & margins

Communication

Training users

Education

Bachelor of Science in business / information systems / data analytics / CS

Tools

Infor CloudSuite

BI tools

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

ERP Analytic Report Specialist

SALARY BUFFALO

5 days ago Requisition ID: 1157

Salary: $63,000.00 Annually

Position Summary

We are seeking an analytical and self-directed ERP Systems Analyst to join our Information Technology team. This role supports and enhances our ERP system (Infor CloudSuite) and related business applications, and takes the lead on two strategic initiatives: re-evaluating the company’s ERP pricing matrix using historical sales data and AI-assisted analysis to improve margin, and building a company intranet that delivers reporting and dashboards to every department. The ideal candidate bridges the gap between business operations and technology, is comfortable working directly with transactional data, and can turn analysis into recommendations and working tools that the business will actually use.

Essential Duties and Responsibilities

• Lead the re-evaluation of the company’s ERP pricing matrix to improve gross margin, including:
• Extracting and analyzing multi-year transactional history from Infor CloudSuite — sales orders, invoices, cost, customer, and product data — to identify margin leakage, pricing outliers, and unpriced or mispriced items.
• Using AI tools and analytical methods to segment customers and products, model pricing scenarios, and quantify the projected margin impact of proposed changes.
• Presenting pricing matrix recommendations to IT leadership, Sales management, and executive management in clear, decision-ready terms.
• Implementing, testing, and maintaining approved pricing matrix changes within the ERP.
• Establishing recurring measurement so pricing performance is monitored after implementation and the matrix is reviewed on an ongoing schedule.
• Develop and maintain a company intranet to deliver operational reporting and dashboards to all departments, including:
• Building department-specific dashboards and reports for Sales, Warehouse, Purchasing, Production, Accounting, Service, and Rental.
• Writing and optimizing SQL queries and data sources that feed reports, dashboards, and business analytics tools.
• Gathering reporting requirements from department managers and translating them into practical, maintainable reporting.
• Using AI tools to accelerate report and dashboard development, automate recurring analysis, and surface exceptions that need attention.
• Maintaining access controls so that sensitive sales, cost, margin, and personnel data is visible only to authorized users.
• Administer and support the company’s ERP system (Infor CloudSuite), including:
• Providing day-to-day operational support for departments such as Sales, Warehouse, Purchasing, Production, Accounting, Service, and Rental.
• Managing and optimizing system transaction flows (e.g., Sales Orders, Purchase Orders, Warehouse Transfers).
• Identifying and implementing system improvements in collaboration with IT leadership and department managers.
• Training new and existing users across all departments.
• Develop a masterful understanding of how our external systems integrate to our ERP to support the business.
• Troubleshoot ERP-related issues and provide first-level support for integrated systems (Shipping, Document Management, Reporting, CRM, Website, eCommerce, etc.).
• Analyze, design, and maintain business information systems to support operational needs.
• Assist in the development, implementation and rollout of new systems and technologies.
• Develop and maintain system documentation, user guides, and training materials.
• Evaluate training needs and develop or enhance training programs accordingly.
• Use AI tools to work quickly and efficiently.
• Work closely with other members of the IT team and department managers to meet the needs of the business.
• Ensure confidentiality of sensitive data, including sales, cost, margin, and personnel information.
• Follow all safety procedures and company policies in the execution of job duties.
• Perform additional duties as assigned.

Knowledge, Skills and Abilities

• Proven experience with ERP systems, preferably Infor CloudSuite.
• Strong SQL skills, including the ability to extract, join, and validate data from transactional systems without supervision.
• Experience building reports and dashboards using business analytics and reporting tools.
• Demonstrated ability to use AI tools productively for analysis, development, and documentation.
• Practical understanding of pricing, cost, and margin concepts in a distribution or manufacturing environment.
• Strong understanding of business processes and system workflows.
• Ability to translate data analysis into clear recommendations for non-technical audiences, including executive management.
• Excellent problem-solving and communication skills.
• Ability to train users and document technical processes clearly.
• High attention to detail, sound judgment with confidential data, and a proactive attitude toward system improvements.

Level of Education and Experience

• Experience on Infor CloudSuite or another ERP system is strongly desired.
• Bachelor of Science Degree in business, information systems, data analytics, computer science, or a similar field is desired.
• Three or more years in an analyst, reporting, or business systems role is desired.
• Demonstrated hands-on experience with SQL and with a reporting or business intelligence tool is required.
• Experience developing or maintaining web-based internal applications or dashboards is desired.
• Experience in a project management role is desired.
• Working experience in a manufacturing or distribution industry is preferred.

Physical Demands

The physical demands described below are representative of those that must be met by an employee to successfully perform the essential duties and responsibilities of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this job.

This position is primarily sedentary in nature however, the incumbent is required to occasionally sit, climb stairs, stoop, kneel, crouch or crawl and must be able to frequently be able to move up to 10 lbs. and occasionally lift and/or move up to 25 lbs.

Working Conditions

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this job.

We offer a comprehensive benefits package including Medical, Dental, Vision, FSA, HRA, Life Insurance, Disability, PTO, 401k, Holidays, and much more.

Successful passing of a pre-employment drug, alcohol and physical screening test is required as a condition of employment. We reserve the option to do a reference and/or background check.

Positions are available in person only; No remote work is available at this time.

The actual compensation is determined by experience and other factors of the law.

*Consideration will not be given to any responses that does not include a resume.

Equal Employment Opportunity

Hanes Supply Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, pregnancy, pregnancy outcomes, reproductive healthcare and autonomy, or any other characteristic protected by federal, state, or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.