Senior Associate I, Portfolio Analytics

Although we prefer candidates from the NY Metro area, we are also open to East Coast candidates interested in working remotely. 

About you and the role:

The Senior Associate I, Portfolio Analytics, will support the ownership of data and analytics used across Enstar’s Core and Alternative Assets. This includes working with internal and external data sources, identifying critical elements within these sources, transforming the data into a usable format, and loading it into quantitative models for Enstar’s investment portfolio analytics.

What you will be doing: 

Key Accountabilities / Deliverables:

Core Investment Analytics Responsibilities: Capturing and transformation of data from various sources (Clearwater, MSCI, Bloomberg, Excel, CSV files, etc.) within the Investments data warehouse platform (Arcesium) and producing an Investments Book of Record (“IBOR”). Additional responsibilities include supporting modelling of core/non-core assets for performance measurement (including benchmarking and attribution), look-through analysis of Fund of Funds, and implementing various dashboards within Fabric or Power BI in support of Investments Team reporting processes.
Alternative Investment Analytics Responsibilities: Alternative investments data capture, workflow/deal management, and building analytics within Power BI/Fabric model. 

Job Responsibilities:
•    Core Portfolio: Develop, maintain, and validate pipelines for ingesting core assets data within the Arcesium data platform. Transformation of data to produce IBOR for supporting/producing core asset analytics.
•    Alts Portfolio: Develop, maintain, and validate Power BI datasets/dataflows for Alternative Investments within Fabric. Support and enhance the current process of code changes, deployments, and production support, responding to critical business queries.
•    Liaise with key stakeholders - Vendors, Regional and Alternative Investment Teams, Risk, Capital Management, Investment Accounting, and Treasury for investment-related data and forecasts.
•    Develop & maintain reports/dashboards/paginated reports that capture key Investment analytics for Board and Investment Committee (“IC”) materials.
•    Build, maintain, and enhance the Investments Data warehouse (Arcesium) for ingesting data of core assets from various stakeholders. Building pipelines and dependencies within Aquata (Arcesium data management platform) for producing IBOR and supporting/producing key analytics for performance attribution and IC reporting.
•    Work in close coordination with the Alternatives and Non-Core Specialty Mandates team to provide analytical and quantitative solutions for Alternatives and Non-Core investments.

•    Support Head of Investment Operations & Reporting in achieving the Investment team’s overarching mission of identifying, modelling, measuring, and reporting of the investment portfolio strategy, positioning, and performance.
•    Build, maintain, and enhance existing Power BI power queries, DAX measures, datasets, dataflows, online and paginated reports, and dashboards for Alternatives and Core assets. Optimize Alternative investments data pipelines and ensure data quality is pulled from multiple sources into our cloud-based Investment Data and Analytics Platform.
•    Provide solutions to capture, track, and update security master information, commitments schedule by entity, fund documents, call notes, fund returns, manager scorecard data, monitoring status, statement status, compliance status, etc., on private equity funds, co-investments, hedge funds, and long-only funds.   

What you will bring:  

•              
     3-5 years relevant experience in computer or software engineering, applications/systems development, data engineering, data science, data analysis at an investment manager/insurance company, pension plan, endowment, custodian, fund administrator, investments system vendor, investment consultant or financial services firm.
  •    Bachelor's Degree in Computer Science, Engineering, Math, Finance, or Science.
  •    Strong technical, analytical, and communication skills.
  •    Fluent in dimensional and data modelling. Working knowledge of Advanced SQL and building pipelines for ETL processes.
  •    Demonstrable experience and knowledge of Power BI development, including Power Query and Dataflows, designing Power BI datasets, and highly proficient in writing DAX measures.
  •    Data visualization skills in Power BI and demonstrated experience with Conditional Formatting, Tool Tip pages, Drill Through pages, Bookmarks, and Buttons, etc.
  •    Proficiency with Advanced Excel, MDX or CUBE Functions in Excel (CUBSET, CUBEVALUE, CUBEMEMBER), and experience setting up Excel dashboards connected to Power BI datasets.
  •    Exposure to General Asset management for the Insurance industry with knowledge on risk metrics, performance analysis/attribution.
  •    Functional knowledge of alternative investments and analytics such as Commitments, NAV, TVPI, DPI, IRR, Time Weighted Returns, etc. will be a plus.
  •    Proficiency in data storage, query, and reporting/analytics optimization.
  •    Comfortable creating business and technical requirement documents, conducting technical impact analysis, creating development estimates, and assessing project risk.
  •    Ability to read, write, and develop to technical requirements.
  •    Ability to coordinate with external vendors, asset managers, IT support.
  •    Ability to partner closely with Technology, Finance, Treasury, and other functional teams across the company. 
  •    Experience with paginated reports (Report builder). 
  •    Experience with advanced scripting in Tabular Editor 2.0, and knowledge of DAX Studio is a plus.
  Experience with VBA, SQL, Python, SSRS, SSIS and/or other data analysis/programming languages a plus.
  •     Ability to work collaboratively with cross-functional teams and departments. 
  •    Ability to prioritize, manage, and execute on multiple projects in a high-performance, collaborative environment.
  •    Detail-oriented approach and demonstrated track record of problem-solving in a team-based, results-focused environment. 
  •    Passion for continuously improving existing capabilities and a strong desire to help support business growth.
  •    Excellent communication skills.
  •    Progress towards CFA or CAIA is a plus.
  •    Prior experience/exposure working with the Arcesium Data platform (Aquata) is a plus
•     Familiarity with the Clearwater accounting system is a plus.

Your Benefits:

• Enstar offers best-in-class Medical, Dental, and Vision healthcare for single and family coverage.
• Board-certified doctors and pediatricians are available virtually 24/7 for urgent care.
• Access to Health Savings Account (HSA) or Flexible Spending Account (FSA).
• Access to Dependent Care FSA to cover daycare expenses.
• Access to Employee Assistance Programs (EAP) for health and well-being.
• Optional Pet & Home/Auto Insurance.
• Wellness Reimbursement program (up to $600 annual reimbursement for wellness-related expenses, i.e., gym memberships, massage, etc.).
• 401K retirement plan (company matches up to 6% of employee contribution).
• One paid annual volunteer day.

General Info

The target base salary pay range for this role is $106,000-$134,000*

*Target full-time equivalent base salary range is based on relevant market data. The actual salary offered will depend on applicable market data for the hiring location and the relevant candidate's knowledge, skills/experience. This salary range is not inclusive of applicable discretionary incentives.