MRO Material Data and Reporting Specialist

The Ideal Group • Warren, MI

5h • Onsite

About The Position

The MRO Material Data and Reporting Specialist will investigate material master and purchasing issues, interfacing as needed with manufacturers, Manufacturing & Engineering (M&E), and plant requestors. This role will coordinate and lead meetings related to these investigations, support the TCS/IMPAC maintenance team on edge case scenarios, and assist M&E spare parts coordinators and purchasing. The specialist will solve complex or nonstandard scenarios, effectively communicate solutions to stakeholders, and handle escalations independently to customer and Ideal leadership. When resolution is not possible, the role requires clearly articulating the issue and next steps. This is an in-person position at the GM Global Tech Center – Cole Engineering Building.

Requirements

• Comfortable working with large datasets in spreadsheets.
• Working knowledge of core Excel functions (basic formulas, PivotTables, VLOOKUP/XLOOKUP).
• Ability to organize, validate, and reconcile data for analysis and reporting.
• Strong verbal and written communication skills.
• Ability to lead working sessions or meetings and clearly articulate findings.
• Proven ability to coordinate with multiple stakeholders across functions and projects.
• Foundational understanding of Indirect Materials or spare parts.
• Familiarity with plant, M&E, or purchasing processes.
• Ability to translate business needs into data requirements and insights.
• Experience or working knowledge of SAP and/or DCC environments.
• Power BI experience (report creation, dashboards, basic modeling).
• Ability to present data visually in a way that supports decision-making.
• Analytical mindset.
• Curious, detail-oriented, and comfortable investigating data anomalies.
• Able to identify trends, risks, and improvement opportunities from complex datasets.
• Ability to sit at a desk for extended durations.
• Ability to view and use a computer screen (or multiple screens) for prolonged periods.
• Bachelor’s or associate degree in supply chain, Engineering, Business, or a related field.
• 2+ years of experience in a MRO materials master role, preferably within manufacturing, maintenance, or supply chain environments.
• Ability to demonstrate strong interpersonal skills, oral or written.
• Ability to handle multiple priorities by meeting deadlines.

Responsibilities

• Collaborate directly with the GM Materials Coding Team to investigate and resolve part identification and material set-up issues.
• Design, build, and maintain interactive dashboards and reports using Databricks' native visualization tools, Power BI, or other business intelligence (BI) platforms, with direction from the GM Materials Coding team and customer leadership.
• Research and resolve spare part issues with maintenance, engineering, and procurement teams to facilitate accurate part set-ups.
• Support digital transformation or system upgrades (e.g., SAP, Maximo, TCS/IMPAC) by obtaining and validating MRO data.
• Assist with master data governance by ensuring part numbers, descriptions, units of measure, and classifications are consistent and accurate.
• Identify opportunities for standardization and rationalization of parts across multiple sites or equipment platforms.
• Provide insights to support material master data coding strategies.
• Present projects to customers and internal leadership.
• Attend meetings as required.
• Maintain a safe work environment and a team culture of safety.

Benefits

• Medical insurance (Blue Cross Blue Shield PPO, HMO and Health Savings plan options available)
• Dental coverage
• Vision coverage
• Life insurance
• Short-term disability
• Long-term disability plans
• Paid time off
• 401K plan

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree