Analyst, Business Intelligence

Analyst, Business Intelligence

The Amherst Group of companies comprise of leading real estate investment and advisory firms with a mission to transform the way real estate is owned, financed and managed.  Amherst leverages its proprietary data, analytics, technology, and decades of experience to seek solutions for a fragmented, slow-to-evolve real estate ecosystem and to materially improve the experience for residents, buyers, sellers, communities, and investors.  Today Amherst has over 1000 employees and $14.1 billion in assets under management.

Over the past decade, Amherst has scaled its platform to become one of the largest operators of single-family assets and has acquired, renovated, and leased more than 46,000 homes across 32 markets in the U.S.  The firm delivers customized, stabilized cash-flowing portfolios of assets to its investors, wrapped in all the ongoing services required to manage, own, and finance the asset including property management, portfolio management, and a full capital markets team.  In addition to its single-family rental platform, Amherst’s debt business pursues two distinct credit strategies in mortgage-backed securities and commercial real estate lending.  Over its 25-year history, Amherst has developed a deep bench of research and technology talent, and leverages data and analytics at every stage in the asset lifecycle to improve operations and preserve long-term value for our investors and the more than 188,000 residents the firm has served.

Duties and Responsibilities:

  • Collaborate directly with peers and business leaders in developing descriptive, diagnostic, predictive and prescriptive analytics solutions

  • Tackle complex business problems by converting raw data into meaningful and actionable business insights.

  • 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 or other tools for internal and external customers

  • Leverage analytic problem-solving skills in working with large disparate, datasets to report portfolio operational metrics and performance

  • Present findings and recommendations to business leadership

  • 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

  • 2-4 years’ experience analyzing data, drawing conclusions and making recommendations; consulting or financial services industry experience is a plus

  • Strong SQL query writing and optimization 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 and business intelligence tools such as Tableau, WebFOCUS, TIBCO Spotfire, Qlikview, Microstrategy. Experience with Tableau is preferred.

  • Strong Microsoft Excel skills

  • Knowledge of at least one other data analytics programming language such as Python or R. Experience with Python and analytics libraries such as Pandas, NumPy, Matplotlib etc. is preferred. 

  • Ability to be flexible and work in a fast-paced environment while meeting established timelines

  • Knowledge of advanced data science concepts such as machine learning and AI

  • Excellent written and verbal communication

  • Analytical mindset and passion for gleaning actionable insights from raw data

  • Familiarity with SCRUM or similar agile discipline is preferred

  • Strong team player

  • Strong communication skills, with an ability to express relevant, technical concepts in a clear and concise manner

  • Ability to see the big picture and effectively analyze complex issues

  • Strong technical ability, willing to learn and evolve your skills with advances in Technology

  • Knowledge of data warehousing and ETL concepts is a plus

  • Experience with Big Data technologies such as Hadoop and Hive is a plus

Our full-time employee benefits include:

  • A competitive compensation package, annual bonus, 401k match

  • Flexible PTO including 7 paid holidays, 1 floating holiday, and 1 volunteer day

  • Employer-paid benefits (medical, dental, vision, health savings account)

  • Professional career development and reimbursement

  • Up to 16 weeks paid maternity leave; up to 4 weeks of paid parental leave

  • Backup childcare offered through Bright Horizons

  • Relaxed casual environment with virtual office events

Amherst is proud to be an Equal Opportunity Employer and committed to creating an inclusive environment for all employees. We do not discriminate on the basis of race, color, religion, national origin, gender, pregnancy, sexual orientation, gender identity, age, physical or mental disability, genetic information or veteran status, and encourage all applicants to apply.

Logos/outerjoin logo full

Outer Join is the premier job board for remote jobs in data science, analytics, and engineering.