Senior Data Analyst

Job Description

The Amherst Group (“Amherst”) is a vertically integrated real estate investment, development, and operating platform that aims to reimagine some of the most fragmented and inefficient pockets of U.S. real estate, including single-family residential (SFR), mortgage-backed securities (MBS), and commercial real estate (CRE). Fueled by proprietary technology, deep-rooted expertise and an agile, collaborative approach, Amherst is transforming a slow-to-evolve industry by creating innovative solutions that disrupt the real estate ecosystem from end to end and unlock long-term value for the investors, residents, and communities it serves.

Amherst has over 1,400 employees, $17.4 billion assets under management and has served over 236,000 residents across the U.S. As one of the largest operators of single-family assets in the U.S., Amherst currently manages 44,000+ homes across 32 markets (19 states). Please visit https://www.amherst.com/ for more information.

Job Description

We are looking to hire an experienced Senior Data Analyst to help us keep growing through real-time, data-driven insights and strategic recommendations. You'll be a part of our fast-growing Scattered Site Renovation (SSR) Analytics & Insights team dedicated to providing best- in-class support to our core product, single family rentals. Our SSR Analytics & Insights team oversees all operations related to the acquisition, initial repair and initial leasing for our single-family rental properties.

This candidate will take unstructured business problems and build structure with data to drive insights and improve decision making. This role reports to the Director of Analytics & Insights and will collaborate closely with all business units at Amherst.

Duties and Responsibilities

• Act as primary point of contact for our Merchant Banking organization
• Support reporting and analytical initiatives for the Merchant Banking organization
• Work directly with business owners to identify business problems that can be solved leveraging advanced analytics or automation
• Transition manual tasks and legacy on-premise data to Databricks
• Collaborate directly with business leaders and technology in developing descriptive, diagnostic, predictive and prescriptive analytic solutions
• Interact with other technology teams to prepare and automate recurring /ad-hoc reporting assignments and data requests
• Leverage analytical problem-solving skills in working with large disparate, datasets to design, develop and implement operational reports and metrics
• Present findings and recommendations to business leadership

Required Experience

• Bachelor’s degree in Management Information Systems, Finance, Mathematics, Economics, Computer Science, Engineering, or related quantitative discipline. Experience direct related to the job duties can be substituted for educational requirements.
• 3+ years’ experience in Investment Banking industry
• 5+ years’ experience analyzing data, drawing conclusions, and making recommendations; financial services / investment banking industry experience is preferred
• 5+ years of SQL experience, Databricks, SQL Server, Spark SQL.
• 3+ years of Python experience, Databricks, PySpark
• 3+ years of Databricks experience
• Experience providing actionable insights by uncovering the stories contained in data
• Experience with presenting management dashboards and reports
• Experience communicating technical and non-technical requirements to business and technology team
• Ability to be flexible and work in a fast-paced environment while meeting established timelines
• Strong written and verbal 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, willingness to learn and passion to evolve your skills with advances in Technology
• Analytical mindset and passion for gleaning actionable insights from raw data

Job Type: Full-time

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid holidays
• Paid time off
• Parental leave
• Vision insurance

Experience level:

• 4 years

Schedule:

• 8 hour shift
• Monday to Friday

Ability to commute/relocate:

• Austin, TX: Reliably commute or planning to relocate before starting work (Required)

Experience:

• SQL: 1 year (Preferred)

Work Location: In person