Cust Dedicated Analyst

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

Why Join Our Team?

At Vallen, we embrace what makes us unique. We thrive on the diversity of our associates and the different ways each of us contributes to Vallen's success. We pride ourselves on being an inclusive company that values the growth of our associates. When you join Vallen, you become part of our winning team. Our vast network of connections is here to help you transform your job into a career. Vallen is an industry leader in delivering flexible supply chain solutions while creating value for our customers, our supply partners, and our associates.

Benefits at Vallen

• Medical, Dental, and Vision Insurance
• Medical, Dental, and Vision Insurance for Single, Employee + Spouse or Children, and Family Coverage
• 401(k) with discretionary company match of $0.50 on the $1.00 up to 6% of pay (U.S. positions only)
• Employer-paid Basic Life Insurance for Employee, Spouse, and Dependents
• Employer-paid Short-Term and Long-Term Disability Benefits and Parental Leave (and any leave required under federal, state, and local laws)
• Health Care and Dependent Care Flexible Spending Accounts
• Paid Time Off (Vacation and Sick Days): 80-160 hours of vacation time based on seniority, accrued monthly and prorated from date of hire. 40-56 hours of sick time per year based on seniority and advanced upon hire.
• Paid Time Off (Holidays): 8 scheduled holidays plus 2 floating holidays
• Employee Assistance Program
• Employee Resource Groups for networking and team building
• Tuition Reimbursement Program
• Employee Referral Program
• Safety shoe and safety glasses reimbursement (based on position)
• Employee discounts through BenefitHub
• Advancement opportunities
• Vallen complies with all minimum wage laws
• We accept applications on an ongoing basis

Position Summary:

Vallen's Customer Dedicated Business Analyst is an individual contributor position responsible for performing general analytics and statistical modeling on existing data sets for various products and processes. This position targets specific areas of opportunity and process improvement by identifying areas for increasing efficiency and automation of the data analysis processes. The Customer Dedicated Analyst examines and identifies data patterns and trends to help answer business questions and improve decision making. They collaborate with the Business and Information Technology teams to study and propose data uses for both regular and ad hoc projects.

Essential Job Duties and 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.

Required Qualifications:

• Power BI Development Knowledge: Familiarity with DAX and visualization best practices.
• Advanced Microsoft Excel Skills: Pivot tables, Power Query, dynamic arrays, complex formulas.
• VBA/Macro Development: Proven expertise in process automation.
• Microsoft Power Platform Skills: Power Automate and Power Apps.
• Analytical Mindset: Strong problem-solving skills are essential for innovation-driven tasks.
• Effective Communication: Ability to explain technical data insights to non-technical audiences.
• Attention to Detail: Capable of managing multiple priorities effectively.

Preferred Qualifications:

• Industry Insight: Prior experience in customer operations or related roles.
• Experience: Minimum of 2-3 years in a similar role.
• Smartsheet Expertise: Experience creating sheets, workflows, and dashboards.
• Technical Proficiency: General knowledge of Python, R, or APIs for advanced analysis and automation.
• Certifications: Microsoft Office Specialist: Excel Expert or Power BI/Power Platform certifications.
• Project Management Understanding: Familiarity with tools like Microsoft Teams.
• Industry Insight: Prior experience in customer operations or related roles.

Work Environment & Physical Demands:

Reasonable accommodations will be evaluated and may be implemented to enable individuals with disabilities to perform essential functions of this position.

• This job operates in a professional office environment and routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets, etc.
• Long periods of time working on a computer and performing repetitive key-boarding activities.
• Evening and weekend work may be required as job duties demand and may include little to no advanced notice.
• While performing the duties of this job, associates are regularly required to sit and stand.
• May be required to lift up to 25 pounds.
• Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus

#LI-Remote

Stay up to date with Vallen, and follow us on LinkedIn, Facebook and Twitter.
Equal Opportunity Employer - Ethnically and Culturally Diverse/Females/Veterans/Disabled/Sexual Orientation/Gender Identity