Data Engineer

Paycom - ATS; Minneapolis (MN); On-site; USD 90,000 - 120,000; Full time

Job summary

Paycom - ATS is seeking a Data Engineer to build and maintain dashboards and data pipelines across sales, inventory, warehouse, and vendor systems. You will transform ERP and POS data into actionable insights for branch managers, purchasing teams, and leadership.

The role focuses on inventory decisions, pricing accuracy, and operational efficiency across the distribution network, with collaboration across end users and sales leadership.

Qualifications

• Bachelor's degree in information systems, business analytics, or related field.
• Experience as a data/reporting analyst in distribution, wholesale, or supply chain.
• Proficiency in SQL with complex queries and ERP joins.
• Experience with at least one BI tool (Power BI, Tableau, or Qlik).
• Familiarity with ERP systems (Infor or similar) and inventory concepts.

Responsibilities

• Design and maintain dashboards for distribution metrics (inventory turns, fill rates, branch sales).
• Write and optimize SQL queries against ERP data for pricing, purchasing, and sales reporting.
• Automate recurring reports for sales, purchasing, and branch operations.
• Maintain data pipelines from ERP, WMS, and e-commerce platforms to data warehouse.
• Support data quality, governance, and cross-system reconciliations.

Skills

SQL proficiency

BI tools experience

Analytical skills

End-user communication

Education

Bachelor's degree in Information Systems/Business Analytics or related field

Tools

Power BI

Tableau

Qlik

Infor ERP

SQL Server

Postgres

Job description

Position SummaryThe Data Engineer supports our distribution operations by building and maintaining reports, dashboards, and data pipelines across sales, inventory, warehouse, and vendor systems. This role transforms ERP and point-of-sale data into actionable insights for branch managers, purchasing, and executive leadership — helping drive smarter inventory decisions, pricing accuracy, and operational efficiency across our distribution network.Key ResponsibilitiesReporting & Analytics• Design and maintain dashboards for key distribution metrics: inventory turns, fill rates, branch sales performance, gross margin by product line, and vendor rebate tracking• Write and optimize SQL queries against ERP data (e.g., Infor CloudSuite, or similar distribution ERP) to support pricing, purchasing, and sales reporting• Build automated reporting for branch/location performance comparisons, slow-moving vs. fast-moving SKUs, and seasonal demand trends (critical in HVAC given seasonal sales cycles)• Support rebate and vendor incentive program reporting/reconciliation• Automate recurring reports for sales teams, purchasing managers, and branch operations to reduce manual Excel workData Management• Maintain data pipelines feeding from ERP, warehouse management system (WMS), and e-commerce/B2B ordering platforms into the reporting/data warehouse layer• Monitor data integrity across item master data, pricing tables, vendor catalogs, and multi-warehouse inventory records• Troubleshoot discrepancies between systems (e.g., ERP vs. WMS inventory counts, EDI order data mismatches)• Support data cleanup initiatives for SKU rationalization, vendor part number cross-referencing, and pricing matrix accuracySystems & Technical Support• Support and troubleshooting issue with ERP reporting modules, EDI transactions with vendors/manufacturersDocumentation & Compliance• Maintain documentation on data sources, report logic, and business rules specific to distribution workflows (pricing tiers, contract pricing, rebate calculations)• Ensure reporting supports accurate sales tax, compliance, and audit requirements across multi-state branch operationsCollaboration & Communication• Work directly with end users and sales leadership to understand reporting needs specific to HVAC seasonality and product mix• Present inventory and sales performance insights in a clear format for non-technical branch staff• Train counter/branch staff and sales reps on accessing dashboards and self-service reporting toolsRequired Qualifications• Bachelor's degree in Information Systems, Business Analytics, or related field (or equivalent experience)• Experience in a data/reporting analyst role, ideally within distribution, wholesale, or supply chain• Proficiency in SQL (complex queries, joins across ERP tables)• Experience with at least one BI tool (Power BI, Tableau, Qlik)• Familiarity with distribution/wholesale ERP systems (Infor, or similar)• Understanding of inventory management concepts (turns, fill rate, min/max, safety stock)• Strong analytical skills with attention to detail on pricing/margin dataPreferred 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/sales cycles• Experience with rebate/incentive program reporting• Knowledge of Power BI, Python, or advanced Excel (Power Query, Power Pivot)• Experience supporting multi-branch/multi-warehouse operationsTools & Technologies• 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