CrawlJobs Logo

Commercial Reporting Analyst

johnlewispartnership.co.uk Logo

John Lewis Partnership

Location Icon

Location:
United Kingdom , Bracknell

Category Icon
Category:
IT - Software Development

Job Type Icon

Contract Type:
Not provided

Salary Icon

Salary:

62000.00 - 115000.00 GBP / Year
Save Job
Save Icon
Job offer has expired

Job Description:

Step into a vital role within the fast-paced and ambitious Waitrose Commercial team, where you will impact strategic decision-making and drive significant performance improvements. As a Commercial Reporting Analyst, you will transform complex data into robust analysis, critical insights, and make powerful recommendations for the team. With a relentless focus on our customers, the market, and our branches, you will be instrumental in two key areas: establishing and continuously refining our regular performance reporting, and carrying out analytical insight projects that identify key drivers, risks, and commercial opportunities. We are looking for an adaptable individual fueled by a commitment to getting it right the first time and driven by a continuous improvement mindset, ensuring our Commercial team remains at the forefront of retail success.

Job Responsibility:

  • Provide crucial insights that drive strategic decisions
  • Actively seek and report on data for informed decision-making
  • Ensure your expertise aligns with the latest retail and commercial trends
  • Deliver informed perspectives for the success of the Commercial function
  • Work across a number of disciplines within Commercial to provide the right information to the right people at the right time
  • Ensure the reporting is completed on reliable datasets to a high-quality, working closely with experts across the Partnership to make sure stakeholders have the information they need to drive performance improvements

Requirements:

  • Experience in automation (Javascript/Google Apps script, VBA, XML) and advanced data management and manipulation (SQL, Big Query)
  • Proficient in the use of Google apps (particularly Sheets) and Excel
  • Proficient in the use of Tableau
  • Experience which demonstrates an ability to identify performance improvements
  • Data Analytics and distillation to Insight
  • Storytelling
  • Strategic and Critical Thinking
  • Digital Awareness & Numeracy skills
  • Continuous Improvement
  • Communicating & Influencing
  • Customer & Performance Focus
  • Project Management & Delivery
What we offer:
  • Leisure Learning (£200 towards certain tutored courses)
  • Partner Discount (25% off at John Lewis and 20% at Waitrose)
  • Clubs & Societies
  • Holiday & Leave
  • Pension & Life Assurance
  • Exclusive Hotels

Additional Information:

Job Posted:
May 15, 2026

Expiration:
May 15, 2026

Employment Type:
Fulltime
Work Type:
Hybrid work
Icon
John Lewis Partnership - All Job Offers
Job Link Share:
Copy Link Icon
Facebook Icon Twitter Icon LinkedIn Icon

Looking for more opportunities? Search for other job offers that match your skills and interests.

Briefcase Icon

Similar Jobs for Commercial Reporting Analyst

Commercial Analyst

Reporting to the Commercial Manager, the Commercial Analyst will play a key role...
Location
Location
United Kingdom , Bolton
Salary
Salary:
30000.00 - 35000.00 GBP / Year
hederahiring.com Logo
Hedera Hiring Ltd
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Strong analytical skills, with high proficiency in Excel
  • Excellent organisational skills and ability to prioritise in a fast-paced environment
  • Attention to detail, especially when handling financial or technical data
  • Clear and confident communicator with the ability to present insights accessibly
  • Proactive, inquisitive mindset with a desire to learn and improve
  • Team player who can also work independently when required
Job Responsibility
Job Responsibility
  • Analyse and report data across finance, procurement, operations and commercial teams
  • Streamline processes in areas such as Work in Progress (WIP) and Cost Value Reconciliations (CVRs)
  • Produce KPI dashboards and reporting packs to track performance and targets
  • Oversee commercial controls across live projects, ensuring governance and accuracy
  • Maintain and manage asset value records across all ongoing developments
  • Support pricing strategy, budget control, and cost analysis in collaboration with internal stakeholders
  • Assist with system implementation, including data migration and new process design
  • Contribute to continuous improvement initiatives that enhance commercial performance
What we offer
What we offer
  • Competitive salary with clear scope for progression
  • Healthcare and Mental Well-being Support (cashback for dental, eye-care, prescriptions, etc.)
  • Pension Scheme
  • Gym, Fitness and Retail Discounts
  • “Donate a Day” – one fully paid day annually for charity or community involvement
  • Mentorship and ongoing support throughout your career
  • Employee Assistance Programme (EAP)
