Data and Business Analyst

PJT Partners is a global advisory-focused investment bank. Our team of senior professionals delivers a wide array of strategic advisory, shareholder advisory, restructuring and special situations and private fund advisory and placement services to corporations, financial sponsors, institutional investors and governments around the world. We offer a unique portfolio of advisory services designed to help our clients achieve their strategic objectives. We also provide, through PJT Park Hill, private fund advisory and fundraising services for alternative investment managers, including private equity funds, real estate funds and hedge funds. From the beginning, PJT Partners has firmly believed that having the best people is key to building an enduring franchise. Our perspective was, and remains, that a great team brings in both top tier clients and appeals to a wide-range of diverse, talented colleagues. Fostering an inclusive culture, which welcomes differing perspectives and beliefs, enables us to provide the best advice and insights to our clients. To learn more about PJT Partners, please visit our website at . Role Overview The Data and Applications team builds analytics, AI-powered tools and data infrastructure that connect data, technology and decision-making across the firm. Team members combine finance and business expertise with technical skills in application development, data engineering and data analytics to deliver technology solutions across corporate functions and client advisory. PJT Partners is seeking a highly motivated Data Analytics Developer in our London office as part of the global Data and Applications team. The ideal candidate is a self-driven professional with hands-on experience across the Azure data stack—including Power BI, Power Automate, and Azure Data Factory—along with strong SQL proficiency. This role spans data engineering, reporting, and workflow automation, working cross-functionally with client-facing and corporate teams to design, implement, and support business-critical solutions. Responsibilities Additional responsibilities include: Design, develop, and maintain interactive dashboards and reports in Power BI, translating business requirements into clear, actionable visualizations for stakeholders across the firm Develop and maintain automated business workflows using low-code tools using Microsoft Power Platform and ServiceNow App Builder to streamline operational processes, approvals, and notifications across departments Write and optimize complex SQL queries for data extraction, transformation, validation, and ad-hoc analysis against Snowflake and other relational databases Partner with corporate and business stakeholders, to gather requirements and deliver reporting and analytics solutions. Additionally, support Technology leadership by developing management reporting in Power BI, enhancing operational visibility and enabling data-driven decision-making across the Technology organization. Design, develop, and maintain ServiceNow Reporting Analytics, Workday custom reports and Dashboards. Support Workday/ServiceNow integrations (EIBs, Core Connectors, – as applicable) for reporting and downstream systems. Develop subject matter expertise on key data elements consumed by downstream and upstream applications, ensuring data lineage and accuracy across systems Perform data quality checks, testing, and validation to maintain the integrity of enterprise data assets Provide go-live support, troubleshooting, and root-cause analysis for data and reporting issues Ensure adherence to and contribute to the development of best practices supporting data management standards and governance Qualifications PJT Partners seeks to hire individuals who are highly motivated, intelligent and have demonstrated excellence in prior endeavors. In addition, qualified candidates will possess the following: 5+ years of experience in data analysis, reporting, or data engineering roles Hands-on experience building dashboards and data models in Power BI (DAX, Power Query, and data gateway configuration) Experience with Power Automate for building automated workflows, including integration with Microsoft 365 and third-party services Strong proficiency in SQL with the ability to write complex queries, stored procedures, and perform data modeling (Preferably Snowflake) Ability to quickly understand and formulate application-level requirements pertaining to complex workflows or integration with external systems Experience with Python for data manipulation, scripting, or automation tasks Experience with ServiceNow, particularly around Service Catalog design, ITSM modules (Incident, Change, Problem Management), and Service Portal development Exposure to broader Azure services (Azure SQL, Azure Functions, Logic Apps) Experience working in financial services or professional services environments Experience developing reports and dashboards using ServiceNow, Workday, and business intelligence tools PJT is an equal opportunity employer. We do not discriminate on the basis of, and will consider all qualified applicants for employment without regard to race, color, religious creed, religion, sex, pregnancy, national origin, ancestry, citizenship status, age, marital or partnership status, sexual orientation, gender identity expression, disability, medical condition, genetic information or predisposition, veteran or military status, status as a victim of domestic violence, a sex offense or stalking, or any other category protected by law. PJT Partners also complies with all applicable laws with regard to providing reasonable accommodation of disabilities to applicants. For more information or to request an accommodation, please contact Human Resources. California Applicants: PJT Partners will consider for employment qualified applicants with arrest and/or conviction records in a manner consistent with applicable law including, but not limited to, the San Francisco Fair Chance Ordinance and/or Los Angeles Fair Chance Initiative for Hiring Ordinance. Applicant Privacy Notice: View our Applicant Privacy Notice here. If you are a California resident, please refer to our California Applicant Privacy Notice for further information. *In order to be considered, please ensure your resume/CV is submitted in PDF format.