Data Engineer

The Data Engineer at Goodin Company helps distribution operations make better inventory and pricing decisions by building reliable reporting, dashboards, and data pipelines. The position focuses on transforming ERP and point-of-sale data into actionable insights used across sales, inventory, warehouse, and vendor workflows.

Responsibilities

• Design and maintain dashboards covering distribution metrics such as inventory turns, fill rates, branch sales performance, gross margin by product line, and vendor rebate tracking
• Write and optimize SQL queries on ERP data (for example, Infor CloudSuite or comparable distribution ERP systems) to support pricing, purchasing, and sales reporting
• Create automated reporting for branch and location comparisons, slow-moving versus fast-moving SKUs, and seasonal demand trends, including HVAC seasonality
• Support rebate and vendor incentive program reporting and reconciliation
• Automate recurring reports for sales teams, purchasing managers, and branch operations to reduce manual Excel-based work
• Build and maintain data pipelines that feed the reporting and data warehouse layer from ERP, WMS, and e-commerce/B2B ordering platforms
• Monitor and validate data integrity across item master data, pricing tables, vendor catalogs, and multi-warehouse inventory records
• Troubleshoot discrepancies between systems, including ERP versus WMS inventory counts and EDI order data mismatches
• Support data cleanup initiatives for SKU rationalization, vendor part number cross-referencing, and pricing matrix accuracy
• Support and troubleshoot ERP reporting modules and vendor/manufacturer EDI transactions
• Maintain documentation for data sources, report logic, and distribution business rules such as pricing tiers, contract pricing, and rebate calculations
• Ensure reporting supports accurate sales tax, compliance, and audit needs across multi-state branch operations
• Collaborate with end users and sales leadership to gather reporting requirements tied to HVAC seasonality and product mix
• Communicate inventory and sales performance insights in a format suitable for non-technical branch staff
• Train counter and branch staff, along with sales representatives, on accessing dashboards and using self-service reporting tools

Requirements

• Bachelor’s degree in Information Systems, Business Analytics, or related field (or equivalent experience)
• Experience in a data or reporting analyst role, ideally within distribution, wholesale, or supply chain environments
• Proficiency in SQL, including complex queries and joins across ERP tables
• Experience using at least one BI tool, such as Power BI, Tableau, or Qlik
• Familiarity with distribution or wholesale ERP systems (Infor or similar)
• Understanding of inventory management concepts including turns, fill rate, min/max, and safety stock
• Strong analytical skills with attention to detail on pricing and margin data

Tools & Technologies

• ERP: Infor (including Infor CloudSuite)
• BI tools: Power BI, Tableau, Qlik
• Databases: SQL Server, Postgres, OpenEdge
• EDI: SPS Commerce, LBMX (or similar)
• Other: Excel, WMS reporting tools

Preferred Qualifications

• Familiarity with EDI transactions (850, 810, 856) with manufacturers and big-box customers
• Understanding of HVAC industry seasonality and its effect on inventory and sales cycles
• Experience with rebate or incentive program reporting
• Knowledge of Power BI, Python, or advanced Excel (Power Query, Power Pivot)
• Experience supporting multi-branch and multi-warehouse operations

Education

Bachelor’s degree in Information Systems, Business Analytics, or related field (or equivalent experience).

Location

Minneapolis, MN (onsite).

Compensation

USD 85,000 to 115,000 per year.