Data Engineer

Goodin Company offers an onsite Data Engineer role in Minneapolis, MN focused on improving distribution operations through reliable reporting and data pipelines. You will help turn ERP, warehouse, and ordering data into dashboards and automated insights that support inventory decisions, pricing accuracy, and operational efficiency. With a salary range of USD 85,000 to 115,000 per year, this position also includes hands-on collaboration with sales and branch leadership to address reporting needs across seasonal HVAC workflows.

What you’ll do

• Design and maintain dashboards for key distribution metrics, including inventory turns, fill rates, branch sales performance, gross margin by product line, and vendor rebate tracking
• Write and optimize SQL queries against ERP data (such as Infor CloudSuite or similar distribution ERP) for pricing, purchasing, and sales reporting
• Build automated reporting comparing branch and location performance, highlighting slow-moving vs. fast-moving SKUs, and tracking seasonal demand trends
• Support rebate and vendor incentive program reporting and reconciliation
• Automate recurring reports for sales, purchasing managers, and branch operations to reduce manual Excel effort
• Maintain data pipelines that feed a reporting/data warehouse layer from ERP, WMS, and e-commerce/B2B ordering platforms
• Monitor data integrity across item master data, pricing tables, vendor catalogs, and multi-warehouse inventory records
• Troubleshoot discrepancies between systems, such as ERP versus WMS inventory counts and EDI order data mismatches
• Support data cleanup for SKU rationalization, vendor part number cross-referencing, and pricing matrix accuracy
• Support and troubleshoot ERP reporting modules and EDI transactions with vendors/manufacturers
• Document data sources, report logic, and distribution-specific business rules (pricing tiers, contract pricing, rebate calculations)
• Ensure reporting supports accurate sales tax, compliance, and audit requirements across multi-state branch operations
• Work with end users and sales leadership to capture reporting needs tied to HVAC seasonality and product mix
• Present inventory and sales insights clearly for non-technical branch staff and train counter/branch staff and sales reps on dashboard access and self-service reporting

What you bring

• Bachelor’s degree in Information Systems, Business Analytics, or a related field (or equivalent experience)
• Experience in a data/reporting analyst role, ideally in distribution, wholesale, or supply chain
• Proficiency in SQL, including complex queries and joins across ERP tables
• Experience with at least one BI tool: Power BI, Tableau, or Qlik
• Familiarity with distribution/wholesale ERP systems such as Infor or similar solutions
• 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

Technologies you’ll use

SQL, Power BI, Tableau, Qlik, Infor, Infor CloudSuite, SQL Server, Postgres, OpenEdge, SPS Commerce, LBMX, Excel, and WMS reporting tools, plus EDI and ERP reporting module support.

Preferred qualifications

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

ERP: Infor
BI Tools: Power BI / Tableau / Claude AI
Databases: SQL Server / Postgres / OpenEdge
EDI: SPS Commerce, LBMX or similar
Other: Excel, WMS reporting tools