Customer Analytics & Automation Specialist

Socket.dev; Jacksonville (FL); On-site; USD 70,000 - 100,000; Full time

Job summary

Vallen's Customer Dedicated Business Analyst role focuses on performing analytics and statistical modeling on existing data sets to find efficiency improvements and automation opportunities. The position collaborates with Business and IT teams to explore data uses for regular and ad hoc projects.

The role emphasizes designing dashboards, interpreting DAX, and presenting insights clearly to stakeholders while organizing data in cloud storage for collaboration.

Qualifications

• Power BI development knowledge: familiar with DAX and visualization best practices.
• Advanced Microsoft Excel skills: pivot tables, Power Query, dynamic arrays, complex formulas.
• VBA/macros development: proven expertise in process automation.
• Microsoft Power Platform: Power Automate and Power Apps.
• Analytical mindset with strong problem-solving skills for innovation-driven tasks.
• Effective communication: explain technical data insights to non-technical audiences.
• Attention to detail: manage multiple priorities effectively.

Responsibilities

• Develop and maintain advanced Excel reports (pivot tables, Power Query, dynamic arrays).
• Create, maintain, and improve VBA/macros for process automation.
• Collaborate with stakeholders to design Power BI dashboards 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

Multi-tasking

Tools

Power BI

Excel

VBA/Macro

Power Automate

Power Apps

Power Query

Smartsheet

Python

R

APIs

Job description

Vallen's Customer Dedicated Business Analyst role focuses on performing analytics and statistical modeling on existing data sets to find efficiency improvements and automation opportunities. The position collaborates with Business and IT teams to explore data uses for regular and ad hoc projects.

The role emphasizes designing dashboards, interpreting DAX, and presenting insights clearly to stakeholders while organizing data in cloud storage for collaboration.