Read More
Arrow Right

Senior Commercial Finance Analyst

Take the lead in driving financial strategy at Honey Birdette. As our Senior Com...
Location
Location
Australia , Sydney
Salary
Salary:
120.00 - 140.00 AUD / Month
honeybirdette.com Logo
Honey Birdette
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 3+ Years in a commercial finance analyst role
  • CA or CPA qualified
  • Similar experience in a retail, wholesale, FMCG or similar industry
  • NetSuite, NSPB and Power BI reporting experience advantageous
Job Responsibility
Job Responsibility
  • Automate management reporting to meet group and local requirements
  • Set up and manage the financial planning and analysis software for HB
  • Own and maintain a 12-month weekly cash flow model
  • Own the budget and reforecast process
  • Manage reporting functionality and structure
  • Lead the Monthly Business Review process and prepare the pack for the CFO
  • Provide commercial support for growth opportunities, including lease renewals, new store openings and digital expansions
  • Review FP&A reports and identify opportunities for automation and improvements
  • Supervise and coach junior team members
  • Report on commercial business KPIs
What we offer
What we offer
  • Hybrid Working Arrangements, 3 days in the office and 2 days WFH
  • Birthday, Wellness & Parental Leave
  • Generous Product Discounts
  • Stunning Heritage Listed Sydney CBD Office
  • Paid Premium gym membership
Read More
Arrow Right

Senior Analyst, Commercial Finance

We are seeking a detail-oriented and analytical Commercial Finance Senior Analys...
Location
Location
United States , New York City
Salary
Salary:
95000.00 - 100000.00 USD / Year
hunterdouglas.com Logo
Hunter Douglas
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s degree in finance, accounting, economics or related field (MBA or CPA/CFA a plus)
  • 3-6 years in finance-related roles, preferably in FP&A, corporate finance or similar analytical role
  • Advanced analytical skills with mastery in Excel, SQL, and data visualization tools (e.g., Power BI, Tableau)
  • Experience with ERP systems (e.g. SAP, Oracle, NetSuite) and BI tools (e.g. PowerBI, Tableau) preferred
  • Strong communication and presentation skills, with ability to influence senior stakeholders
  • Detail & results-oriented, with the ability to manage multiple priorities in a fast-paced, matrixed environment
Job Responsibility
Job Responsibility
  • Act as a trusted business partner to Commercial leadership
  • Lead elements of the annual planning, quarterly forecasting & long-term strategic planning processes
  • Provide forward-looking insights, shaping commercial decision-making with clear recommendations
  • Drive in-depth analyses of volume, revenue, and margin profitability across business units, regions, and categories
  • Lead financial assessments of PVM and trade investments, partnering with the Revenue Growth Management team to optimize returns
  • Develop robust, dynamic financial models and frameworks to support high-impact commercial decisions, such as market expansion, new product launches, and promotional effectiveness
  • Develop and deploy dynamic tools and frameworks with sensitivity analysis and scenario planning
  • Design and deliver dashboards and executive-ready reports to track and interpret performance
  • Lead visibility into ZBB (zero-based budgeting) and efficiency initiatives
  • Partner with leaders to support monthly performance reviews and annual business reviews with actionable insights
What we offer
What we offer
  • Bonus target range: Up to 20%
  • Generous benefits package including medical, dental, vision, life, disability
  • A company culture that prioritizes internal development and professional growth
  • Time off with pay
  • 401(k) plan with a degree of employer matching
  • Paid parental leave
  • Wellness programs and product discounts
  • Fulltime
Read More
Arrow Right

Commercial Analyst / Business Development Executive

This role supports global commercial operations through data-driven insights, sy...
Location
Location
United Kingdom , Plymouth
Salary
Salary:
35000.00 GBP / Year
butlerrose.com Logo
Butler Rose
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Proven experience in commercial analytics, business development, or a data-focused role
  • Strong proficiency with Salesforce CRM -experience building reports, dashboards, and workflows is essential
  • Advanced Excel skills, with ability to work confidently with complex datasets
  • Strong analytical thinking with excellent attention to detail
  • Confident communicator able to present complex information clearly
  • Commercially focused with strong problem-solving skills
  • Comfortable working in a fast-paced, dynamic environment
  • Collaborative, proactive, and highly organised
