Excel/VBA/Power Query Consultant - Nebraska

Excel / VBA / Power Query Consultant (Contractor)

*Nebraska resident - if you reside elsewhere, please apply to the other job posting that does not specify location*

What You’ll Be Doing

The contracted Excel/VBA/Power Query Consultant position at ProsperSpark, LLC will be responsible for completing Excel/VBA/Power Query projects for ProsperSpark. You will be designing, building, fixing, and testing Excel spreadsheets, templates, and tools utilizing Excel, VBA code, Power Query, and/or Airtable. This position requires expert-level Excel and VBA skills. In most cases, you will work with a Senior Excel/VBA Consultant, who will manage the client relationship. On occasion, you will work directly with the client (usually on small projects). This position requires some availability during regular business hours throughout the workweek.

Who You Are

You are a data ninja that is an expert with Microsoft Excel, VBA (macros), and Power Query. The statements below describe you:

• You have been the “Excel person” at each place you’ve worked.
• You love designing forms, reports, dashboards, and templates in Excel.
• You’ve lost track of how many VBA macros you’ve written over the years.
• You find it fun to put dashboards together and analyze data.
• You find connecting an API to Excel exciting and challenging.
• You have completed more financial models in Excel than you can count.
• You take direction well and welcome feedback.
• You prioritize client relationships, and you know how to cultivate them.
• You are serious about being a professional consultant.

Bonus Points (any of the following):

• You have Power Query skills. (This one is most important)
• You have Airtable skills.
• You have Zapier skills.
• You have Google Data Studio skills.
• You have Power BI skills.

This is a contractor position, and we prefer somebody who can work during regular business hours. One or more of the statements below could describe your current situation:

• You want to work from home.
• You are ready to work for yourself.
• You work part-time.

What You Get

We are a small company, and this is a contractor position. Here’s what you can expect:

• Flexible scheduling.
• Choose what projects you work on.
• Work from home.
• No dress code (go head, work in your pajamas).
• Bonuses for excellent work.
• No selling. We do that for you. You just do the work!

Job Types: Full-time, Contract

Pay: $30.00 - $65.00 per hour

Benefits:

• Flexible schedule
• Referral program

Supplemental pay types:

• Bonus pay

COVID-19 considerations:
All work is performed remotely.

Application Question(s):

• How many years of Power Query experience do you have?
• On a scale of 1 to 10, how would you rate your data visualization skills?
• What would be your ideal work week? (An example is, I prefer to work from 10:30 - 12:30 every day and then from 3:30 - 5:30. Or I am available all-day Monday and Tuesday each week.)
• What hourly range are you looking for? (Please do not leave blank.)
• Are you able to utilize VBA for loops, userform interactions, passing of variables, UDF's, and global variables? Please explain your experience level as it relates to these specific functions.
• How many hours during the week are you interested in working?
• Do you reside in or around Omaha, NE?

Education:

• Bachelor's (Required)

Experience:

• Microsoft Excel (Expert Level): 5 years (Required)
• VBA (Expert Level): 5 years (Required)

Language:

• English (Required)

Work Location: Remote

Salary : $30 - $65