Senior Data Warehouse Developer - PFS
BlackRock · New York, NY ·
- Work mode
- Hybrid
- Seniority
- Senior
- Employment
- Full time
- Category
- Logistics
- Experience
- 5+ years
- Company size
- 1000+
- Salary
- USD 125,000 – 165,000 / year
BlackRock · New York, NY ·
Build and maintain data warehouse solutions for credit-focused investment teams, integrating loan, CLO, and trading data into reporting and analytics platforms using SQL, Azure Synapse, and Power BI.
About this role
Vice President, IT Data Analytics (PFS)
Company Description
HPS Investment Partners, a part of BlackRock, is a leading global, credit-focused alternative investment manager that seeks to provide creative capital solutions and generate attractive risk-adjusted returns for our clients. We manage various strategies across the capital structure, including privately negotiated senior debt; privately negotiated junior capital solutions in debt, preferred and equity formats; liquid credit including syndicated leveraged loans, collateralized loan obligations and high yield bonds; asset-based finance and real estate. The scale and breadth of our platform offers the flexibility to invest in companies large and small, through standard or customized solutions. At our core, we share a common thread of intellectual rigor and discipline that enables us to create value for our clients.
HPS was established in 2007 as a unit of Highbridge Capital Management, LLC (“HCM”), a subsidiary of JPMorgan Asset Management (“JPMAM”). On March 31, 2016, the senior executives of HPS acquired HPS and its subsidiaries from JPMAM and HCM (the “Transaction”. Following the Transaction, JPMAM retained a passive minority investment in HPS, which was subsequently redeemed in April 2022. In June 2018, affiliates of Dyal Capital Partners made a passive minority investment in HPS. In February 2022, an affiliate of The Guardian Life Insurance Company of America made a passive minority investment in HPS, which was subsequently increased in August 2024. On July 1, 2025, BlackRock acquired the business and assets of HPS, with 100% of consideration paid in BlackRock equity (the “HPS/BlackRock Transaction”).
The HPS/BlackRock Transaction brings together BlackRock’s corporate and asset owner relationships with HPS’s diversified origination and capital flexibility. BlackRock and HPS have formed a new private financing solutions business unit (“PFS”) led by Scott Kapnick, Scot French, and Michael Patterson, creating an integrated franchise with approximately $370 billion in client assets, including $205 billion of private credit assets. This combined platform, which has more than 590 investment professionals and approximately 1,300 employees globally, offers broad capabilities across senior and junior credit solutions, asset-based finance, real estate, CLOs and GP-LP solutions. As part of the HPS/BlackRock Transaction, Scott Kapnick, Scot French, and Michael Patterson have joined BlackRock’s Global Executive Committee, and Scott Kapnick has been appointed as an observer to the BlackRock Board
Department Description
The IT Data Analytics team is responsible for sourcing, processing, distributing data internally and externally. The team covers data needs across all aspects of investment analysis, portfolio management, back-office processing, investor reporting, and regulatory filings. Data Analytics team members collaborate closely with SMEs across Front Office, Back Office, Investor Relations, Tax, Legal, Management Company in delivering data reporting and analytics technology solutions.
Position Description
HPS Investment Partners is seeking a Senior Data Warehouse Developer to join our technology team. This person will be responsible for building data analytics and reporting solutions associated with our Public & Private Loan, CLO and Long/Short Credit trading desks. He/she will be involved in multiple projects, many of which will involve working directly with our Portfolio Management, Operations and Finance teams.
Responsibilities
Specific responsibilities will include but not be limited to the following:
Ownership of the entire lifecycle of mission-critical data delivery applications, including business analysis, design and architecture, development, and deployment
Collaborate with our internal software development team as well as application vendors to develop solutions and integrate vendor products to deliver rich, enterprise-wide software solutions
Enhance the firm’s existing data delivery system, working directly with Portfolio Management teams as well as Operations and Accounting
Projects will include building and integrating data analytics / reporting solutions supporting Senior Management, Investor Relations, Business Development, Front Office PMs/Analysts/Traders, Risk, Operations, and Finance.
Ability to manage offsite and offshore development teams
Develop tools to manage and monitor data flows
Continuously enrich data access and innovate dashboard capabilities
Candidate Profile
8+ years of total relevant experience with at least 5+ years of experience in the financial industry; hedge fund, private debt fund
Data Modelling / Data Warehousing experience
Working knowledge with Microsoft Azure Synapse, Azure Data Factory, Snowflake will be a plus
Excellent MS-SQL query composition skills
Development experience with Microsoft BI platform: Power BI, Power Apps, SSRS etc.
Product knowledge with one or more asset classes (Bank Loans, bonds, credit derivatives, FX forwards) is a plus
Strong written and verbal communication abilities and inter-personal skills
Highest degree of business ethics and professionalism
Strong appreciation for architecture, analysis, problem solving, testing, and agile development
Ability to perform business analysis, as well as manage and maintain various user relationships
Proven experience in team management, mentoring staff, and driving group success.
Demonstrated track record of academic and professional achievement
Bachelor’s or master’s degree in computer science, Engineering, or related field
Degree from a Tier‑I engineering institute (IIT / NIT / BITS / equivalent) preferred
Location
New York, NY
Employment Type
Full-time
Prior to the Transaction, HPS was a subsidiary of HCM, which is a subsidiary of JPMAM, which in turn is a subsidiary of JPMorgan Chase & Co. (together with its affiliates, “JPM”). Immediately following the closing of the Transaction, the portfolio managers and other HPS employees responsible for the investment activities of HPS separated from JPM and continued to be employees of HPS. HPS is no longer deemed affiliated with JPM. AUM for PFS as of September 2, 2025.Note: Effective July 1, 2025, HPS became part of BlackRock. Effective September 2, 2025, Elm Tree Funds became part of BLK and is included within HPS funds. Headcount as of date varies given recent closings of transactions. All AUM of June 30, 2025, except BlackRock non-CLO Leveraged Finance assets (as of August 2025). Represents pro forma combined AUM of HPS funds and BlackRock funds that form Private Financing Solutions (“PFS”) as of June 30, 2025. AUM of heritage HPS private credit funds, related managed accounts and certain other closed-ended liquid credit funds represent capital commitments during such funds’ investment periods and, post such funds’ investment periods, the cost of investment or latest available net asset value (including fund-level leverage but in all cases capped at capital commitments). AUM of liquid credit open-ended funds and related managed accounts other than CLOs represent the latest available net asset value. AUM of CLOs and warehouses represent the par value of collateral assets and cash in the portfolio. AUM of business development companies represents net asset value plus leverage (inclusive of drawn and undrawn amounts) as of the prior month-end. AUM of ElmTree Funds represents the gross assets plus uncalled commitments over a fund’s life with the exception of ElmTree Unity Debt Fund, LP which represents total commitments of the fund. AUM strategy is assigned at the fund level based on target strategy allocations. The AUM for heritage BlackRock funds is calculated as follows: (i) for evergreen funds, commingled funds and mandates in their investment period: as the sum of fee-paying and any non-fee-paying client commitments, and the maximum permissible leverage for any levered vehicles; (ii) for commingled funds and mandates in runoff: as the aggregate of each fund's net asset value, any unfunded commitments to portfolio companies, and drawn leverage as of the reporting date, if any; and (iii) for semi-liquid funds: as the aggregate of each fund's net asset value. In all cases, AUM is inclusive of internal BlackRock allocations. The AUM figures are presented in US dollars. Effective July 1, 2025, HPS became part of BlackRock. Effective September 2, 2025, Elm Tree Funds became part of BLK and is included within HPS funds. Headcount as of date varies given recent closings of transactions.
Our benefits
To help you stay energized, engaged and inspired, we offer a wide range of benefits including a strong retirement plan, tuition reimbursement, comprehensive healthcare, support for working parents and Flexible Time Off (FTO) so you can relax, recharge and be there for the people you care about.
Our hybrid work model
BlackRock’s hybrid work model is designed to enable a culture of collaboration and apprenticeship that enriches the experience of our employees, while supporting flexibility for all. Employees are currently required to work at least 4 days in the office per week, with the flexibility to work from home 1 day a week. Some business groups may require more time in the office due to their roles and responsibilities. We remain focused on increasing the impactful moments that arise when we work together in person – aligned with our commitment to performance and innovation. As a new joiner, you can count on this hybrid model to accelerate your learning and onboarding experience here at BlackRock.
Guidance on AI use for candidates
At BlackRock, AI has long been part of how we work – enhancing decision-making, improving operations, and helping us deliver better outcomes for clients. We encourage candidates to use AI thoughtfully to learn, prepare, and work more effectively; but during our interview process, we want to focus on getting to know you through your own experiences, thinking, and judgment. To support you, we’ve provided guidance on when and how to use AI during our hiring process so you can approach each step with confidence and showcase your best self.
About BlackRock
At BlackRock, we are all connected by one mission: to help more and more people experience financial well-being. Our clients, and the people they serve, are saving for retirement, paying for their children’s educations, buying homes and starting businesses. Their investments also help to strengthen the global economy: support businesses small and large; finance infrastructure projects that connect and power cities; and facilitate innovations that drive progress.
This mission would not be possible without our smartest investment – the one we make in our employees. It’s why we’re dedicated to creating an environment where our colleagues feel welcomed, valued and supported with networks, benefits and development opportunities to help them thrive.
To learn more about BlackRock, please visit Careers.BlackRock.com. We also encourage you to get to know us on LinkedIn, Instagram, YouTube, X, and TikTok.
BlackRock is proud to be an equal opportunity workplace. We are committed to equal employment opportunity to all applicants and existing employees, and we evaluate qualified applicants without regard to race, creed, color, national origin, sex (including pregnancy and gender identity/expression), sexual orientation, age, ancestry, physical or mental disability, marital status, political affiliation, religion, citizenship status, genetic information, veteran status, or any other basis protected under applicable federal, state, or local law. View the EEOC’s Know Your Rights poster and its supplement and the pay transparency statement.
BlackRock is committed to full inclusion of all qualified individuals and to providing reasonable accommodations or job modifications for individuals with disabilities. If reasonable accommodation/adjustments are needed throughout the employment process, please email [email protected]. All requests are treated in line with our privacy policy.
BlackRock will consider for employment qualified applicants with arrest or conviction records in a manner consistent with the requirements of the law, including any applicable fair chance law.