POSITION RESPONSIBILITIES
Under the direction of the Vice President – Data & Analytics, the Associate – Data Analytics will be responsible in assisting with all aspects of data analytics for the company. Duties include but are not limited to:
- Data Collection and Cleaning
- Understand data from both internal and external sources, able to perform EDA and clean the data
- Design and implement a robust data pipeline, from sourcing, storing, to validating
- Work with functional teams (Investment, Operations, Asset Management, etc.) to identify data needs
- Data Analysis and Reporting
- Run recurring monthly and quarterly reports that provide industry and macro-environment insights
- Perform data analysis and modeling to identify key insights to help decisions and business strategy
- Create customized reports to highlight takeaways, make recommendations and propose action plans
- Collaborate with different teams on projects that improve portfolio performance and work efficiency
- System Integration and Automation
- Design effective user interface/visualization that translate data to a concise and useful format
- Work with IT/BI to automate data input and output through Snowflake, API, and Power BI
- Incorporate strong data governance to monitor data quality, accountability, and implications.
- Continue to improve current data/system platforms and maintain optimal data pipeline architecture
- Research and Presentation
- Perform research through external sources, such as CIQ, S&P Global, Bloomberg, Green Street, etc.
- Perform ad hoc analysis and deep dive that impact business performance (such as legislation/ COVID)
- Summarize key findings for data providers’ (NIC, Revista, etc.) quarterly Webinar and reporting
- Stay current with the latest technology trends and seek innovation
- Utilize PowerPoint and Power BI to create presentations for function teams and senior leadership
- Perform all other job-related duties as requested
POSITION REQUIREMENTS
- Background
- Bachelor’s degree from an accredited university (Master’s preferred)
- Major in Business, Finance, Statistics, Mathematics, or Computer Science
- A 3.0 minimum GPA
- Experience
- 2+ year full-time experience in data cleaning, analytics, modeling, and system integration
- Excellent data analytics skills using Excel, Power Query, Python, R or equivalent
- Good understanding of statistical modeling and machine learning algorithms (Regressions, NN, etc.)
- Knowledge with BI / data visualization tools (Power BI or Tableau)
- Familiar with third-party API integration and cloud-service such as Snowflake
- Skills and Interests
- Self-motivated and driven – passionate about making a difference to make things better
- Growth-mindset – constantly seek ways to improve current status quo and keep learning
- Strong accountability and ownership – do what you say, attention to details for data and reports integrity
- Time-sensitive and strong sense of urgency – deliver things timely and know how to maximize efficiency
- Thrive in a fast-paced and dynamic environment – quickly adapt to changes and deliver results smartly
- Ability to deal with pressure and challenges with a positive mindset
- Excellent team player with a collaborative, forward-thinking and positive mindset that fosters relationships
- Critical thinker that always come prepared with recommendations and potential solutions
- Strong interest in working in real estate, healthcare, and/or investment
