Cust Dedicated Analyst
About The Position
Vallen's Customer Dedicated Business Analyst is an individual contributor role responsible for general analytics and statistical modeling using existing data sets across products and processes. The position identifies opportunities for process improvement, efficiency, and automation in data analysis. It examines data patterns and trends to answer business questions and improve decision-making, collaborating with Business and Information Technology teams to propose data uses for regular and ad hoc projects. The role develops and maintains advanced Excel reports and automation, supports Power BI dashboard design and interpretation, analyzes data for actionable insights, manages shared data in OneDrive and SharePoint, and communicates findings to non-technical colleagues. It requires balancing multiple tasks with close attention to detail.
Requirements
- Familiarity with Power BI development, DAX, and data visualization best practices.
- Advanced Microsoft Excel skills, including pivot tables, Power Query, dynamic arrays, and complex formulas.
- Proven expertise in VBA and macro development for process automation.
- Skills in Microsoft Power Platform, including Power Automate and Power Apps.
- Strong problem-solving and analytical skills.
- Ability to explain technical data insights to non-technical audiences.
- Ability to manage multiple priorities with attention to detail.
Nice To Haves
- Prior experience in customer operations or related roles.
- Two to three years of experience in a similar role.
- Experience creating Smartsheet sheets, workflows, and dashboards.
- General knowledge of Python, R, or APIs for advanced analysis and automation.
- Microsoft Office Specialist: Excel Expert, Power BI, or Power Platform certifications.
- Familiarity with project management tools such as Microsoft Teams.
Responsibilities
- Develop and maintain advanced Excel reports using pivot tables, Power Query scripts, dynamic arrays, and complex formulas.
- Create, maintain, and improve VBA and macros to automate processes.
- 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 to support collaboration.
- Communicate complex data findings clearly to non-technical team members.
- Balance multiple tasks while maintaining exceptional attention to detail.
- Collaborate with Business and Information Technology teams on data uses for regular and ad hoc projects.
Benefits
- Medical, dental, and vision insurance.
- 401(k) with discretionary company match for U.S. positions.
- Employer-paid basic life insurance.
- Employer-paid short-term and long-term disability benefits and parental leave.
- Health care and dependent care flexible spending accounts.
- Paid vacation and sick time.
- Eight scheduled holidays and two 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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
