Note: The job is a remote job and is open to candidates in USA. Vallen is an industry leader in delivering flexible supply chain solutions while creating value for customers, supply partners, and associates. The Customer Dedicated Analyst performs analytics and statistical modeling to identify trends, improve processes, and support decision-making. The role develops Excel reports and automation, designs Power BI dashboards, manages data, and communicates insights to stakeholders.
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
- 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
- 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
Benefits
- 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
- Remote work
Company Overview