Sr Associate I, Portfolio Analytics

Job Title: Sr. Associate I, Portfolio Analytics

Location: New York

Working Style: Agile

About You and the Role:

The Senior Associate, Investment Analytics will support the ownership of data and analytics used by quantitative models across Enstars Core and Alternative Assets. This includes working with internal and external data sources, identifying critical elements within these sources, transforming the data into useable format and loading them into quantitative models for Enstars investment portfolio analytics.

Core Investment Analytics Responsibilities: Capturing and transformation of data from various sources (Clearwater, MSCI, Bloomberg, Excel, CSV files etc.) within 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 PowerBI 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 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 current process of code changes, deployments and production support responding to critical business queries.
• Liaise with key stake holders - Vendors, Regional and Alternative Investment Teams, Risk, Capital Management, Investment Accounting, and Treasury for investments related data and forecasts.
• Develop & maintain reports/dashboards/paginated reports that capture key Investment analytics for Board and Investment Committee (IC) materials.

The ideal candidate for this role will have strong hands-on experience of developing and managing investment data infrastructure, reporting using Power BI, and building pipelines that support ingestion of data from various sources. They must possess critical technical skills that are essential for success in the role: Advanced SQL, Power BI / Fabric, DAX, Power queries, and Dashboards/Visualization.

The individual must have a strong desire to build, enhance, and support a next generation asset modeling and analytics engine built on the Microsoft Power Platform (Power BI, Power Apps, Power Automate, Microsoft Teams, and Microsoft Azure cloud). Strong hands-on Power BI development experience is required(Tableau/Qlik/Microstrategy professionals with beginner or limited Power BI / Power Platform experience will not be considered).

What you will be doing:

Key Accountabilities

• Build, maintain, and enhance Investments Data warehouse (Arcesium) for ingesting data of core assets from various stake holders. 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 co-ordination with the Alternatives and Non-Core Specialty Mandates team to provide analytical and quantitative solutions for Alternatives and Non-Core investments.

• Support Head of Portfolio Analytics in achieving Investment teams 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 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, 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 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 co-ordinate 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 a plus.
• Experience with VBA, SQL, Python, Report builder 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 strong desire to help support business growth.
• Excellent communication skills.
• Progress towards CFA or CAIA is a plus.
• Prior experience/exposure working with Arcesium Data platform (Aquata) is a plus.
• Familiarity with Clearwater accounting system is a plus.

Your Benefits:

• Enstar offers best-in-class bundled 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 plant (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 $111,980-$137,175

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

Who we are:

Enstar Group Limited (Enstar or EGL) is a leading global insurance group and the worlds largest standalone consolidator of legacy reinsurance business.

Through our network of group companies, we help others principally other insurance companies release capital by taking over liability portfolios which no longer make strategic sense for them to hold. We create value by better managing these legacy insurance portfolios and strive to generate attractive risk-adjusted returns from our investment portfolio.

Enstars innovative re/insurance solutions help our partners to reduce risk, release capital, dispose of non-core businesses and portfolios, achieve finality and manage claims volatility. In return, Enstar drives earnings through savings arising from our technical excellence and from investment earnings on the reserves we hold.

With around 800 global employees, our network of group companies is positioned across the worlds major insurance hubs and has significant presence in Bermuda, where our headquarters are located, the United States, the United Kingdom, continental Europe, and Australia.

Enstars balance sheet strength is supported through flagship carrier, Cavello Bay, who benefits from strong financial strength ratings of A by Standard and Poors and A Excellent with stable outlook by AM Best.Enstar held Shareholders Equity of $6.1 billion as of 31 December 2024.

For further information about us, visitwww.enstargroup.com.

Our Values:

ENTREPRENEURIAL

Acharacteristic that is core to our culture: we encourage an entrepreneurial spirit, our colleagues have autonomy to shape strategy, innovate new revenue streams and we reward those who are commercially focused.

NIMBLE

We are quick to respond to change. We embrace new technology and new lines of business according to market demands. We grasp new concepts quickly, are able to deliver in a timely manner and can improvise when needed.

SOLUTIONS FOCUSED

We are resilient, successful, have a winning mentality, possess a strong work ethic. We believe in getting it done.

TEAMWORK

Our strength is working together as a Group, across regions, companies and disciplines. We firmly believe the sum of our collective effort, knowledge and ambition will always outweigh our individual contributions. We work as a trusted partner to our clients.

AWARE

We use our knowledge and experience to stay aware of market trends, acquisition opportunities and other influencers that could impact us and our competitors. Our constant awareness means that we are vigilant, innovative and responsive.

RELEVANT

At all times we strive to undertake actions that are relevant to help us achieve our vision, and to ensure we remain a provider of relevant insurance solutions to the market. We have shown a capacity to evolve and will continue to do so in order to ensure our ongoing relevance to the market.

Equal Opportunities at Enstar:

Our annual Inclusivity Index puts Enstar ahead of the industry in terms of diversity and inclusivity. At Enstar, we value all types of diversity. Were an equal opportunity employer and believe that our diversity creates an authentic working culture.We dont discriminate on the basis of age, physical or mental disability, gender reassignment, marriage and civil partnership, pregnancy and carer status, race (including colour, nationality, and ethnic or national origin), religion or belief, sex and sexual orientation.Enstar is committed in providing an accessible recruitment experience for all those interested in working with us. Please let your Enstar Recruitment Partner know if you require any reasonable accommodation during the application process due to a disability to enable you to fully participate in our recruitment process.