Business Analyst

Job Description

We Deliver the Goods:

• Competitive pay and benefits, including Day 1 Health & Wellness Benefits, Employee Stock Purchase Plan, 401K Employer Matching, Education Assistance, Paid Time Off, and much more

• Growth opportunities performing essential work to support America's food distribution system

• Safe and inclusive working environment, including culture of rewards, recognition, and respect

Position Details:

• This is a hybrid position with the expectation to work in the office 4 days per week

• Up to 10% travel required to other business locations

• Compensation: Up to $75,000 per year.

• Position Location: Westlake, TX

Business Analyst

We are seeking a detail-driven and analytical Business Analyst to support the design, execution, and administration of incentive-based compensation programs and people analytics. This role works closely with the Manager, Pay Program Analytics to ensure accurate incentive calculations, compensation reporting, and workforce data insights across sales, warehouse, and driver populations. This role will play a critical part in ensuring the integrity of compensation processes, enabling data-informed decision-making, and supporting ongoing improvements to HR systems and reporting.


Responsibilities:

Requirements Gathering & Analysis:

• Design, develop, and optimize enterprise-level Power BI solutions, including complex semantic data models, advanced DAX calculations, executive dashboards, scorecards, and self-service reporting capabilities to support strategic decision-making.

• Develop, optimize, and troubleshoot advanced SQL queries, views, stored procedures, and datasets to support compensation administration, workforce analytics, operational reporting, and data validation across multiple systems.

• Lead the design and implementation of automated business processes using Power Automate and Power Automate Desktop, reducing manual effort, improving process efficiency, and ensuring data accuracy and compliance.

• Design, develop, and maintain Power Apps solutions that streamline compensation administration, reporting workflows, approvals, data collection, and business operations while enhancing the user experience.

• Collaborate with HR, Finance, Sales, Operations, and IT stakeholders to identify business needs, translate requirements into technical solutions, and drive reporting and automation strategies.

• Manage data integration, transformation, validation, reconciliation, and quality assurance processes across HRIS, payroll, compensation, financial, and operational data sources to ensure data accuracy and reliability.

• Create and maintain comprehensive technical documentation, process maps, data definitions, business requirements, and solution designs to support reporting, analytics, and automation initiatives.

• Lead continuous improvement initiatives by evaluating existing processes, identifying automation opportunities, implementing scalable solutions, and promoting best practices in reporting, analytics, and process automation.

• Serve as the Power Platform subject matter expert for reporting, analytics, and automation solutions.

• Develop scalable reporting and automation frameworks that support enterprise growth and evolving business needs.

• Provide technical leadership and recommendations on Power BI, SQL, Power Apps, and Power Automate best practices.

• Identify and implement innovative automation solutions that improve operational efficiency, reporting accuracy, and business outcomes.

• Act as a liaison between business stakeholders and technical teams to define solution architecture and implementation strategies.

EEO Statement

Performance Food Group and/or its subsidiaries (individually or collectively, the "Company") provides equal employment opportunity (EEO) to all applicants and employees, regardless of race, color, national origin, sex, marital status, pregnancy, sexual orientation, gender identity, religion, age, disability, genetic information, veteran status, and any other characteristic protected by applicable local, state and federal laws and regulations. Please click on the following links to review: (1) our EEO Policy; (2) the "EEO is the Law" poster and supplement; and (3) the Pay Transparency Policy Statement.

Required Qualifications

Bachelor's degree in HR, Finance, Business, Analytics, Information Systems, Computer Science, or related field and 5+ years of experience in compensation administration, business analytics, reporting, business intelligence, or related analytical roles.


Advanced experience with Power BI, including data modeling, DAX, Power Query, and dashboard development. Advanced SQL skills required, including complex queries, data validation, and analysis. Experience developing solutions using Power Apps, Power Automate, and Power Automate Desktop.


Experience with UKG or similar HRIS/ERP systems preferred.


Demonstrated experience identifying and implementing process automation opportunities to improve business efficiency and reporting accuracy.


Strong understanding of data structures, relational databases, and reporting best practices.


Experience translating business requirements into reporting and automation solutions.


Strong analytical and problem-solving ability with attention to detail and accuracy.


Demonstrated experience building or supporting people and pay reporting and workforce analytics.


Excellent communication skills, with the ability to present data in a clear, concise, and impactful way.

Preferred Qualifications

Advanced SQL experience, including query optimization, data modeling, views, stored procedures, and complex data analysis.


Experience building scalable Power Platform solutions utilizing Power BI, Power Apps, Power Automate, and Power Automate Desktop.


Experience developing automated reporting and business process solutions that reduce manual effort and improve operational efficiency.


Experience working with large, complex datasets and designing solutions that ensure data integrity, performance, and usability.


Demonstrated ability to serve as a technical resource and business partner for reporting, analytics, and automation initiatives.


Familiarity with incentive compensation and variable pay programs.


Experience in sales operations, warehouse, or driver incentive environments is a plus.


Experience integrating data from HR, payroll, finance, and operational systems.


Knowledge of HR, compensation, incentive pay, workforce analytics, or people data models.

Company Description

Core-Mark continues to grow as the industry leader in fresh and broadline solutions for the convenience retail industry. With a reputation for empowering customers, employees, and communities, Core-Mark has become the largest, most comprehensive marketer of consumer goods in North America - offering a full range of products, programs, and solutions to convenience operators across the U.S. and Canada.