At a Glance
- Tasks: Create data-driven solutions and build interactive dashboards using Power BI.
- 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 fostering talent and innovation.
- 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.
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.
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.
- 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: Dormont Manufacturing Co
PJT Partners is an exceptional employer that prioritises a diverse and inclusive work culture, fostering collaboration and innovation within its London office. As a member of the Data and Applications team, you will have access to cutting-edge technology and tools, alongside ample opportunities for professional growth and development in a dynamic environment that values your contributions and insights.
StudySmarter Expert Advice🤫
We think this is how you could land Data and Business Analyst in London
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Dormont Manufacturing Co!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Data and Business Analyst at Dormont Manufacturing Co.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Dormont Manufacturing Co.
✨Apply Directly through Our Website
When you find a suitable opening like Data and Business Analyst at Dormont Manufacturing Co, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Data and Business Analyst in London
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Dormont Manufacturing Co, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Dormont Manufacturing Co. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Dormont Manufacturing Co
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Dormont Manufacturing Co!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
