Excel Systems & Data Analyst

BROWN & TOLAND PHYSICIAN SERVICES ORGANIZATION, LLC
Las Vegas, NV, United States
10 days ago
Apply on www.careerjet.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
8 years minimum
Working hours
Regular working hours

Tech stack

Microsoft Excel Big Data Spreadsheets Data Validation Data Cleansing Lookup Table Pivot Tables Powerpivot Power BI SQL Databases Macros Microsoft Power Automate
+5 more
Powerquery Vba Programming Language Build Tools Operational Systems Gsuite

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

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.

Benefits & conditions

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 fees 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. BruntWork never charges fees 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. Job Category Accounting and Finance Job Type Full Time (35 hours or more per week) Work Schedule and Timezone Las Vegas USA Published on Aug 19 2026 BruntWork will never ask you for money or any other form of payment. If someone claiming to represent BruntWork is requesting a payment from you, please let us know at “BruntWork made the entire recruitment process smooth, transparent, and stress-free. They matched me with a client that genuinely fits my skills and values - and the support didn’t stop at placement… A reliable, professional partner I’d recommend without hesitation.”

  • Zyrrah D, Bookkeeper 4.9/5 4.9/5 Excel Systems & Data Analyst Job Category Accounting and Finance Job Type Full Time (35 hours or more per week) Work Schedule and Timezone Las Vegas USA Published on Aug 19 2026 BruntWork will never ask you for money or any other form of payment. If someone claiming to represent BruntWork is requesting a payment from you, please let us know at “BruntWork made the entire recruitment process smooth, transparent, and stress-free. They matched me with a client that genuinely fits my skills and values - and the support didn’t stop at placement… A reliable, professional partner I’d recommend without hesitation.”

  • Zyrrah D, Bookkeeper 4.9/5 4.9/5 BruntWork provides opportunities that maximise your expertise so you can hit your financial goals faster with ambitious startups and well-known brands. Discover remote, work from home roles across every industry and job type.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerjet.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:03 min

Exploring declarative and procedural macro subtypes in Rust environments

Mykhailo Maidan · LIVE

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

1:59 min

Navigating the disadvantages and maintenance costs of procedural macros

Mykhailo Maidan · LIVE

2:24 min

Utilizing spreadsheet workflows to solve seller data onboarding challenges

John Bettiol · World Congress 2022

3:48 min

Standardizing data access schemas with OData

Florian Bader Florian Bader · World Congress 2026 Europe

Videos

See all

Related articles

See all