Customer Analytics Analyst | Power BI, VBA & Automation

Vallen Distribution; Belmont (NC); On-site; USD 70,000 - 90,000; Full time

Benefits offered by this job

Medical, Dental, and Vision Insurance

401(k) with discretionary companymatch

Employer-paid Basic Life Insurance

Employer-paid Short-Term and Long-Term

Paid Time Off (Vacation and Sick Days)

Paid Time Off (Holidays)

Tuition Reimbursement Program

Employee discounts through BenefitHub

Advancement opportunities

Job summary

Vallen Distribution seeks a Customer Dedicated Business Analyst to perform analytics and modeling on data sets across products and processes. You’ll identify opportunities to improve efficiency and automate data analysis, working with Business and IT teams to explore data uses for regular and ad hoc projects.

You will develop Excel reports, automate processes with VBA, and design Power BI dashboards, supporting decisions with clear, data-driven insights while coordinating with stakeholders

Qualifications

• Analytical mindset with strong problem-solving for innovation-driven tasks.
• Clear communication of data insights to non-technical audiences.
• Attention to detail across multiple priorities.

Responsibilities

• Develop and maintain advanced Excel reports including pivot tables, Power Query scripts, dynamic arrays, and complex formulas.
• Create, maintain, and improve VBA/macros for process automation.
• Collaborate with stakeholders to design Power BI dashboards, interpret DAX measures, and apply data visualization best practices.
• Analyze data to identify trends, generate actionable insights, and support decision-making.
• Manage and organize data in OneDrive and SharePoint for seamless collaboration.
• Communicate complex data findings clearly to non-technical team members.
• Balance multiple tasks while maintaining exceptional attention to detail.

Skills

Analytical mindset

Effective communication

Attention to detail

Tools

Power BI

Excel

VBA/Macros

Power Automate

Power Apps

Job description

Vallen Distribution seeks a Customer Dedicated Business Analyst to perform analytics and modeling on data sets across products and processes. You’ll identify opportunities to improve efficiency and automate data analysis, working with Business and IT teams to explore data uses for regular and ad hoc projects.

You will develop Excel reports, automate processes with VBA, and design Power BI dashboards, supporting decisions with clear, data-driven insights while coordinating with stakeholders