Data Analyst (Excel, VBA & Automation Focus)

Location: Fully Remote
Time Zone Requirement: Must have overlap with U.S. business hours (MST preferred)
Department: Data / Analytics
Reports To: Head of Data / Operations

About the Company

We are a data-driven company focused on helping businesses maximize profitability through advanced reporting, data visualization, and process automation.

Our work centers on transforming raw data into actionable insights, building efficient reporting systems, and automating manual processes to improve operational performance. We partner with clients across industries to streamline workflows, reduce inefficiencies, and enable smarter, faster decision-making.

We operate in a highly analytical, fast-paced environment where accuracy, efficiency, and innovation are critical.

We pride ourselves on:

Delivering measurable, profit-driven outcomes
Building scalable data and automation solutions
Turning complex data into clear, actionable insights
Maintaining high standards of accuracy and reliability

About the Role

We are seeking a highly skilled and detail-oriented Data Analyst with strong expertise in Excel, VBA, and Office Scripts to support data analysis, reporting, and automation initiatives.

This role is heavily focused on building and optimizing data workflows within Excel, creating automated reporting solutions, and improving operational efficiency through scripting and process automation.

This position is ideal for someone who enjoys working deeply with data, building systems, and finding ways to eliminate manual work through smart automation.

What You’ll Do

Data Analysis & Reporting

Analyze large datasets to identify trends, insights, and opportunities
Build and maintain detailed reports and dashboards in Excel
Translate complex data into clear, actionable insights for stakeholders
Ensure data accuracy and consistency across all reporting outputs

Excel & Automation Development

Develop advanced Excel models using formulas, pivot tables, and structured data
Write and maintain VBA scripts to automate repetitive tasks and workflows
Build Office Scripts to streamline processes within Excel Online
Continuously improve existing tools for performance, scalability, and usability

Process Optimization

Identify inefficiencies in current workflows and propose automation solutions
Design and implement systems to reduce manual data handling
Improve reporting speed, accuracy, and accessibility
Collaborate with stakeholders to align automation with business needs

Data Management

Clean, organize, and structure data from multiple sources
Ensure proper documentation and version control of data processes
Maintain data integrity and troubleshoot inconsistencies

Cross-Functional Collaboration

Work closely with operations and leadership teams to understand data needs
Communicate findings and recommendations clearly and effectively
Support ad hoc data requests and business analysis needs

What You Bring

Required Experience

2–8 years of experience in data analysis, business analysis, or similar roles
Advanced proficiency in Microsoft Excel (required)
Strong experience with VBA (Visual Basic for Applications)
Experience building and maintaining Office Scripts
Proven ability to automate workflows and improve operational efficiency
Strong analytical and problem-solving skills
High attention to detail and data accuracy
Excellent written and verbal English communication skills

Technical Skills

Microsoft Excel (advanced level – formulas, pivot tables, data modeling)
VBA (required)
Office Scripts (required)
Data cleaning and transformation techniques
Familiarity with data visualization best practices
Comfortable working with large datasets

Nice to Have

Experience with Power BI, Tableau, or other visualization tools
Familiarity with SQL or databases
Experience in process automation or operations optimization
Background working with U.S.-based companies
Experience integrating data from multiple systems

Technical Requirements

Reliable high-speed internet connection
Modern computer capable of handling large datasets and multiple applications
Ability to run Excel efficiently with advanced models and scripts

Work Environment

Fully remote role
Fast-paced, analytical, and results-driven environment
High focus on accuracy, efficiency, and problem-solving
Collaborative and team-oriented culture

Schedule

Monday – Friday
U.S. business hours (EST preferred overlap)
(Exact schedule to be confirmed based on business needs)

Who This Role is Ideal For

Detail-oriented and analytical professionals
Excel power users who enjoy building systems and automations
Problem-solvers who look for efficiency improvements
Individuals who enjoy working with data to drive business outcomes
Self-starters who can manage projects independently

What This Role Is Not

Not a purely reporting role — automation and system-building are core
Not an entry-level position — strong technical experience is required
Not limited to basic Excel — advanced expertise is essential

Why Join

Work on high-impact projects that directly improve business performance
Build automation systems that create real operational efficiency
Be part of a data-focused, results-driven team
Opportunity to deepen expertise in advanced Excel and automation
Exposure to a variety of industries and data challenges

Equal Opportunity

We are committed to building a diverse and inclusive workplace and welcome candidates from all backgrounds to apply.

Data Analyst - 18993