Senior Data & Analytics Analyst - Vendor & Category Performance

Patterson Companies; Saint Paul (MN); Hybrid; USD 90,000 - 120,000; Full time

Job summary

Patterson Companies in Saint Paul, MN, is seeking a Senior Data & Analytics Analyst to advance its data-driven culture through BI, analytics, and AI-enabled solutions. You will partner with Vendor Management, Category Management, Marketing, Finance, and Sales to transform enterprise data into actionable insights that drive vendor, product, and commercial performance.

The ideal candidate offers strong technical analytics skills, business acumen, and the ability to translate complex data into

Qualifications

• Bachelor's degree in Business Analytics, Finance, Economics, Data Analytics, Information Systems, Statistics, or a related field.
• 5+ years of experience in business intelligence, data analytics, commercial analysis, financial analysis, or a related field.
• Strong SQL and advanced Excel skills.
• Experience with Power BI or a comparable BI/reporting platform.
• Strong analytical, problem-solving, data visualization, and data storytelling skills.
• Understanding of revenue, gross profit, margin, price, volume, cost, and product mix.
• Ability to translate complex data into actionable business recommendations.
• Strong communication and relationship-building skills with both technical and non-technical audiences.
• Familiarity with AI-enabled analytics and modern data platforms.

Responsibilities

• Develop scalable reporting, dashboards, visualizations, and analytics solutions using enterprise data.
• Partner with business leaders to understand requirements, identify analytics gaps, and deliver actionable insights.
• Independently query, analyze, and interpret complex data using SQL and BI tools.
• Replace manual spreadsheet-based reporting with automated, scalable, and self-service solutions.
• Perform ad hoc analysis, data mining, and trend analysis to identify opportunities and risks.
• Analyze vendor, product, pricing, revenue, margin, volume, cost, and product-mix performance.
• Develop analytics supporting vendor management, category management, and commercial decisions.
• Analyze vendor rebates, incentives, and other commercial programs.
• Provide insights into customer acquisition, promotions, and marketing performance.
• Identify key drivers of performance and translate findings into business recommendations.
• Support the adoption of AI-enabled analytics and emerging BI/data capabilities.

Skills

SQL

Excel

Power BI

Analytics

Communication

Finance acumen

Education

Bachelor's degree

Tools

Microsoft Fabric

Azure

Databricks

DAX

Power BI semantic models

Job description

Patterson isn't just a place to work, it's a partner that cares about your success.

One of the distinguishing marks of our company is the talented people who embrace the people-first, always advancing, and results-driven culture. Professional growth abounds in this motivating environment. We value the diverse talents and experiences our employees bring to Patterson and believe that they build a stronger and successful organization.

Senior Data & Analytics Analyst - Vendor & Category Performance

Position Summary

The Senior Data & Analytics Analyst plays a key role in advancing Patterson's data-driven culture through business intelligence, analytics, and AI-enabled solutions. This role partners with Vendor Management, Category Management, Marketing, Finance, Sales, and executive leadership to transform enterprise data into actionable insights that improve vendor, product, customer, and commercial performance.

The ideal candidate combines strong technical analytics skills with business and financial acumen and can translate complex data into clear recommendations for both business leaders and technical teams.

Ideal candidate will work in a hybrid capacity for the office in St. Paul, MN

Key Responsibilities

Business Intelligence & Analytics

• Develop scalable reporting, dashboards, visualizations, and analytics solutions using enterprise data.
• Partner with business leaders to understand requirements, identify analytics gaps, and deliver actionable insights.
• Independently query, analyze, and interpret complex data using SQL and BI tools. Strong Data Fulfillment experience/knowledge
• Replace manual spreadsheet-based reporting with automated, scalable, and self-service solutions.
• Perform ad hoc analysis, data mining, and trend analysis to identify opportunities and risks.

Vendor, Product & Commercial Performance

• Analyze vendor, product, pricing, revenue, margin, volume, cost, and product-mix performance.
• Develop analytics supporting vendor management, category management, and commercial decisions.
• Analyze vendor rebates, incentives, and other commercial programs.
• Provide insights into customer acquisition, promotions, and marketing performance.
• Identify key drivers of performance and translate findings into business recommendations.

AI & Innovation

• Support the adoption of AI-enabled analytics and emerging BI/data capabilities.
• Explore opportunities to leverage GenAI, analytical copilots, and automation to improve reporting and decision-making.
• Help advance Patterson's overall analytics maturity and self-service capabilities.

Business Partnership & Communication

• Work closely with cross-functional teams and senior leadership to address business questions and opportunities.
• Communicate analytical findings through clear, executive-level presentations and detailed visualizations.
• Participate in larger cross-functional initiatives and continuously improve analytics processes and solutions.

Required Qualifications

• Bachelor's degree in Business Analytics, Finance, Economics, Data Analytics, Information Systems, Statistics, or a related field .
• 5+ years of experience in business intelligence, data analytics, commercial analysis, financial analysis, or a related field.
• Strong SQL and advanced Excel skills.
• Experience with Power BI or a comparable BI/reporting platform.
• Strong analytical, problem-solving, data visualization, and data storytelling skills.
• Understanding of business and financial measures such as revenue, gross profit, margin, price, volume, cost, and product mix.
• Ability to translate complex data into actionable business recommendations.
• Strong communication and relationship-building skills with both technical and non-technical audiences.
• Familiarity with AI-enabled analytics and modern data platforms.

Preferred Qualifications

• Experience with vendor, supplier, category, product, pricing, promotional, rebate, or commercial analytics.
• Experience with Microsoft Fabric, Azure, Databricks, Power BI semantic models, or DAX.
• Experience with GenAI, analytical copilots, or AI-enabled BI platforms.
• Experience working with third-party market or competitive data.
• Experience in distribution, manufacturing, healthcare, dental/medical device, CPG, retail, or other product-intensive industries.

Success in This Role

Success will be measured by reducing manual reporting, increasing automated and self-service analytics, improving visibility into vendor/product/customer performance, accelerating executive reporting, and delivering actionable insights that influence vendor, category, marketing, and commercial decisions.

Working Conditions

Physical Demands

Operating a computer or other office devices for the majority of the workday

May occasionally need to move packages up to 10 pounds such as office supplies or equipment

Must be able to communicate with others in person, over the phone, and in writing.

Must be able to understand and effectively exchange accurate information with othe