Enstar Group
Senior Associate I, Portfolio Analytics
New York · Senior
Sponsorship not specifiedDetected 49 days ago
PythonSQLData AnalysisData EngineeringData ScienceData VisualizationAccountingExcelCommunicationProblem Solving
About the role
- 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.
Responsibilities
- Alternative investments data capture, workflow/deal management, and building analytics within Power BI/Fabric model.
- 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.
- 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.
- 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.
- 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.
Nice to have
- Bachelor's Degree in Computer Science, Engineering, Math, Finance, or Science.
- Strong technical, analytical, and communication skills.
- Fluent in dimensional and data modelling.
- 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.
Skills
- Liaise with key stakeholders
Company info
- Although we prefer candidates from the NY Metro area, we are also open to East Coast candidates interested in working remotely.
Apply directly at Enstar Group →Create a free account for alerts like thisView Enstar Group immigration profile
This listing is sourced directly from Enstar Group's careers page and normalized into a canonical job model.