Business Systems & Reporting Analyst

MBG Marketing•Columbia Township, MI

19h•Onsite

About The Position

The Business Systems & Reporting Analyst supports MBG’s business applications and develops reliable reports to help employees understand information, resolve problems, and improve business processes. The role combines hands-on Power BI report development, SQL querying and data validation with application troubleshooting, user support, testing, documentation, and training. The application portfolio includes internally developed systems such as the Grower Portal, warehouse management and packinghouse systems, and third-party applications including Business Central, Aptean, Agrian, and other assigned systems. The position supports users across MBG locations and time zones, monitors assigned reports, data processes, application jobs, and interfaces, and coordinates issue resolution with technical owners, IT staff, vendors, and business users. The role is based in Grand Junction, Michigan, is full-time and exempt, and may include assigned on-call coverage for MBG’s 24/7 operations.

Requirements

Bachelor’s degree in information systems, business, computer science, or a related field, or an equivalent combination of education and relevant experience.
Demonstrated hands-on experience developing and maintaining Power BI reports, including Power Query transformations, basic DAX measures, and an understanding of table relationships and filters.
Working SQL skills, including joins, filtering, grouping, and aggregate calculations; ability to investigate missing or duplicated records and reconcile report totals to source data.
Ability to troubleshoot application and reporting issues methodically, document findings, explain results clearly, and follow issues through to resolution.
Ability to learn business processes and translate user needs into practical reports, support solutions, and process improvements.
Strong communication, customer service, organization, and attention to detail; ability to manage competing requests and recognize when escalation is needed.
Proficiency with Microsoft 365, particularly Excel, Outlook, and Teams, including Excel formulas, tables, and PivotTables.
Ability to work collaboratively with business users, technical staff, and vendors while maintaining professionalism, confidentiality, accuracy, and consistent follow-through.
Ability to work at a computer for extended periods, participate in meetings and training, and occasionally walk or stand in office, warehouse, or packinghouse settings.
Occasionally lift or carry equipment or materials weighing up to 25 pounds.
Travel up to 10%, occasionally to MBG locations.
Support needs may extend beyond regular office hours; participate in assigned on-call coverage, including evenings, weekends, and holidays.

Responsibilities

Develop, maintain, and troubleshoot Power BI reports and dashboards using approved data sources and semantic models; use Power Query and DAX to prepare data and implement business calculations in coordination with Enterprise Data and Analytics.
Write and troubleshoot SQL queries to retrieve business data, support operational reporting, investigate discrepancies, and validate results against source transactions and agreed business rules.
Work with business users to understand reporting needs, document requirements and calculation logic, and confirm reports accurately support business processes.
Provide functional support for internally developed applications, including the Grower Portal, warehouse management and packinghouse systems, and related mobile and QC tools; support third-party applications including Business Central, Aptean, Agrian, and other assigned systems.
Log, prioritize, and track application support requests through resolution; troubleshoot errors, transaction issues, and workflow problems; document findings, keep users informed, and coordinate escalations with IT staff or vendors.
Provide application support across MBG locations and time zones, including packers operating on Pacific Time.
Monitor assigned report refreshes, Microsoft Fabric data processes, application jobs, and interfaces; investigate routine failures and coordinate resolution with appropriate technical owners or implementation partners.
Provide onboarding application training and guidance, and create and maintain user guides, standard operating procedures, troubleshooting instructions, and knowledge base articles.
Support application changes and releases through assigned testing, user acceptance testing coordination, rollout assistance, and post-launch follow-up; prepare user communications under the manager’s direction.
Document business requirements and workflows and identify opportunities to improve reports, reduce repetitive spreadsheet work, and move manual processes into approved business applications or automation tools.
Support business use of Microsoft 365 tools, including Excel, Outlook, Teams, SharePoint, Power Automate, and Forms; assist with identifying opportunities to simplify manual processes in coordination with appropriate IT staff.
Investigate data-entry errors, incomplete records, and transaction exceptions; coordinate corrections with business owners and follow approved data-quality controls.
Coordinate approved application access requests and onboarding, role-change, and offboarding tasks with the manager and Systems Administrator; protect confidential information and follow security, access, and change control standards.
Maintain assigned project tasks, milestones, issue logs, and status updates; communicate risks and blockers and recommend improvements.
Complete other duties and projects assigned by the Manager.
Participate in assigned on-call coverage for MBG’s 24/7 operations, including evenings, weekends, and holidays, and coordinate escalation with other IT staff or vendors as needed.