WFH Excel Systems & Data Analyst

Job Overview

Our client, an electronics distribution company, is seeking a highly skilled Excel Systems & Data Analyst to work with their team on an ongoing basis. This is not a basic Excel, data-entry, or virtual assistant position. Our client needs someone who can understand business operations, identify inefficient or manual processes, and independently design better Excel-based systems, reports, and workflows.

Schedule

Monday - Friday, 8:00 AM - 5:00 PM US Pacific Time, with 1 hour unpaid break (40 work hours per week)

Responsibilities

• Build and improve Excel-based operational systems.
• Analyze and reorganize existing spreadsheets and workflows.
• Create automated reporting and dashboards.
• Combine and reconcile information from multiple spreadsheets.
• Build systems for inventory, purchasing, sales, pricing, profitability, and vendor data.
• Create tools for analyzing product models, SKUs, quantities, costs, selling prices, and margins.
• Automate repetitive manual Excel work.
• Create clean and easy-to-use templates for the team.
• Identify errors, inconsistencies, and inefficiencies in existing data.
• Recommend improvements instead of simply following instructions.
• Document systems so they can be easily maintained and used by the team.

Requirements

• Highly proficient with advanced Excel formulas (XLOOKUP / VLOOKUP, INDEX / MATCH, SUMIFS / COUNTIFS, conditional formulas, dynamic arrays).
• Strong experience with Pivot Tables, Data Validation, data cleaning, reconciliation, Power Query, and Excel dashboards handling large datasets.
• Strong analytical problem-solving mindset with the ability to take a broad business objective, design a complete solution, and build it independently.
• Excellent organizational skills, high attention to detail, and proactive working style.
• Strong written and verbal communication skills to articulate system improvements clearly to management.

Nice To Have

• Knowledge of VBA / Macros, Power Pivot, Power BI, SQL, Power Automate, Google Sheets / Apps Script, or workflow automation tools.
• Background in inventory management, purchasing/procurement, sales reporting, pricing analysis, profitability/margin analysis, or operational reporting.

Independent Contractor Perks

• Permanent work from home
• Immediate hiring
• Health Insurance Coverage for eligible locations

Note

Please click the "Apply" button to complete your application, including the assessment questions, technical check, and voice recording. Your hourly pay rate will be established based on your performance in the application process; submissions with all requirements fulfilled will receive priority review.

Important Disclaimer

BruntWork never charges payment for applying or any part of the hiring process—it is 100% free. If you are ever asked for payment, please stop and report it immediately to our official email us through the ‘Contact Us’ form on our official BruntWork website.