Business Intelligence Analyst

Amherst Residential, is a vertically integrated residential real estate platform making ownership of single family homes seamless for investors and home owners. The platform has raised over $6 billion of capital since inception, manages ~20,000 homes, and is growing its team as it rolls out new investments and business lines. 

Amherst Residential is hiring a Jr. Business Intelligence Analyst whose primary responsibility will be to work on the Corporate Growth and Executive Management team to provide data analytics and reporting to the various functions within Amherst Residential. This includes implementing solutions for optimizing and automating existing reporting as well as leveraging tools such as SQL and Tableau to create and monitor new key performance indicators and operational metrics. This is a great opportunity for someone who is interested in working alongside a fast-paced, data-driven team to help the organization achieve its strategic objectives.

Duties and Responsibilities:

  • Tackle complex business problems by converting raw data into meaningful and actionable business insights. Collaborate directly with peers and business leaders to transform ideas into actions.
  • Utilize Microsoft SQL Server for extraction and analysis of data from multiple sources with demonstrated ability to effectively decipher, analyze and report data
  • Develop reports and dashboards using Tableau and/or Excel for internal and external customers
  • Leverage analytic problem solving skills in working with large disparate, datasets to report portfolio operational metrics and performance
  • Assist with preparation and automation of recurring / ad hoc reporting assignments

Required Experience:  

  • Bachelor’s degree in Management Information Systems, Finance, Mathematics, Economics, Computer Science, Engineering or related quantitative discipline
  • 1-2 years’ experience analyzing data, drawing conclusions and making recommendations; consulting or financial services industry experience is a plus
  • Strong SQL query writing skills required. Experience working in a Microsoft SQL Server environment is preferred.
  • Experience with creating and presenting management dashboards and reports
  • Experience with data visualization/business intelligence tools. Experience with Tableau is a huge plus.
  • Strong Microsoft Excel skills
  • Ability to be flexible and work in a fast paced environment
  • Excellent written and verbal communication
  • Ability to meet established timelines
  • Analytical mindset and passion for gleaning actionable insights from raw data

Bonus Skills:

  • Knowledge of at least one other programming language such as Python is a plus
  • Knowledge of data warehousing and ETL concepts is a plus

What we offer:

Amherst is a privately held corporation located in West Austin with beautiful views of Lake Austin and the loop 360 bridge in a modern workspace with open floor plans.

  • A competitive compensation package, annual bonus, 401k match
  • Flexible PTO, 11 paid holidays, accrued sick/personal time
  • Employer paid benefits (medical, dental, vision, health savings account)
  • Professional career development and reimbursement
  • On-premise fitness center, locker rooms
  • Daily catered lunches, fully stocked kitchen with snacks/drinks
  • Relaxed casual environment and weekly/quarterly office events!
Read Full Job Description
Apply now
loading ...
Emailed

Technology we use

  • Engineering
  • Product
    • .NETLanguages
    • C#Languages
    • JavascriptLanguages
    • RLanguages
    • SqlLanguages
    • D3JSLibraries
    • jQueryLibraries
    • ReactLibraries
    • ReduxLibraries
    • AngularJSFrameworks
    • ASP.NETFrameworks
    • HadoopFrameworks
    • Node.jsFrameworks
    • HBaseDatabases
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • HadoopDatabases
    • AsanaManagement
    • ConfluenceManagement
    • JIRAManagement

Location

Two offices around Austin at our HQ with beautiful views of Lake Austin in a modern office and our tech co-working space near Lady Bird Lake

An Insider's view of Amherst

What are some social events your company does?

Amherst is always participating in exciting events. From Dell Match Play to SXSW, Amherst engages in a variety of local events. We also host smaller events for employees such as summer BBQ's and happy hours. Nothing tops our holiday party, a true family celebration!

Austen

Director of Talent Programs

What projects are you most excited about?

I'm most excited about our Budget Revision Project! We were tasked with the challenge of moving a tedious process into a more user and mobile friendly system. This will allow the field teams to submit budget revisions from MSR Properties and have one system to manage the majority of their work. This excitement is why I love being a part of the team

Gage

Business Analyst

How has your career grown since starting at the company?

“At Amherst, I am able to work collaboratively with peers who have had years of experience similar to mine. The technology is current and evolving as the company grows. Therefore, my skills stay current and always improve.”

Stan

Senior Systems Engineer

How do your team's ideas influence the company's direction?

My team is expected to create new IP (Intellectual Property) through innovation in software, hardware, workflow process and data. Our goal is to build franchise value/shareholder value, solve difficult problems through creative solutions, and improve over-all efficiency that in turn makes life easier for all of Amherst

Todd

Chief Technology Innovation Officer

What are some things you learned at the company?

Within my first year, I have acquired solid enterprise-level knowledge in developing .NET applications by using Angular 4+, ASP.NET MVC, WPF, Entity Framework, and advanced SQL. We’re transitioning into ‘React’ apps that I'm excited about as it will add to my tech skills. I like that we have autonomy regarding the tech decisions in development

Ruchi

Software Engineer

What are Amherst Perks + Benefits

Amherst Benefits Overview

Competitive salaries
Choice of Mac or Windows hardware
Flexible vacation days, paid holidays, and work from home options
Medical, Dental, Vision, LTD, Life, EAP, and 401K with matching benefits
Stellar colleagues with proven track records
Free sodas, kombucha, cold brew, beer and healthy and unhealthy snacks at our Barton Springs WeWork location
Free lunch every day and breakfast tacos on Thursdays!

Culture
Friends outside of work
Eat lunch together
Daily stand up
Open door policy
Group brainstorming sessions
Open office floor plan
Diversity
Highly diverse management team
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Amherst provides employees with a flexible work schedule that includes Flexible start and end times.
Remote Work Program
Family Medical Leave
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Casual Dress
Company Outings
Free Daily Meals
Stocked Kitchen
Happy Hours
Parking
Pet Friendly
Our coworking space near Ladybird Lake is pet-friendly!
Relocation Assistance
We offer relocation assistance depending on location and position.
Professional Development Benefits
Job Training & Conferences
Acme Co. offers employees professional development opportunities like Annual individual budget for training, Onsite training courses, The ability to attend job related conferences and seminars.
Lunch and learns
Acme Co. hosts lunch and learn meetings weekly.
Promote from within
Time allotted for learning
Amherst. allows employes to set aside 50% of working hours for learning.
Online course subscriptions available
Customized development tracks

Additional Perks + Benefits

Competitive compensation and bonus program. Flexible PTO. Health, vision, dental and long term disability coverage. Paid maternity/paternity leave. Attractive office space. Training certifications assistance. Daily catered lunch and stocked kitchens. Monthly birthday celebrations. Casual work environment with regular team-building outings. Breakfast Taco Thursday.

More Jobs at Amherst33 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Marketing
Operations
Product
Project Mgmt
Sales
Finance
new
Austin
Sales
new
Austin
Finance
new
Austin
Operations
new
Austin
Finance
new
Austin
Marketing
new
Austin
Data + Analytics
new
Austin
Data + Analytics
new
Austin
Operations
new
Austin
Developer
new
Austin
Data + Analytics
new
Austin
Developer
new
Austin
Finance
new
Austin
Finance
new
Austin
Operations
new
Austin
Product
new
Austin
Project Mgmt
new
Austin
Design + UX
new
Austin
Operations
new
Austin
Design + UX
new
Austin
Developer
new
Austin
Project Mgmt
new
Austin
Project Mgmt
new
Austin
Data + Analytics
new
Austin