> Markdown version of [/jobs/ext/2148613-excel-systems-data-analyst](https://www.wearedevelopers.com/jobs/ext/2148613-excel-systems-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Excel Systems & Data Analyst

- **Company:** BROWN & TOLAND PHYSICIAN SERVICES ORGANIZATION, LLC
- **Location:** Las Vegas, NV, United States (Remote available)
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Microsoft Excel, Big Data, Spreadsheets, Data Validation, Data Cleansing, Lookup Table, Pivot Tables, Powerpivot, Power BI, SQL Databases, Macros, Microsoft Power Automate, Powerquery, Vba Programming Language, Build Tools, Operational Systems, Gsuite
- **Published:** August 20, 2026
- **Apply:** https://www.careerjet.com/job/us51cc8ec6ff4c7e525819c3d4289e96bc/eaa

## About the Role

* 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.

## Description

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.


## Related Videos

- [Crafting Custom Frameworks with Rust: A Deep Dive into Procedural Macros](https://www.wearedevelopers.com/videos/849-crafting-custom-frameworks-with-rust-a-deep-dive-into-procedural-macros)
- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [Replacing Excel with SAP APIs & Python validation](https://www.wearedevelopers.com/videos/1944-replacing-excel-with-sap-apis-python-validation)
- [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Modularity: Let's dig deeper](https://www.wearedevelopers.com/videos/1200-modularity-let-s-dig-deeper)

## Related Articles

- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria)
- [Best Companies to work for in London: Top 25 Companies in 2023](https://www.wearedevelopers.com/magazine/187-best-companies-to-work-for-in-london-top-25-companies-in-2023)