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 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 Chance 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

📌 Sr. Bi Analyst (India)
🏢 Amherst
📍 India