Performance Reporting and Analytics

Bayview Asset Management•New York, NY

11d

About The Position

The Performance Reporting and Analytics Team is primarily responsible for the calculation and presentation of data supporting marketing materials, fundraising materials, client special reporting requests, internal analytical performance reporting for each respective business’ funds and modelling liquidity needs for the Funds. The group liaises with the investor relations teams, investment team and senior executives. The role focuses on financial information, investment strategy attribution, performance measurement related data, and providing enhanced analytics to both external clients and internally to the investment team and other key stakeholders. The role will be focus on working with large data sets, modelling database structures, developing tools, automation and process optimization to facilitate the accurate and timely production of critical reporting to meet external client and internal executive reporting mandates.

Requirements

Advanced knowledge of Excel and Power Point; financial model preferred and VBA/Macro/SQL/Alteryx experience a plus
Understanding of and ability to calculate and interpret various private equity and hedge fund quantitative metrics
Strong knowledge of various investment products, financing/leverage and complex fund structures
Ability to think outside the box, see the bigger picture and drive transformation
Self-starter, entrepreneurial, and results oriented
Ability to work closely and collaboratively across various teams and interact closely with senior management;
Strong analytical skills and excellent interpersonal and communication skills, including written and verbal
Strong attention to detail and passion for excellence
Ability to work in fast paced environment and handle multiple projects
Undergraduate degree in Finance, Mathematics, Accounting, Economics or equivalent
+7 years of experience

Responsibilities

Data Analytics
Deep understanding of the best practices around structuring dimension and fact tables adhering to a star schema model.
Proficient in SQL, Python, Alteryx and other development languages to facilitate curating strategic data sets and views for investment dashboard creation.
Lead efforts around data governance to allow business stakeholders to leverage the data sets while monitoring ACU usage
Technical lead on data quality control process design, execution, documentation and monitoring
Assist in the tech stack architecture around optimal data flow, data quality control, and optimization within cloud-based infrastructure.
Initialize data processes involving strategy tagging, security master meta data, position level attributes in partnership with Fund Accounting, Investment Operations, Middle Office, Portfolio Management teams, etc.
Leverage cloud based database management solutions such as Snowflake and Sigma.
Performance Analytics and Reporting
Leveraging deep understanding of the data to calculate critical analysis such as Performance Attribution, Return Forecasting, Liquidity Analysis, Hedging Efficacy.
Assist in preparation of monthly materials for C-suite to review Fund performance as well as other Fund Management related topics
Assist in creation of investment and operational dashboards to help scale and automate recurring analytics
Act as subject matter expert in proper calculation methodology to ensure accuracy and consistency in calculation standard for both internal and external reporting
Assist in analytics related to investor level data as well as marketing efforts.
Leverage technology platforms including PowerBi, Sigma, Arcesium to create reporting platforms