Procurement Business Intelligence Analyst

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

Positional Summary:

The Procurement Business Intelligence Analyst supports the development and continuous improvement of procurement analytics, reporting, process automation, and data management capabilities. Working closely with Procurement, Supply Chain, Engineering, Operations, Finance, and Information Technology teams, this role transforms data into actionable insights that improve business performance and decision-making. This position offers an opportunity to develop expertise in business intelligence, automation technologies, project management, and procurement processes within a global manufacturing environment.

Principal Accountabilities:

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

Minimum Requirements:

• Bachelor's Degree in Supply Chain Management, Business Analytics, Data Analytics, Information Systems, Industrial Engineering, Business Administration, Operations Management, or a related field.

• One (1) to Three (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.

Preferred Requirements:

• Exposure to Power BI, Power Platform, SQL, SAP, Python, or similar technologies.

• Exposure to procurement, supply chain, manufacturing, engineering, finance, or operations environments.

• Experience with ERP systems, business intelligence tools, or data management environments.

Skills and Abilities:

• Strong analytical thinking and problem-solving skills.

• Intellectual curiosity and willingness to learn new tools, technologies, and business processes.

• Effective communication and collaboration skills.

• Strong organization, attention to detail, and ability to manage multiple priorities.

• Training and development opportunities will be provided for candidates who demonstrate initiative, analytical aptitude, and a desire to grow professionally.

Physical Demands:

• Requires the ability to use a computer on a frequent basis.

• May remain stationary for extended periods but needs to be mobile enough to navigate through work areas.

• Ability to communicate clearly with fellow employees, suppliers, and business partners.

Universal Instruments is an EOE/M/F/Vet/Disabled employer

Target Annual Base Salary: $65,000 - $75,000 + Robust Benefits

~ What “U” Can Do For You ~

Rewards Package:

• Competitive Compensation, Bonus Strategies, 401k Retirement Contribution Matching, Health Savings Options with Monthly Company Contributions and Investment Capability, Flexible Spending Options, Objective Merits, and Relocation Assistance.

Career Development:

• Relevant Tuition, Upskilling, and Certification Reimbursement, Mentorship, Educational Institution Relations, Career Pathing.

Work/Life Balance:

• Competitive Paid Time Off, Paid Holidays, and Wellness Hours.

Health & Wellbeing:

• Comprehensive Medical, Dental, Vision, Life, Disability, Employee Assistance Plan (“EAP”) and Other Supplemental Coverage Options.

Company Culture:

• Professional and Respectful Work Environment Driven by Our “6-C’s” Core Values: Customer-Centric, Collaboration, Creativity, Character, Courage, and Community.