At a Glance
- Tasks: Analyse commercial product performance and provide insights using data.
- Company: Join a dynamic team in the heart of London, focused on innovative solutions.
- Benefits: Enjoy flexible working with 2-3 days in the office and competitive pay.
- Why this job: Be part of a collaborative environment that values data-driven decision making.
- Qualifications: Experience with Power BI, SQL, and Python is essential; analytical mindset required.
- Other info: This role is inside IR35 and offers a 6-month contract with potential for extension.
The predicted salary is between 72000 - 84000 £ per year.
We are looking for a commercial analyst to work closely with our clients' partners to understand requirements and provide collaborative solutions based on commercial and analytical understanding.
Responsibilities:
- To deliver Commercial product performance analysis and insights
- To work closely with Financial Services commercial and Marketing roles to fully understand requirements and provide collaborative solutions
- To identify and understand trends in product commercial performance
- To forecast the impact of new propositions on P&L via a deep understanding of how current product use drives spend & engagement
Requirements:
- Experience creating impact through data driven insights
- MS Suite (Word, Excel, PowerPoint)
- MS Power BI
- Experienced using simple statistics (forecasting, regression, clustering etc)
- SQL, R, Python
Commercial Analyst (Power Bi, SQL, Python) employer: Stott & May Professional Search Limited
Contact Detail:
Stott & May Professional Search Limited Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Commercial Analyst (Power Bi, SQL, Python)
✨Tip Number 1
Familiarise yourself with the latest trends in commercial analysis, especially in the financial services sector. Understanding current market dynamics will help you engage in meaningful conversations during interviews.
✨Tip Number 2
Brush up on your Power BI skills by creating sample dashboards that showcase your ability to analyse and present data effectively. This hands-on experience can be a great talking point in interviews.
✨Tip Number 3
Network with professionals in the field through platforms like LinkedIn. Engaging with others who work as commercial analysts can provide insights into the role and potentially lead to referrals.
✨Tip Number 4
Prepare to discuss specific examples of how you've used SQL and Python to drive data-driven decisions in past roles. Real-world applications of your skills will demonstrate your capability to potential employers.
We think you need these skills to ace Commercial Analyst (Power Bi, SQL, Python)
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience and skills that align with the requirements of the Commercial Analyst role. Emphasise your proficiency in Power BI, SQL, and Python, as well as any experience with data-driven insights.
Craft a Compelling Cover Letter: Write a cover letter that showcases your understanding of the role and how your background fits the company's needs. Mention specific examples of how you've used data analysis to drive commercial performance in previous roles.
Highlight Analytical Skills: In your application, be sure to detail your experience with statistical methods such as forecasting and regression analysis. This will demonstrate your capability to deliver insights and understand trends in product performance.
Showcase Collaboration Experience: Since the role involves working closely with various teams, include examples of past collaborative projects. Highlight how you effectively communicated and worked with others to achieve common goals.
How to prepare for a job interview at Stott & May Professional Search Limited
✨Showcase Your Technical Skills
Make sure to highlight your experience with Power BI, SQL, and Python during the interview. Prepare examples of how you've used these tools to derive insights or solve problems in previous roles.
✨Understand the Business Context
Familiarise yourself with the company's products and market position. Be ready to discuss how your analytical skills can contribute to understanding trends in product performance and forecasting impacts on P&L.
✨Prepare for Scenario-Based Questions
Expect questions that assess your problem-solving abilities. Think of scenarios where you had to analyse data to provide actionable insights and be prepared to explain your thought process.
✨Demonstrate Collaboration Skills
Since the role involves working closely with various teams, be prepared to discuss your experience in collaborative environments. Share examples of how you've successfully worked with others to achieve common goals.