At a Glance
- Tasks: Design and develop interactive dashboards, automate workflows, and ensure data integrity.
- Company: Join PJT Partners, a leading global advisory-focused investment bank.
- Benefits: Competitive salary, inclusive culture, and opportunities for professional growth.
- Other info: Diverse workplace committed to equal opportunity and career development.
- Why this job: Make an impact with cutting-edge analytics tools in a dynamic team environment.
- Qualifications: 5+ years in data analysis, strong SQL skills, and experience with Power BI.
The predicted salary is between 50000 - 70000 £ per year.
Overview
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.
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
- 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.
Data and Business Analyst in London employer: PJT Partners
PJT Partners is an exceptional employer, offering a dynamic work environment in London where innovation meets collaboration. Our inclusive culture fosters diverse perspectives, empowering employees to grow through meaningful projects and professional development opportunities. With a focus on cutting-edge technology and analytics, team members are encouraged to leverage their skills in a supportive atmosphere that values excellence and creativity.
StudySmarter Expert Advice🤫
We think this is how you could land Data and Business Analyst in London
✨Tip Number 1
Network like a pro! Reach out to current or former employees at PJT Partners on LinkedIn. A friendly chat can give you insider info and maybe even a referral, which can really boost your chances.
✨Tip Number 2
Prepare for the interview by brushing up on your technical skills. Since this role involves Power BI and SQL, practice building dashboards and writing complex queries. Show them you can walk the walk!
✨Tip Number 3
Don’t just focus on your technical skills; highlight your soft skills too! PJT Partners values teamwork and communication, so be ready to share examples of how you've collaborated effectively in the past.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you're genuinely interested in joining the team at PJT Partners.
We think you need these skills to ace Data and Business Analyst in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Data and Business Analyst role. Highlight your experience with Azure data stack, Power BI, and SQL. We want to see how your skills match what we're looking for!
Showcase Your Projects:Include specific projects where you've built dashboards or automated workflows. We love seeing real examples of your work, so don’t hold back on the details!
Keep It Clear and Concise:When writing your application, keep it clear and to the point. Use bullet points for easy reading and make sure to highlight your key achievements. We appreciate straightforward communication!
Apply Through Our Website:Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re serious about joining our team at PJT Partners.
How to prepare for a job interview at PJT Partners
✨Know Your Tools Inside Out
Make sure you’re well-versed in the Azure data stack, especially Power BI, Power Automate, and SQL. Brush up on your DAX and Power Query skills, as you'll likely be asked to demonstrate your ability to create dashboards and automate workflows during the interview.
✨Showcase Your Problem-Solving Skills
Prepare to discuss specific examples where you've tackled complex data challenges. Think about how you’ve used SQL for data extraction or how you’ve implemented automated workflows. This will show your potential employer that you can think critically and deliver solutions.
✨Understand the Business Context
Familiarise yourself with PJT Partners' services and how data analytics plays a role in their operations. Being able to connect your technical skills to their business objectives will demonstrate your understanding of the role and its impact.
✨Ask Insightful Questions
Prepare thoughtful questions about the team dynamics, ongoing projects, or the company’s approach to data governance. This not only shows your interest but also helps you gauge if the company culture aligns with your values.
