Procurement Data Analyst

Sun Communities•Southfield, MI

21h•Onsite

About The Position

The Procurement Data Analyst transforms procurement data into actionable insights that drive strategic sourcing, operational efficiency, and supplier performance. This role also supports the supplier lifecycle, including data governance and onboarding processes, to ensure a smooth and compliant supplier setup experience. Responsibilities also include creating, maintaining, and optimizing product and service catalogs within the company’s procurement systems. This role ensures catalog accuracy, contract compliance, and an intuitive end-user buying experience. The analyst partners closely with suppliers, category managers, and internal stakeholders to support strategic sourcing initiatives and drive high levels of procurement adoption.

Requirements

High School Diploma or GED (Required)
Bachelor's Degree in Business, Supply Chain, Data Analytics, Finance or related field (Required)
2 years in experience in procurement analytics, strategic sourcing support, or supplier master data (Required)
Strong Excel skills (VLOOKUP/XLOOKUP, pivot tables, data cleansing), including data modeling and Power Query
Experience with BI tools (Domo, Power BI, Tableau)
Excellent communication skills, able to simplify complex data for stakeholders
Ability to collaborate effectively across Procurement, Accounting/Finance, IT, and Operations
High attention to detail and data accuracy
Strong analytical and problem‑solving skills
Process‑improvement mindset and comfort working with technology-driven workflows
Must have a valid driver's license

Nice To Haves

Knowledge of procurement systems such as Coupa, SAP Ariba, Oracle, Workday, or SAP (Preferred)
Familiarity with product classification standards (UNSPSC, commodity codes) (Preferred)
Familiarity with SQL or Python (Preferred)

Responsibilities

Develop and automate procurement dashboards (spend, savings, supplier key performance indicators, category insights) including reporting packages for leadership, procurement, and other stakeholders.
Conduct routine data quality checks to ensure accuracy and completeness.
Serve as a procurement data tools expert (Domo, NetSuite, Coupa, etc.).
Develop program/supplier scorecards and key performance indicator dashboards and ensure timely publishing.
Coordinate and support the full supplier onboarding process, ensuring timely collection of required documentation (W9, certificates, contacts, catalog data).
Validate supplier information for accuracy, completeness, and compliance before system setup.
Build, update, and maintain supplier catalogs (hosted and punchout) within the procurement platform.
Consolidate, validate, and rationalize data from enterprise resource planning (ERP), procurement, and finance systems.
Identify supplier performance risks through analytics and trend monitoring.
Partner with IT to enhance data pipelines, integrations, and system automation, as well as resolve punchout configuration issues and system errors.
Maintain and monitor supplier master data, ensuring proper categorization, taxonomy alignment, diversity classification, and risk attributes.
Track onboarding cycle times, identify bottlenecks, and recommend process or system improvements.
Support implementation of supplier self-service portals and workflow automation.
Ensure data integrity by performing routine audits of supplier records.
Validate and ensure the accuracy of item data including pricing, SKU numbers, unit of measure, descriptions, category and United Nations Standard Products and Services Code (UNSPSC) coding, and contract mappings.
Manage catalog content using Coupa tools and feedback to ensure catalogs are active and up to date, while coordinating with suppliers on scheduled content updates.
Serve as the primary point of contact for suppliers regarding catalog onboarding, updates, and troubleshooting.
Review and approve supplier-submitted catalogs to ensure adherence to company standards and compliance requirements.
Work with category managers to translate sourcing strategies into catalog setup and guided buying pathways.
Perform data cleansing activities to eliminate inconsistencies and duplicate items.
Audit catalog updates against contract terms to identify pricing discrepancies or outdated items while ensuring compliance with procurement policies, preferred supplier strategies, and internal controls.
Monitor catalog utilization and identify opportunities to reduce maverick spend.
Other duties as assigned.

Benefits

Comprehensive Medical and Prescription coverage with 4 plan options so you can choose the plan that best meets the needs of you and your family
Comprehensive Dental and Vision Plans
On-Site Fitness Center
Voluntary Health and Dependent Care Reimbursement Accounts
Life, Accidental Death & Dismemberment Insurance and Dependent Life
Short and Long-Term Disability Coverage
401(k) Plan with Sun matching contribution
Employee Assistance Program
Identity Theft Insurance
Legal Assistance Plan
Pet Insurance
Tuition Reimbursement program providing financial support to team members who further their formal education
Vacation RV Site Discounts for team members when visiting SunRV Resorts across the nation
Team Member Perks & Discounts program with hundreds of discounts on things like travel, merchandise, mobile phone service, and more
Up to six weeks of paid parental leave for the birth of a child, adoption, or placement of a child
Paid Time Off including ten holidays, vacation, personal, sick time, bereavement and pay for jury duty