Business Systems & Reporting Analyst at MBG Marketing · Grand…

Description

Position Purpose

The Business Systems & Reporting Analyst is responsible for supporting MBG’s business applications and develops reliable reports that help employees understand information, resolve problems, and improve business processes. The position 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, as well as third-party applications, including Business Central, Aptean, Agrian, and other assigned systems.

Organizational Relationships

Direct Supervisor: Manager of Business Applications

Significant Relationships: MBG Staff, IT Staff, growers, packers, vendors, consultants, and business partners as assigned.

Locations

1. Grand Junction, MI

Accountabilities and Responsibilities

1. 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.
2. Write and troubleshoot SQL queries to retrieve business data, support operational reporting, investigate discrepancies, and validate results against source transactions and agreed business rules.
3. Work with business users to understand reporting needs, document requirements and calculation logic, and confirm that reports accurately support business processes.
4. Provide functional support for MBG’s 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 systems as assigned.
5. 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.
6. Provide application support across MBG locations and time zones, including packers operating on Pacific Time.
7. Monitor assigned report refreshes, Microsoft Fabric data processes, application jobs, and interfaces using established procedures. Investigate routine failures and coordinate resolution with the appropriate technical owners or implementation partners.
8. Provide onboarding application training and guidance. Create and maintain user guides, standard operating procedures, troubleshooting instructions, and knowledge base articles.
9. 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.
10. Document business requirements and workflows. Identify opportunities to improve reports, reduce repetitive spreadsheet work, and move manual processes into approved business applications or automation tools.
11. 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 the appropriate IT staff.
12. Investigate data-entry errors, incomplete records, and transaction exceptions. Coordinate corrections with business owners and follow approved data-quality controls.
13. 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.
14. Maintain assigned project tasks, milestones, issue logs, and status updates. Communicate risks and blockers, recommend improvements.
15. Complete other duties/projects assigned by Manager.

Requirements

Qualifications and Skills Required

1. Bachelor’s degree in information systems, business, computer science, or a related field, or an equivalent combination of education and relevant experience.
2. 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.
3. Working SQL skills, including joins, filtering, grouping, and aggregate calculations; ability to investigate missing or duplicated records and reconcile report totals to source data.
4. Ability to troubleshoot application and reporting issues methodically, document findings, explain results clearly, and follow issues through to resolution.
5. Ability to learn business processes and translate user needs into practical reports, support solutions, and process improvements.
6. Strong communication, customer service, organization, and attention to detail; ability to manage competing requests and recognize when escalation is needed.
7. Proficiency with Microsoft 365, particularly Excel, Outlook, and Teams, including Excel formulas, tables, and PivotTables.
8. Ability to work collaboratively with business users, technical staff, and vendors while maintaining professionalism, confidentiality, accuracy, and consistent follow-through.

Physical Demand (With or without accommodations)

1. Ability to work at a computer for extended period
2. Participate in meetings and training
3. Occasionally walk or stand in office, warehouse, or packinghouse settings
4. Up to 10% travel, occasionally to MBG locations
5. Occasionally lift or carry equipment or materials weighing up to 25 pounds.
6. Support needs may extend beyond regular office hours.
7. 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.

Location: Grand Junction, MI

Hours: Full-time, Exempt