data analyst in investment banking

PJT Partners is a global advisory-focused investment bank providing strategic advisory, shareholder advisory, restructuring, special situations, private fund advisory, and placement services to corporations, financial sponsors, institutional investors, and governments worldwide. Through PJT Park Hill, it also provides private fund advisory and fundraising services for alternative investment managers.

• Design and own the Snowflake data architecture, including data models, schemas, warehouses, RBAC, and performance;
• Write and optimize complex SQL for extraction, transformation, validation, and ad-hoc analysis;
• Build Python-based pipelines and transformations;
• Design and maintain integrations with upstream and downstream systems via RESTful APIs and Core Connectors;
• Develop subject-matter expertise on key data elements and ensure data lineage and accuracy;
• Implement data quality checks, automated validation, and testing;
• Build and automate departmental workflows, approvals, and notifications using Microsoft Power Platform;
• Integrate Microsoft Power Platform workflows with Snowflake and other systems via APIs;
• Design, develop, and maintain business-facing dashboards and reports;
• Translate business requirements into clear, actionable views for stakeholders;
• Provide go-live support, troubleshooting, and root-cause analysis across data pipelines, APIs, and application layers;
• Uphold best practices, data management standards, and governance across the platform.

• 6+ Years of experience in data engineering, application development, or analytics roles;
• Deep Snowflake expertise in data modelling, schema and warehouse design, performance tuning, and RBAC/governance;
• Advanced SQL skills, including complex queries and stored procedures;
• Working knowledge of full-stack development for data- and business-facing applications;
• Proficiency in Python for data manipulation, scripting, automation, and API/service development;
• Ability to translate complex workflow and integration requirements into application-level solutions;
• Experience in financial services or professional services environments;
• Nice to have: familiarity with Microsoft Power Platform, Azure SQL, Azure Functions, Logic Apps, ServiceNow, and Workday.

• Office role in London, England, United Kingdom.