Location: Nebraska/Washington resident - priority given to residents of Nebraska and Washington
About the Company:
ProsperSpark, LLC is a small automation and process improvement consulting firm that helps businesses save time and money. At ProsperSpark, we believe that people should be able to focus on rewarding work that adds value to their business and automate the rest. We provide low-code solutions for office process improvement, automation, and analysis.
What You'll Be Doing:
As an Excel/VBA/Power Query Consultant at ProsperSpark, LLC, you will be crucial in managing and executing Excel/VBA/Power Query projects. In addition to your technical responsibilities, you will strongly emphasize project management and client interaction. Your tasks will include designing, building, fixing, and testing Excel spreadsheets, templates, and tools utilizing Excel, VBA code, Power Query, and Airtable. Collaborating with a Senior Excel/VBA Consultant, you will actively contribute to client relationships and occasionally lead small projects independently. This position requires flexible availability during regular business hours throughout the workweek.
Who You Are:
You are not just a data ninja but a seasoned professional with exceptional project management and client management skills. The following statements resonate with your experience and aspirations:
- You've been the go-to "Excel person" in every professional setting.
- Designing forms, reports, dashboards, and templates in Excel is not just a task; it's a passion.
- You've written many VBA macros, and you enjoy the challenge.
- Constructing dashboards and analyzing data brings you joy.
- Connecting APIs to Excel is exciting and something you find challenging.
- You've completed numerous financial models in Excel.
- You excel at taking direction and welcome feedback.
- Prioritizing client relationships is second nature; you know how to nurture them.
- You are committed to being a professional consultant.
Bonus Points (any of the following):
- Power Query skills (highly preferred).
- Airtable skills.
- Low-code automation skills.
- Power BI skills.
Preferred Qualifications:
We prefer candidates who can work during regular business hours. Your current situation may align with one or more of the following:
- You seek the flexibility to work from home.
- You are ready to embark on a self-employed journey.
- You are interested in part-time work.
- Display a familiarity with Excel's newer functions and features, including but not limited to dynamic array formulas, modern lookup functions, office scripts, and lambda functions.
- Demonstrate expertise in Power Query's advanced editor and features, including but not limited to API connections, custom functions, M formula, and DAX code. This skill set can be acquired either from Excel or Power BI.
- Exhibit an organized and thorough understanding of VBA code with proper error handling, modularity, and notations.
What You Get:
As a valued contractor in our small company, you can expect the following benefits:
- Flexible scheduling tailored to your needs.
- Autonomy to choose projects aligned with your expertise.
- Work-from-home flexibility.
- No dress code – feel free to work in your pajamas.
- Bonuses for outstanding work.
- No selling required – we handle that for you, allowing you to focus on your expertise and deliver exceptional results.
Job Type: Full-time
Pay: $30.00 - $65.00 per hour
Benefits:
- Flexible schedule
- Referral program
Supplemental pay types:
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:
Experience:
- Microsoft Excel (Expert Level): 5 years (Required)
- VBA (Expert Level): 5 years (Required)
Language:
Location:
Work Location: Remote