Data Analyst II

Headquartered in Waterloo, Iowa, VGM is a 100% employee-owned company providing business and professional services to thousands of business customers across North America. Services include group purchasing, commercial insurance, management of healthcare services and networks in post-acute cases, healthcare distribution direct to patient homes, specialty consulting, online education, digital, print, and traditional marketing and more. VGM employs approximately 1,700 people across 40 states and Canada, with more than 1,100 working in Iowa. VGM has been named the Top Workplace in Iowa on multiple occasions and is proud of its role in the communities in which it serves. For more information visit www.vgmgroup.com.

Position Summary

The Data Analyst II is part of the Data & Analytics team within VGM, with ad hoc analysis and decision support as the primary focus. Working across VGM’s centers of excellence, most closely with Fulfillment operations, Supply Chain, Customer Success, and Vendor Relations (including GPO), this role takes business questions from framing through recommendation and proactively surfaces savings, risks, and opportunities.

What’s more? At VGM Group, we are 100% employee owned. Click to view more about VGM!

Reporting Accountability: Vice President of Business Insights

Working Location: Waterloo, Iowa (in office) or Remote

Work Hours Classification: Full-time, exempt Monday-Friday 8-5 CT, occasional off-hours may occur when job duties require

Responsibilities/Duties of the Job

Ad hoc analysis and decision support:

• Serve as the primary resource for ad hoc analysis, independently taking ambiguous business questions through analysis and recommendation.
• Perform root-cause, variance, cost, and scenario analyses across fulfillment, supply chain, customer, vendor, and GPO performance.
• Define exception-monitoring rules, such as for billing errors and service risks, and investigate flagged items.
• Deliver actionable recommendations and help leaders measure the impact of resulting decisions.

Data and AI-enabled analytics:

• Write advanced SQL against governed sources, including Snowflake, and build analysis-specific datasets and prototype visuals as needed.
• Use approved generative AI tools, such as Microsoft Copilot, to accelerate analysis, validating all output and protecting PHI, PII, and confidential data.
• Partner with the Data Scientist on forecasting and predictive work and recommend practical AI use cases.

Collaboration and governance:

• Hand off recurring needs within VGM Data & Analytics: data pipelines and models to Data Engineering, and recurring reporting and dashboards to BI & Reporting.
• Partner with data stewards to define KPIs and business rules, escalate data quality issues, and document analyses so work is repeatable.
• Communicate findings through clear presentations, visuals, and written summaries.

Position Qualifications

Required:

• Bachelor’s degree in Analytics, Statistics, Computer Science, MIS, Business, or related field, or equivalent experience.
• Three or more years of experience in data or business analysis, independently delivering recommendations.
• Strong SQL and working knowledge of statistical techniques, including variance, forecasting, and scenario analysis.
• Proficiency with Excel and Power BI or Tableau, and hands-on experience using generative AI in analytical work.

Preferred:

• Experience in supply chain, customer, vendor, GPO, or healthcare analytics, and familiarity with HIPAA.
• Experience with Python or R, Snowflake, or AI features such as Copilot in Power BI or Snowflake Cortex.

Skills and competencies:

• Strong analytical and problem-solving skills, with comfort working through ambiguity.
• Business acumen to connect analysis to cost, revenue, service, and operational outcomes.
• Ability to tell a clear, defensible story with data to leadership and non-technical audiences.
• Strong stakeholder-management skills and sound judgment in using AI.

Physical Requirements:

• Desk-based computer work in an office or remote environment; occasional travel may be required for business-critical meetings or training.

This job description reflects the general duties of the job but is not a detailed description of all duties which may be inherent to the position. Reasonably related additional duties may be assigned to the individual Associate.

VGM Group, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.