Data Analyst - Materials Management

Metropolitan Companies is seeking a Materials Data Analyst to join our growing team! This role is ideal for someone with experience in data management, database administration, and business intelligence—particularly Power BI—who is ready to make an impact by optimizing the systems that drive our material procurement processes.

We offer a competitive benefits package, including medical, dental, vision, life, short- and long-term disability, holiday pay, PTO, bonus opportunities, 401(k), and more. If you're detail-oriented, technically skilled, and thrive in a fast-paced, collaborative environment, this opportunity is for you!

Key Responsibilities:

• Administer and maintain the SKU and materials database across internal platforms.
• Design and maintain dashboards and reports in Power BI to visualize procurement trends, shortages, and vendor performance.
• Manage and optimize data flows between Excel, ERP systems, and business intelligence platforms.
• Analyze material data to identify patterns, anomalies, and areas for process improvement.
• Partner with preconstruction and purchasing teams to deliver procurement status and forecasting reports.
• Troubleshoot and resolve material-related data integrity or system issues.
• Track materials, overages, and shortages across job sites and warehouse inventories.
• Conduct regular audits of data sources and reporting tools to ensure data integrity and consistency across systems.
• Identify opportunities to streamline data workflows and implement solutions to enhance system performance and reporting accuracy.
• Perform other duties as assigned by the supervisor.

Competencies:

• Experience managing large datasets and material databases (Excel, Access, or SQL-based tools).
• Proficient in Power BI with the ability to build reports from raw data.
• Strong analytical and problem-solving skills.
• Excellent communication and cross-departmental collaboration abilities.
• Highly organized with the ability to manage multiple projects and deadlines.
• Proactive, self-motivated, and process improvement-minded.
• AI experience.

Education & Experience Requirements:

• High school diploma or GED required;
• Bachelor’s degree in IT, Data Science, Supply Chain, or a related field preferred.
• 2 years of experience in database management, inventory systems, or a similar data-focused role.
• Familiarity with construction materials or vendor management is a plus.
• Proficient in Microsoft Office (especially Excel) and Outlook.
• Experience with SQL or other data querying tools.

Benefits:

• Medical / Dental / Vision Insurance
• Voluntary Life, Short- and Long-Term Disability
• Health Savings Account (HSA)
• 401(k) with Company Match
• Paid Time Off & Holiday Pay
• Annual Bonus Program
• Employee Referral Bonus

Job Type: Full-time

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Vision insurance

Schedule:

• Monday to Friday

Experience:

• Database management: 2 years (Preferred)

Work Location: In person