Business Intelligence Analyst

About Us:  Tripalink Corp. is a technology-driven residential brand specializing in co-living and standard apartments tailored for students and working professionals. It delivers a high-quality, economical, and engaging living experience through attentive services and an all-in-one technology platform that centers around the customer. As an important component of improving renters’ journey, Tripalink Corp. launched an App that allows renters to search for apartments, e-sign the lease agreement, manage their home including paying rent, requesting maintenance and cleaning, call community shuttles, use community perks, and sign up for various events etc. With ever-evolving physical living products and technology-empowered operations, Tripalink Corp. can provide the best living experience for its target renters. The company currently manages about 6,000 bed spaces in Los Angeles, Irvine, Seattle, Philadelphia, Pittsburgh, Tucson, Austin, Chicago, San Francisco, and Berkeley.

• Use Python to collect, extract, and process pertinent information from raw datasets of Co--Living business industry regarding rental prices, occupancy rates, current market trends, promotions, and competitors' performances;
• Use SQL for data analysis to identify patterns and relationships and uncover co-living business industry trends in rental prices, occupancy rates and market demands;
• Use Tableau to visualize insights from data analysis, create interactive dashboards and reports and present key metrics and trends to management and investors with charts, graphics, and maps;
• Use Excel to conduct in-depth business analysis to identify and track the return on investment (ROI) for the company’s ongoing housing projects and conduct a property performance review, budget review, and appraisal review to monitor profit and loss;
• Use Python to closely monitor and analyze the national commercial real estate market, including data related to properties, leases, tenants, availabilities, developments, sales, and owners;
• Use Excel to analyze potential business partners and property owners; property purchase price, tax rate, operating expenses, and vacancy rate, calculate investment cap rate, forecast potential investors; expectations of return, and predict their desired asking price.

• U.S. Master Degree in Analytics, Business Analytics or related

SALARY: $110,000 per year

HOURS: 40 hours/week

PLACE OF EMPLOYMENT: 800 South Harvard Blvd, Ste Office, Los Angeles, CA 90005