Business Systems & Reporting Analyst

MBG Marketing®; Grand Junction (MI); On-site; USD 70,000 - 95,000; Full time

Job summary

MBG Marketing in Grand Junction, MI is seeking a Business Systems & Reporting Analyst to support MBG’s business applications and develop reliable Power BI reports. You will combine hands-on report development, SQL querying, and data validation with user support, testing, documentation, and training.

This role collaborates with MBG staff across locations and systems such as Grower Portal and Business Central, providing on-site support, onboarding guidance, and ongoing improvements to reporting

Qualifications

• Hands-on experience developing and maintaining Power BI reports.
• Experience with Power Query transformations and DAX measures.
• SQL skills to retrieve data and reconcile report totals.
• Troubleshoot reporting and application issues methodically.
• Translate user needs into practical reports and improvements.
• Strong communication and organizational skills.
• Proficiency with Microsoft 365 apps including Excel.

Responsibilities

• Develop, validate, and troubleshoot Power BI reports and dashboards.
• Write and optimize SQL queries and validate results against source data.
• Gather requirements from business users and document calculation logic.
• Provide functional support for MBG’s applications and third‑party systems.
• Log, prioritize, and track issues; coordinate resolutions with IT vendors.
• Create user guides and deliver onboarding training.
• Support changes through testing, rollout, and post‑launch follow‑ups.

Skills

Power BI report development

SQL querying

Data validation

Documentation

Training

Communication

Team collaboration

Education

Bachelor’s degree in information systems, business, computer science, or related field

Tools

Power BI

SQL

Microsoft 365

Excel

Job 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.

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

• Grand Junction, MI

Accountabilities And 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 that reports accurately support business processes.
• 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.
• 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 using established procedures. Investigate routine failures and coordinate resolution with the appropriate technical owners or implementation partners.
• Provide onboarding application training and guidance. 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. 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 the 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, recommend improvements.
• Complete other duties/projects assigned by Manager.

Requirements

Qualifications and Skills Required

• 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.

Physical Demand (With or without accommodations)

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