Job Responsibility
Job Responsibility
  • Lead the development, implementation, and ongoing management of a Partner Relationship Management (PRM) system within Salesforce
  • Maintain and optimise Salesforce CRM data accuracy across international markets
  • Build and manage dashboards, workflows, and reports to support distributor and sales operations
  • Act as the key liaison between commercial teams, IT, and external partners for system enhancements and integrations
  • Produce regular commercial and financial reports, including sales performance, KPIs, and market analyses
  • Analyse global trends, pricing data, and market intelligence to identify growth opportunities
  • Support forecasting, target setting, and performance tracking across multiple regions
  • Deliver ad-hoc analytical insights to support decision-making
  • Work closely with regional stakeholders to monitor distributor activity and assess performance against targets
  • Provide insights on market coverage, pipeline conversion, and stock levels
What we offer
What we offer
  • Competitive compensation and professional development opportunities
  • Fulltime
Read More
Arrow Right

Commercial Analyst Assistant

The opportunity has arisen for a Commercial Analyst Assistant to join the Club L...
Location
Location
United Kingdom , Manchester
Salary
Salary:
Not provided
clubllondon.com Logo
Club L London
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Graduate or early-career professional with an interest in finance and data analysis
  • strong skills in Microsoft Excel, particularly Power Query and Power Pivot
  • familiarity with Power BI also valuable
  • high attention to detail and comfortable working with large datasets
  • good communicator, able to work collaboratively and explain findings clearly
  • eager to learn and progress into a commercial/analytical role over time
Job Responsibility
Job Responsibility
  • Support the Commercial Analyst with data preparation and modelling, including building and maintaining Power Query flows and pivot models
  • Manage large datasets in Excel/Power BI, ensuring data is structured efficiently for reporting
  • Assist with reconciliations (e.g. sales, stock, returns, cash) and maintain accuracy of trackers and recurring reports
  • Prepare data and outputs for the Commercial Analyst to use in reporting packs and dashboards, with a view to gradually taking ownership of these over time
  • Support ad-hoc reporting requests from commercial, finance and wider company
What we offer
What we offer
  • 25 days of annual leave (plus bank holidays)
  • Extra day off for your birthday
  • Flexible working hours around core hours of 10-4
  • Early Finish Fridays
  • Cycle to work scheme
  • 40% staff discount
  • Healthcare Cashplan
  • Free onsite gym
  • Annual bonus scheme
  • Social events
Read More
Arrow Right

Commercial Finance Analyst

As a Commercial Finance Analyst, you will play a pivotal role in supporting the ...
Location
Location
Republic of Ireland
Salary
Salary:
Not provided
spectrum.life Logo
Spectrum Life
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Part-qualified or qualified accountant (CIMA, ACA, ACCA, or equivalent) with 2+ years of experience in a similar role (e.g., commercial finance, FP&A, or management accounting)
  • Strong financial modelling skills, with proficiency in Excel and data visualisation tools (Power BI, Tableau, or similar)
  • Experience in supporting commercial decision-making in a high-growth environment
  • Excellent communication and stakeholder management skills, with the ability to distil complex information into clear and actionable insights
  • Ability to work independently and manage competing priorities in a fast-paced environment
  • Experience working in a SaaS or subscription-based business is an advantage
  • Team player and ability to work on own initiative
  • Highly motivated and takes a proactive approach to problem solving
  • Strong analytical ability and excellent numerical skills, with strong focus on accuracy and attention to detail
  • Ability to prioritise to meet business needs
Job Responsibility
Job Responsibility
  • Partner with the Commercial Finance Lead and wider Finance and Strategy teams to deliver accurate and insightful financial analysis, forecasts, and reporting
  • Support commercial decision-making through detailed modelling of new business opportunities, client profitability, and investment cases
  • Develop and maintain financial models and dashboards to provide clear, actionable insights to key stakeholders
  • Conduct monthly variance analysis and provide explanations for key trends and deviations
  • Work with the Commercial team to evaluate commercial deals and tenders/bids, including pricing and contract analysis, as well as rolling revenue forecasts and revenue reporting by key customers
  • Assist in budgeting and forecasting processes, particularly on vendor and department related spend, ensuring alignment with strategic priorities and target
  • Collaborate with cross-functional teams (Sales, Product, Operations, etc.) to drive performance improvements and efficiency
  • Identify and implement process improvements to enhance financial reporting through automated dashboards and data quality
  • Prepare presentations and reports for senior management, board meetings, and external stakeholders as needed
  • Support strategic transactions and other special projects as they arise working closely with both the Commercial Finance Lead as well as Executive Leadership
