Business Systems, Data & Automation Manager

The Business Systems, Data & Automation Manager is responsible for designing, developing, maintaining, and continuously improving Frontier Distributing’s business technology ecosystem. This role serves as a strategic bridge between operations, technology, data, and decision-making across all departments of the organization.

This position oversees business reporting, operational analytics, ERP integrations, process automation, AI implementation initiatives, e-commerce systems, custom application development, and enterprise workflow optimization. The role is heavily involved in identifying inefficiencies, architecting scalable solutions, and leveraging data and technology to improve operational performance, visibility, and decision-making throughout the company.

The Business Systems, Data & Automation Manager partners with leadership and departmental stakeholders to modernize workflows, automate manual processes, improve data accessibility, integrate systems, and drive innovation across the organization.

This role requires both high-level business understanding and strong technical capability, including database management, software development, systems integration, automation technologies, and emerging AI tools.

Responsibilities & Essential Functions

• Design, develop, and maintain enterprise reporting solutions for operational, financial, inventory, sales, logistics, purchasing, and executive reporting.

• Build automated dashboards, reports, and data delivery systems.

• Create and optimize SQL queries, stored procedures, data views, and reporting structures.

• Ensure data accuracy, integrity, consistency, and usability across systems.

• Identify inefficiencies and implement automation solutions to eliminate manual work.

• Design and maintain automated workflows, scheduled jobs, integrations, and data processes.

• Develop custom tools, scripts, and applications to improve operational efficiency.

• Research, evaluate, and implement AI technologies to improve operational effectiveness and decision-making.

• Develop AI-assisted workflows, reporting enhancements, content generation processes, and business tools.

• Manage integrations between ERP systems, databases, e-commerce platforms, third-party applications, and internal tools.

• Support and enhance ERP functionality through custom development and reporting solutions.

• Support and enhance Frontier’s e-commerce platforms, including Shopify and related integrations.

• Develop and maintain internal business applications, utilities, scripts, and automation tools.

• Partner with leadership and department managers to identify operational challenges and technology opportunities.

• Establish and maintain best practices for data governance, validation, consistency, and accessibility.

• Lead or participate in special projects and strategic initiatives.

• Stay current on industry trends, technologies, and best practices related to automation, analytics, AI, and business systems.

Do you have experience in Workflow management (operations management method)?, Do you have a Bachelor’s degree?, * Advanced knowledge of SQL Server, relational databases, and data architecture.

• Strong experience with business intelligence, analytics, and enterprise reporting.

• Experience with automation technologies, scripting, and workflow design.

• Experience integrating business systems, APIs, and third-party platforms.

• Working knowledge of AI technologies, prompt engineering, and intelligent automation concepts.

• Experience with Shopify, e-commerce systems, and operational integrations preferred.

• Proficiency with Python, PowerShell, Excel/VBA, JSON, HTML/CSS, and related technologies preferred.

• Strong analytical thinking and problem-solving ability.

• Ability to manage multiple concurrent projects and priorities.

• Strong understanding of business operations, inventory, purchasing, logistics, sales, and distribution workflows.

• Excellent communication skills with the ability to explain technical concepts clearly.

• Ability to work independently and drive initiatives with minimal supervision.

• Strong organizational and documentation skills.

• Demonstrated ability to translate business problems into scalable technical solutions.

Education & Experience Requirements

• Bachelor’s degree in Information Systems, Computer Science, Business Analytics, Data Management, or related field preferred.

• Equivalent combination of education, technical expertise, and relevant business experience may be considered.

• 5+ years of experience in business systems, analytics, automation, software development, data management, or related technical roles preferred.

• Experience in distribution, supply chain, wholesale, logistics, or operational business environments preferred.