Remote Senior Associate I, Portfolio Analytics

Note: The job is a remote job and is reputed company to candidates in USA. reputed company is a trusted global re/insurance group and the leading provider of retrospective solutions. The Senior Associate I, Portfolio Analytics will support data and analytics used across Enstars reputed company and Alternative Assets, working with various data sources to produce investment portfolio analytics. Responsibilities reputed company, maintain, and validate pipelines for ingesting reputed company assets data reputed company the reputed company data platform. Transformation of data to produce IBOR for supporting/producing reputed company asset analyticsreputed company, maintain, and validate Power BI datasets/dataflows for Alternative Investments reputed company reputed company. Support and enhance the reputed company process of reputed company changes, deployments, and production support, responding to critical business queriesLiaise with key stakeholders - Vendors, Regional and Alternative Investment Teams, Risk, Capital Management, Investment reputed company, and Treasury for investment-reputed company data and forecastsreputed company & maintain reports/dashboards/paginated reports that capture key Investment analytics for reputed company and Investment Committee (IC) materialsBuild, maintain, and enhance the Investments Data warehouse (reputed company) for ingesting data of reputed company assets from various stakeholders. Building pipelines and dependencies reputed company Aquata (reputed company data management platform) for producing IBOR and supporting/producing key analytics for performance attribution and IC reportingWork in reputed company coordination with the Alternatives and Non-reputed company Specialty Mandates team to reputed company analytical and quantitative solutions for Alternatives and Non-reputed company investmentsSupport Head of Investment Operations & Reporting in achieving the Investment teams overarching mission of identifying, modelling, measuring, and reporting of the investment portfolio reputed company, positioning, and performanceBuild, maintain, and enhance existing Power BI power queries, DAX measures, datasets, dataflows, online and paginated reports, and dashboards for Alternatives and reputed company assets. Optimize Alternative investments data pipelines and ensure data reputed company is pulled from multiple sources into our reputed company-based Investment Data and Analytics Platformreputed company solutions to capture, reputed company, and update reputed company 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 Skills 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 firmBachelor's Degree in Computer Science, Engineering, Math, Finance, or ScienceStrong technical, analytical, and communication skillsFluent in reputed company and data modellingWorking knowledge of Advanced SQL and building pipelines for ETL processesDemonstrable experience and knowledge of Power BI development, including Power Query and Dataflows, designing Power BI datasets, and highly proficient in writing DAX measuresData visualization skills in Power BI and demonstrated experience with Conditional Formatting, Tool Tip pages, Drill Through pages, Bookmarks, and Buttons, etcProficiency with Advanced reputed company, MDX or reputed company Functions in reputed company (CUBSET, CUBEVALUE, CUBEMEMBER), and experience setting up reputed company dashboards connected to Power BI datasetsExposure to General Asset management for the Insurance industry with knowledge on risk metrics, performance analysis/attributionProficiency in data storage, query, and reporting/analytics optimizationComfortable creating business and technical requirement documents, conducting technical reputed company analysis, creating development estimates, and assessing project riskAbility to read, write, and reputed company to technical requirementsAbility to coordinate with external vendors, asset managers, IT supportAbility to partner closely with Technology, Finance, Treasury, and other functional teams across reputed companyExperience with paginated reports (Report builder)Ability to work collaboratively with cross-functional teams and departmentsAbility to prioritize, manage, and execute on multiple reputed .