What we offer
What we offer
  • Full time permanent contract
  • Competitive salary (Dependent on experience)
  • In-office, remote or hybrid working options
  • 25 days annual leave
  • 24/7 EAP and a wide range of health and wellbeing supports
  • Extensive list of employee perks and benefits
  • Fulltime
Read More
Arrow Right

Accelerate Commercial Rotational Analyst

Want to accelerate your career? Join a team of driven people, performing with pu...
Location
Location
United States , Parsippany
Salary
Salary:
70000.00 - 80000.00 USD / Year
avisbudgetgroup.com Logo
avis budget group
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • A bachelor’s or master’s degree in business, Finance, Economics, Marketing Analytics, Business Analytics or related field (Winter 2025 and Spring 2026 graduation)
  • Strong proficiency in Microsoft Excel
  • Superior problem solving and analytical skills – must be resourceful with creative solutions
  • Excellent communication and interpersonal skills, with the ability to work collaboratively with cross-functional teams
  • Ability to work in-office at World Headquarters in Parsippany, NJ
Job Responsibility
Job Responsibility
  • Conducting analysis of market trends, competitor activity, and sales data to uncover growth opportunities
  • Building and maintaining financial models to support pricing, promotions, and sales decisions
  • Reporting insights and analysis to senior leadership to guide key business decisions
  • Collaborating with cross-functional teams, including Marketing and Product, to tackle performance challenges
  • Supporting budgeting and forecasting efforts to ensure alignment with business goals
  • Providing ad-hoc analysis to support evolving business needs
What we offer
What we offer
  • Paid time off
  • Relocation eligible role
  • 401K retirement plan with company matched contributions
  • Access to Medical, Dental, Vision, Life and Disability insurance
  • Eligible to elect other voluntary benefits including: Group Legal, Identity Theft, Insurance, FSA, additional life insurance coverages
  • Contribute up to $260 as a tax-free benefit for public transportation or parking expenses
  • Employee discounts, including discounted prices on purchase of Avis / Budget cars
  • Access to an Employee Assistance Program for services including counseling, financial and legal consultation, referrals for care service, and more
  • Fulltime
Read More
Arrow Right

Commercial Real Estate Analyst

Townhouse Partners is a boutique consulting firm providing commercial real estat...
Location
Location
United States , New York
Salary
Salary:
Not provided
townhousepartners.com Logo
Townhouse Partners Consulting
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Experience working with Excel VBA, Bloomberg Financial Research Portal, and other CRE software and technologies including, but not limited to, REIS, Argus and CoStar
  • Excellent quantitative, organizational, interpersonal, writing and communication skills
  • Self-motivated, team-oriented and strong time management skills
  • Strong research, analytical and problem solving skills
  • Bachelor’s degree in Economics, Finance, Business Administration or Accounting preferred, but all disciplines will be considered
  • At least 2 years of experience in a financial analysis role or related position and/or including at least 1 year of experience in the commercial real estate industry in a research or analytics role. Internship experience in the aforementioned areas is acceptable
  • Knowledge of the commercial loan underwriting process and ability to create underwriting models
  • Familiarity and/or experience with credit rating agency methodologies
Job Responsibility
Job Responsibility
  • Underwriting commercial real estate transactions and preparing market analysis reports
  • Perform complicated financial modeling and spreadsheet analysis in Excel
  • Review and analyze legal documents and third-party reports as part of the due diligence process
  • Review historical CMBS transactions and update market assumptions
  • Create and maintain financial models in Argus
  • Manage multiple client and vendor relationships including communicating via email, phone and at on site meetings
  • Position is currently based in Midtown Manhattan, but may be based on site at clients located in the Metro area
  • Travel required, as needed (< 10%)
  • Additional responsibilities, as needed
  • Fulltime
Read More
Arrow Right