Sr. BI Analyst

The Amherst Group's companies are comprised 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.

Job Description (Primary Responsibilities)

• As a BI Analyst, you will play a key role in transforming raw data into actionable insights that drive business decisions.
• Collaborating with business units (e.g., Risk, Finance, Product) to gather reporting requirements and provide analytical support.
• Writing and optimizing SQL queries to extract and manipulate data from complex systems and data warehouses.
• Designing and enhancing Tableau dashboards to communicate KPIs, trends, and financial metrics effectively.
• Working on data ETL processes in collaboration with data engineering teams to ensure smooth data flow and availability for reporting.
• Translating business logic into data-driven solutions by implementing calculations, data transformations, and rules that align with business definitions.
• Developing new metrics and performance indicators to support evolving business strategies and regulatory needs.
• Continuously identifying and driving process improvements across reporting workflows, automation, and dashboard performance.
• Conducting deep-dive analyses to uncover insights related to customer behavior, product performance, risk exposure, and compliance trends.
• Documenting data definitions, business rules, and reporting logic for transparency and consistency.

Desired Skills/Qualifications :

• Minimum 4 years of hands-on experience in a BI Analyst or similar role.
• Expertise in SQL (T-SQL, PL/SQL, or similar) for data extraction and manipulation.
• Strong experience with Tableau, including dashboard design, storytelling, and performance tuning.
• Prior experience working in the Banking or Financial Services industry is mandatory.
• Familiarity with data warehousing concepts, ETL processes, and BI tools.
• Strong analytical thinking and problem-solving skills.
• Excellent communication and stakeholder management abilities.
• Bachelor’s degree in computer science, Statistics, Finance, or a related field.

Soft Skills:

• Strong problem-solving and critical-thinking abilities.
• Excellent communication and presentation skills.
• Ability to work independently and as part of a team.
• Attention to detail and the ability to work with complex data sets.

Preferred Qualifications:

• Proficiency in SQL, Python, VBA, and JavaScript for data analysis, automation, and enhancing reporting functionalities.
• Strong experience with Tableau; experience with other BI tools like Power BI or Looker is a plus.
• Exposure to Databricks for building and managing data pipelines, performing large-scale data processing, and advanced analytics.

Working Shift/ arrangement: US Shift (1:30 PM - 10:30 PM - IST), Flexible - Hybrid working model

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

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.