Procurement BI Analyst: Dashboards, Analytics & Automation

Ontario Trillium Foundation; City of Rochester (NY); On-site; USD 65,000 - 75,000; Full time

Benefits offered by this job

Competitive compensation

Job summary

Universal Instruments is seeking a Procurement Business Intelligence Analyst to drive analytics, dashboards, and automation across procurement, supply chain, engineering, and finance. You will transform data into insights that improve decision-making in a global manufacturing context.

In this role you will build Power BI dashboards, analyze supplier data, support Power Platform automation, ensure data quality, and collaborate with cross-functional teams on process improvements.

Qualifications

• Bachelor's degree in Supply Chain Management, Business Analytics, Data Analytics, Information Systems, Industrial Engineering, Business Administration, Operations Management, or a related field.
• 1–3 years of experience in analytics, business systems, supply chain, procurement, operations, engineering, finance, or a related field.
• Experience creating reports, dashboards, analyses, or process documentation.
• Experience participating in cross-functional projects, process improvement activities, or continuous improvement initiatives, and/or lean six sigma activities.
• Analytical and problem-solving skills with ability to learn new technologies, systems, and business processes.
• Proficiency with Microsoft Excel and other Microsoft Office applications.

Responsibilities

• Develop and maintain procurement dashboards, scorecards, and reports using Power BI and other tools.
• Analyze procurement, supplier, and operational data to identify trends, risks, and opportunities for improvement.
• Support development of automated reporting and workflows using Power Platform and related technologies.
• Assist in improving data quality, reporting consistency, supplier data management, and system integration.
• Collaborate with cross-functional teams to identify and implement process improvements and automation.
• Support strategic procurement initiatives, including End-of-Life (EOL) management, supplier data integration, and reporting modernization projects.
• Prepare and present analyses, project updates, and recommendations to stakeholders and management.
• Participate in project planning, tracking, and implementation, while developing project management skills.
• Receive mentorship and development opportunities in BI analytics, automation, and procurement processes.
• Perform other related duties as required.

Skills

Analytical thinking

Curiosity

Communication

Organization

Initiative & learning

Education

Bachelor's degree in related field

Tools

Power BI

Power Platform

SQL

SAP

Python

ERP systems

BI tools

Job description

Universal Instruments is seeking a Procurement Business Intelligence Analyst to drive analytics, dashboards, and automation across procurement, supply chain, engineering, and finance. You will transform data into insights that improve decision-making in a global manufacturing context.

In this role you will build Power BI dashboards, analyze supplier data, support Power Platform automation, ensure data quality, and collaborate with cross-functional teams on process improvements.