Remote Customer Analytics Specialist

Vallen Distribution; Belmont (NC); On-site; USD 65,000 - 95,000; Full time

Benefits offered by this job

Medical Insurance

401(k) match

Life Insurance

Disability Insurance

Paid Time Off

Holidays

Tuition Reimbursement

Employee Discounts

Advancement opportunities

Job summary

Vallen is seeking a Customer Dedicated Business Analyst to perform analytics and modeling on existing data sets, targeting opportunities to increase efficiency and automate data processes. You will collaborate with the Business and IT teams to study data uses for both regular and ad hoc projects.

The role emphasizes creating advanced Excel reports, VBA automation, and designing Power BI dashboards with DAX measures; you will help stakeholders interpret insights and manage data in

Qualifications

• Power BI development knowledge and visualization best practices.
• Advanced Excel skills: pivots, Power Query, dynamic arrays, complex formulas.
• VBA/macros development for process automation.
• Microsoft Power Platform skills: Power Automate and Power Apps.
• Analytical mindset with strong problem-solving abilities.
• Effective communication of data insights to non-technical audiences.
• Attention to detail with ability to manage multiple priorities.

Responsibilities

• Develop and maintain advanced Excel reports including pivot tables and Power Query scripts.
• Create, maintain, and improve VBA/macros for automation.
• Collaborate with stakeholders to design Power BI dashboards and interpret DAX measures.
• Analyze data to identify trends and generate actionable insights.
• Manage and organize data in OneDrive and SharePoint for collaboration.
• Communicate complex findings clearly to non-technical teammates.
• Balance multiple tasks with strong attention to detail.

Skills

Power BI Development

Excel Advanced

VBA/Macros

Power Platform

Data Visualization

Communication

Attention to Detail

Analytical Thinking

Tools

Power BI

Excel

VBA

Power Automate

Power Apps

Python

R

APIs

Job description

Vallen is seeking a Customer Dedicated Business Analyst to perform analytics and modeling on existing data sets, targeting opportunities to increase efficiency and automate data processes. You will collaborate with the Business and IT teams to study data uses for both regular and ad hoc projects.

The role emphasizes creating advanced Excel reports, VBA automation, and designing Power BI dashboards with DAX measures; you will help stakeholders interpret insights and manage data in