At a Glance
- Tasks: Analyse data and create insightful reports to support sales and finance teams.
- Company: Join a well-established logistics business with a focus on growth.
- Benefits: Competitive salary, potential for permanent role, and career development opportunities.
- Other info: Hands-on role with opportunities for process improvement and automation.
- Why this job: Make an impact by turning data into actionable insights in a dynamic environment.
- Qualifications: Experience in analytical roles or relevant degree; strong Excel skills required.
The predicted salary is between 30000 - 40000 £ per year.
Sowena Group have been exclusively retained in supporting an established logistics business with the search for a new Commercial Business Analyst, for a 6 month FTC, but with strong potential to go permanent. The Commercial Analyst will support the Commercial Business Analyst and wider sales and finance teams by preparing reports, analysing data, and maintaining key datasets. This role is suited to someone comfortable using data visualisation tools and manipulating large datasets to create bespoke reporting and analysis using Microsoft Excel. You will assist with performance reporting, costing and pricing analysis, data preparation, and process improvement activities. This is a hands-on role with strong opportunities for career development.
Key Tasks and Responsibilities
- Reporting & Data Analysis
- Support the development and maintenance of regular financial and non-financial performance reports
- Build and update commercial reports, dashboards, and trackers
- Assist in turning raw data into clear insights and visualisations for stakeholders
- Provide ad-hoc analytical support, including performance analysis and basic forecasting
- Commercial Support
- Assist with the preparation and maintenance of costing models and pricing data
- Help monitor sales trends, customer performance, and key commercial metrics
- Support competitor and market analysis activities
- Contribute to the preparation of presentations for stakeholders
- Process Improvement & Systems
- Support continuous improvement of reporting processes and data quality
- Assist with data collection, documentation, and organisation of key systems
- Help develop and enhance reporting automation where appropriate
Person Specification
- Essential
- Previous experience in a commercial or analytical role or degree in Mathematics/Statistics
- Working knowledge of Microsoft Excel (formulas, pivot tables, lookups, charts)
- Comfortable handling and interpreting large datasets
- Strong numerical and analytical skills with excellent attention to detail
- Ability to communicate data clearly and simply
- Proactive, organised, and eager to learn
- Interest in commercial performance, finance, or data analysis
- Desirable
- Exposure to Power BI, Tableau, Qlik, or other BI/reporting tools
- Basic understanding of budgeting, forecasting, or variance analysis
Business Analyst in Portsmouth employer: Sowena Group
Sowena Group is an exceptional employer, offering a dynamic work environment within a well-established logistics business. Employees benefit from a culture of collaboration and continuous improvement, with strong opportunities for career development and hands-on experience in data analysis. Located in a thriving sector, the company provides access to cutting-edge tools and resources, ensuring that team members can grow their skills while contributing to meaningful projects.
StudySmarter Expert Advice🤫
We think this is how you could land Business Analyst in Portsmouth
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend events, and connect on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Prepare for interviews by practising common questions and showcasing your analytical skills. Use examples from your past experiences to demonstrate how you've tackled data challenges and improved processes.
✨Tip Number 3
Show off your Excel skills! Be ready to discuss how you've used formulas, pivot tables, and charts in your previous roles. Maybe even bring a portfolio of your work to impress the interviewers.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive about their job search.
We think you need these skills to ace Business Analyst in Portsmouth
Some tips for your application 🫡
Tailor Your CV:Make sure your CV speaks directly to the role of Commercial Business Analyst. Highlight your experience with data analysis, reporting, and any relevant tools like Excel. We want to see how your skills match what we're looking for!
Showcase Your Analytical Skills:In your application, don’t just list your skills—show us how you've used them! Share specific examples of how you've turned raw data into insights or improved processes. This will help us see your hands-on experience.
Keep It Clear and Concise:When writing your application, clarity is key! Use straightforward language and avoid jargon. We appreciate a well-structured application that gets straight to the point, making it easy for us to see your potential.
Apply Through Our Website:We encourage you to apply through our website for the best chance of being noticed. It’s super easy, and you’ll be able to keep track of your application status. Plus, we love seeing applications come in directly from our site!
How to prepare for a job interview at Sowena Group
✨Know Your Numbers
Brush up on your numerical skills and be ready to discuss how you've used data in previous roles. Be prepared to share specific examples of how you’ve manipulated large datasets or created reports using Excel, as this will show your practical experience.
✨Visualise Your Insights
Since the role involves data visualisation, think about how you can present complex data simply. Bring examples of dashboards or reports you've created in the past, and be ready to explain your thought process behind them.
✨Show Your Proactivity
Demonstrate your proactive nature by discussing instances where you identified a problem and took the initiative to improve a process. This could be anything from automating a report to enhancing data quality—show them you’re eager to make a difference!
✨Engage with Commercial Awareness
Familiarise yourself with the logistics industry and current market trends. Being able to discuss how these factors impact commercial performance will impress the interviewers and show that you’re genuinely interested in the role.
