Excel VBA Consultant at Enodo

| Remote
Sorry, this job was removed at 11:59 a.m. (CST) on Monday, September 28, 2020
Find out who's hiring in Chicago.
See all Developer + Engineer jobs in Chicago
Send Resume to [email protected]
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Enodo – Excel VBA Development Consultant

Job Description

As an Excel VBA Development Consultant, you’ll be responsible for being technically strong and disciplined in Excel Macros/Visual Basic Applications with a proven ability to deliver quality solutions. You’ll be developing robust and maintainable applications to automate API data pulls, real estate underwriting tasks, and report generation across multiple Excel models.

Your role will have a 6-month duration, with the possibility of full-time employment after the engagement ends. Your work will be entirely remote, so strong organization and communication skills are essential. To coordinate with our development team, it is important that you’re available from 9am-5pm U.S. Central Time. This availability will be required upon your start. We anticipate 20 – 30 hours per week will be required for this role.

Responsibilities
 
* Develop and maintain Excel Macros/VBA Code to efficiently automate real estate financial analysis tasks and generate reports
* Optimize scripts to pull data from the Enodo automated underwriting platform using VBA
* Refine and maintain an Excel add-in to pull data into Excel from the Enodo platform
* Ensure smooth delivery and support of new tools delivered
* Keep up to date documentation for all new and updated features
* Maintain technical documentation and ensure that knowledge is shared with other members of the team

Requirements

* 5+ years of VBA Development experience (report automation, custom application development, bug/error fixing, migration)
* 5+ years of experience in MS Excel (formulas, charts, pivot tables, macros)
* Experience and work samples from engagements with real estate or finance companies
* Ability to communicate effectively verbally and in writing
* Strong analytical and problem-solving skills
* Driven self-starter able to work on a small team and take initiative on new tasks with minimal supervision
* Familiarity with JIRA or equivalent product management software and agile development best practices

About Us

Enodo is an automated underwriting platform for real estate professionals that was built to disrupt the commercial real estate industry. The software allows investors, brokers, and lenders to analyze rent, operating expenses and returns for multifamily properties by applying machine learning to a database of live multifamily transaction data from every U.S. market.

We have a creative and entrepreneurial culture – everyone on the team interacts directly with customers each day, and we all contribute to the product and planning. If you have an idea to improve something, there is no red tape… just build what needs to be built! Innovation and passion for disrupting the old-fashioned real estate industry are our highest priorities.

Learn more about Enodo at https://enodoinc.com/

We’re located at 130 S. Jefferson St. in Chicago, Illinois.

Read Full Job Description
Send Resume to [email protected]
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavascriptLanguages
    • PythonLanguages
    • RLanguages
    • ScalaLanguages
    • SqlLanguages
    • D3JSLibraries
    • VueLibraries
    • FlaskFrameworks
    • HadoopFrameworks
    • Node.jsFrameworks
    • TensorFlowFrameworks
    • TheanoFrameworks
    • PostgreSQLDatabases
    • RedisDatabases
    • SQLiteDatabases
    • Google AnalyticsAnalytics
    • MixpanelAnalytics
    • InVisionDesign
    • SketchDesign
    • HubSpotCRM
    • IntercomCRM
    • IntercomEmail
    • MandrillEmail

Location

We're in a lively neighborhood with great access to transit and many dining options. Enodo is literally 2 blocks from Union Station.

An Insider's view of Enodo

What are some social events your company does?

Every few months we have a company outing where we rent out a space for the team. In the past we've done bowling, VR, and pool outings. Food and drinks are provided and everyone has a great time.

Marc

CEO

What's the biggest problem your team is solving?

Predicting the market value of multifamily properties is the biggest issue we're working on. We've built one of the first true automated valuation models for the multifamily real estate industry, and we're continuing to refine and improve on it with new techniques and data sources.

Greg

Data Engineer

How has your career grown since starting at the company?

I've learned so much working with Enodo. There is a lot of flexibility to experiment with new analytical techniques, and it's been great for learning and adopting new innovative data science approaches.

Nicolas

Lead Data Scientist

What is your vision for the company?

We will objectively quantify every factor that drives real estate value, in every market, and put the power of big data and predictive analytics in the hands of anyone who wants to own a piece of the world.

Thomas Delaney

COO

What are some things you learned at the company?

I have learned proper big data warehousing and how to design efficient, distributed ETL pipelines for interpreting datasets exceeding a billion records. I have also learned front-end and back-end application development to serve the insight gained from these pipelines.

Tim

Lead Data Engineer

What are Enodo Perks + Benefits

Culture
Eat lunch together
Daily stand up
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Diversity
Mean gender pay gap below 10%
Health Insurance & Wellness Benefits
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Company Equity
Performance Bonus
Match charitable contributions
Child Care & Parental Leave Benefits
Generous Parental Leave
We provide up to 11 weeks of parental leave for the primary and secondary caretaker.
Flexible Work Schedule
We provide employees with a flexible work schedule that includes flexible start and end times.
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Enodo hosts company outings Quarterly.
Game Room
Stocked Kitchen
Some Meals Provided
Happy Hours
Happy hours are hosted once per month.
Pet Friendly
Relocation Assistance
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Promote from within
Time allotted for learning
We set aside 10% of working hours for learning.
Online course subscriptions available
More Jobs at Enodo2 open jobs
All Jobs
Dev + Engineer
Developer
new
Chicago
Developer
new
Chicago
Send Resume to [email protected]
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Enodo's full profileSee more Enodo jobs