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, perf... more details
Overview POSITION SUMMARY: 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. ESSENTIAL DUTIES AND RESPONSIBILITIES: Responsible for the driving innovation, development and thought leadership of the following: Calculation of investment related attribution and performance metrics Create, design and maintain complex Excel models to facilitate forecasting, cash flow projection, fee waterfalls, etc. Forecast liquidity needs of the Funds using investment pipeline projections Manipulate large complex data sets and utilize visualization software to synthesize (SQL, Tableau, PowerBI, Alteryx preferred) Calculate and maintain bespoke client return calculations (RoR and IRR) Calculate fund gross/net returns and related metrics Coordinate, create, and review bespoke investor presentations that leverage investment activity and valuations across funds Drive analytics requirements for fundraising efforts by developing and maintaining forecasting models to support various analytical scenarios including projecting performance and evaluating multiple assumptions related to fee structures, expense ratios, leverage Create executive management reporting and dashboards to report and summarize performance Review, contribute and drive process improvement to investor letters, client reporting, marketing materials, DDQs, PPMs and other relevant reporting Work closely with FP&A team forecast and model key financial assumptions and models for management company reporting Work closely with Treasury and Financing groups to develop reporting around cash projections, dry powder and counterparty exposure Drive quality control and process enhancement around ad-hoc reporting and customized presentations based on needs of senior executives and bespoke client requests Identify process gaps and automation requirements as an active participant in meetings; serve as a critical driver of transformation by working with other teams to enact change. Strong working knowledge of tools used to facilitate the production of required reporting Drive implementation of any identified technology solution SKILLS/KNOWLEDGE/ABILITIES: 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 EDUCATION and EXPERIENCE: Undergraduate degree in Finance, Mathematics, Accounting, Economics or equivalent +7 years of experience COMPENSATION and LOCATION: This role will be based in either Bayview’s NYC office or Coral Gables office. Base compensation is expected to be $140-180k with the opportunity for incentive compensation including bonus and deferred compensation. PHYSICAL DEMANDS and WORK ENVIRONMENT: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to sit and use hands to handle, touch or feel objects, tools, or controls. The employee frequently is required to talk and hear. The noise level in the work environment is usually moderate. The employee is occasionally required to stand; walk; reach with hands and arms. The employee is rarely required to stoop, kneel, crouch, or crawl. The employee must regularly lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision, color vision, and the ability to adjust focus. EEOC Bayview is an Equal Employment Opportunity employer. All aspects of consideration for employment and employment with the Company are governed on the basis of merit, competence and qualifications without regard to race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, or any other category protected by federal, state, or local law.