Analyst, Business Intelligence
Amherst is revolutionizing the way U.S. real estate is priced, managed and financed in order to unlock opportunities for all market participants. Driven by data, analytics, and technology, Amherst has a 20-year history of anticipating where the next risks and opportunities are likely to emerge and designing actionable strategies for investors to capitalize on opportunities across residential real estate, commercial real estate and public securities. Amherst, along with its affiliates and subsidiaries, has more than 900 employees, $5 billion under management and approximately $15 billion under advisement and oversight. www.amherst.com.
Amherst is hiring a Business Intelligence Analyst whose primary responsibility will be to provide data analytics and reporting to the various functions within Amherst, specifically focusing on the Capital & Asset Management teams. 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 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
- 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
- At least 1 year of 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 and 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
- Knowledge of at least one other programming language such as Python or R
- Knowledge of data warehousing and ETL concepts is a plus
- Experience with Big Data technologies such as Hadoop 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.