Excel professional Position Available In Mecklenburg, North Carolina

Excel professional

Role:

Excel professional

Location :

Charlotte, NC / Irving, TX-Onsite
Type of hire: Contract Role

JD:

Role Overview:

We re seeking a highly skilled Excel professional to design, develop, and optimize complex spreadsheet tools and dashboards. You ll automate data processes, perform in-depth analysis, and collaborate with teams to drive data-driven decisions.

Key Responsibilities:

Design, build, and maintain advanced Excel models
, including complex formulas (e.g., XLOOKUP, INDEX/MATCH, array formulas), pivot tables, and dynamic dashboards
Automate repetitive tasks via macros/VBA scripts
, including custom functions (UDFs) and Lambda usage Leverage Power Query / Power Pivot to extract, transform, and model external data Utilize tools like Solver, Goal Seek
, and scenario tables for advanced what-if and optimization analysis Implement data cleaning & validation
: using text-to-columns, filters, conditional formatting, data validation rules Develop and maintain interactive dashboards with charts, sparklines, slicers, and visual cues for executive reporting
Ensure model integrity
, performance optimization, documentation, version control, and sharing across teams
Troubleshoot and resolve formula errors, file corruption, and integration issues across Office apps
Provide training and support to business users; promote Excel best practices and empower teams

Required Qualifications:

Bachelor s degree in Business, Finance, IT, Engineering or related field
3+ years of hands-on experience building advanced Excel solutions
Expert proficiency in formulas (XLOOKUP, INDEX/MATCH, array functions), pivot tables, charts, conditional formatting VBA & macros development experience, including debugging and custom functions Practical experience with Power Query / Power Pivot / Data Model Knowledge of Solver, Goal Seek, Whatif analysis tools Exceptional attention to detail and analytical thinking
Strong communication skills to explain complex data insights clearly Ability to manage multiple projects, meet deadlines, and work independently or in teams
Preferred (Nice-to-Have):
Experience with Power BI
, SQL, Python or integrating Excel with databases
Knowledge of spreadsheet architecture principles
, named ranges, modular design, workbook best practices Familiarity with version control
, documentation of assumptions, and model traceability
Financial or engineering modeling experience in Excel

Qualities & Mindset:

A systematic, user-oriented Excel engineer who builds robust, maintainable tools
Proven ability to automate end-to-end processes
, saving significant time and errors
Strong documentation discipline and a commitment to version control and traceability
Ability to drive business impact through automation and insightful reporting
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job

Dice Id:

10114281

Position Id:

8682295