Excel professional

Overview

On Site
BASED ON EXPERIENCE
Contract - Independent
Contract - W2

Skills

Collaboration
Scripting
Optimization
Data Cleansing
Data Validation
Dashboard
Performance Tuning
Training
Pivot Table
VBA
Macros
Debugging
Data Modeling
Attention To Detail
Analytical Skill
Communication
Management
Microsoft Power BI
SQL
Python
Database
Finance
Modeling
Microsoft Excel
Documentation
Version Control
Reporting
Application Development
Software Modernization
Process Outsourcing
IT Service Management

Job Details

Job description:-

Title:

Excel professional
Location: Charlotte, NC // Irving, TX
Duration: 12 + months

Additional Job Details:

Role: Excel professional
Type of hire: W2 or *.
Charlotte, NC // Irving, TX

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, What if 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

About Tanisha Systems, Inc.

Tanisha Systems, founded in 2002 in Massachusetts-*, is a leading provider of Custom Application Development and end-to-end IT Services to clients globally. We use a client-centric engagement model that combines local on-site and off-site resources with the cost, global expertise and quality advantages of off-shore operations. We deliver Custom Application Development, Application Modernization, Business Process Outsourcing and Professional IT Services from office locations in * and *.
Tanisha Systems services clients in Government, Banking & Financial Markets, Insurance, Healthcare, Retail & Consumer Goods, Energy & Utilities, Life Sciences, Telecom, Manufacturing and Transportation Industries around the globe. Our engagement model provides a flexible operational environment that empowers our clients with the right levels of control.

Want to read more about Tanisha Systems? Visit us at

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.