Excel Specialist / Data Analyst (Advanced Excel)

Compunnel Inc.
Holmesville, OH, United States
about 2 months ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Compensation
$58,635.0 - $73,923.0
Working hours
Regular working hours
Job source

Tech stack

Microsoft Excel Data Analysis Big Data Spreadsheets Data Validation Data Cleansing Excel Formulas Lookup Table Pivot Charts Pivot Tables Powerpivot Macros
+2 more
Powerquery Vba Programming Language

Job description

  • Create, modify, and troubleshoot advanced Excel formulas and functions.
  • Develop spreadsheets, dashboards, and reports to support business operations.
  • Analyze large volumes of data and provide actionable insights.
  • Utilize functions such as VLOOKUP, HLOOKUP, XLOOKUP, INDEX/MATCH, IF, SUMIF, COUNTIF, TEXT, DATE, and nested formulas.
  • Create and maintain Pivot Tables, Pivot Charts, and data validation tools.
  • Perform data cleansing, reconciliation, and accuracy checks.
  • Work with internal teams to understand reporting requirements and build customized Excel solutions.
  • Improve efficiency by automating repetitive tasks using formulas and Excel features.

Requirements

Do you have experience in Data analysis software?, We are seeking a detail-oriented professional with strong Microsoft Excel skills to support data analysis, reporting, and process improvement initiatives. The ideal candidate will have hands-on experience creating and developing complex Excel formulas from scratch, analyzing large datasets, and automating reporting processes., * Advanced proficiency in Microsoft Excel.

  • Demonstrated ability to create new formulas independently rather than relying solely on existing templates.
  • Experience working with large datasets and complex spreadsheets.
  • Strong analytical and problem-solving skills.
  • Excellent attention to detail and data accuracy.
  • Ability to explain formula logic and troubleshooting steps clearly., * Experience with Power Query, Power Pivot, or VBA/Macros.

Benefits & conditions

3.63.6 out of 5 stars Holmesville, OH 44633 $28.19 - $35.54 an hour - Contract

Apply for this position

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

Apply on indeed.com

Good distractions

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

3:28 min

Defining big data and machine learning fundamentals

Ayon Roy · LIVE

3:03 min

Exploring declarative and procedural macro subtypes in Rust environments

Mykhailo Maidan · LIVE

1:42 min

Combining technical skills with strong business communication

Lukas Kölbl · LIVE

2:10 min

Why organizations combine big data and machine learning

Ayon Roy · LIVE

1:59 min

Navigating the disadvantages and maintenance costs of procedural macros

Mykhailo Maidan · LIVE

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

Videos

See all

Related articles

See all