Business and Market Intelligence Administrator

City Plumbing; Crick; Hybrid; GBP 30,000 - GBP 40,000; Full time

Job summary

A leading plumbing and heating retailer is seeking a Market and Business Intelligence Administrator in Crick. The successful candidate will manage data integrity and provide market intelligence and insights to empower sales teams. Responsibilities include customer prospect analysis and ensuring billing accuracy. Candidates must have strong IT literacy, excel skills, and a keen analytical mindset. This hybrid role requires UK residency and the ability to travel to the office in Crick several times a week.

Benefits

Bonus

Discounts at retailers

Life assurance

Flexible working options

Mental Health First Aiders

Financial education and loans

Complete induction and growth opportunities

Qualifications

• Combines strong IT literacy with commercial intuition.
• Hands-on experience in CRM or ERP systems.
• Sharp eye for detail to manage follow-up processes.

Responsibilities

• Identify prospect customer and project opportunities.
• Manage customer classification requests for billing accuracy.
• Act as a custodian for data integrity.
• Provide vital data support for Tier 1 accounts.

Skills

Strong IT literacy

Excel expert (VLOOKUPs, Pivot Tables)

Understanding of the sales lifecycle

Analytical problem solving

Ability to communicate complex data simply

Tools

CRM systems

ERP systems

Job description

Overview

City Commercial is recruiting for a Market and Business Intelligence Administrator to serve as part of the analytical driving force behind our Sales teams. You won’t just manage spreadsheets; you will identify hidden opportunities, ensure our data is bulletproof, and help us continue to drive growth in this exciting new business.

This position is the data-driven foundation of our mission to accelerate our presence and growth in the non-residential market. By maintaining high-quality data integrity and providing Sales teams with market intelligence, customer insights, sales opportunities and accurate KPI reporting, you empower our knowledgeable teams to deliver a superior customer experience. You will uncover the insights necessary to develop customer relationships and increase share of wallet through precise transaction analysis and proactive database management.

Responsibilities

• Create the Future: Identify prospect customer and project opportunities, analyse missed transactions using SKU data, build regional market intelligence, and support Sales KPI reporting.
• Be the Customer’s Choice: Manage customer classification requests and reallocate invoices from Residential to Commercial sectors to ensure billing accuracy.
• Make it Safe, for Everyone: Act as a custodian for data integrity, managing the SPM accuracy, the Commercial rebate tracker, and following up on credit limit and payment terms.
• Grow Stronger Together: Provide vital data support for Tier 1 accounts and keep our Sales and Branch teams informed on key customer data and account allocations.

We’re a new team so collaboration for us is really important. While the majority of our roles will be hybrid, there will always be a need for in person interaction. You must be UK Based and prepared to travel to our head office in Crick (Northamptonshire) at least three times a week after training.

Qualifications / What we are looking for

• We are looking for a candidate who combines strong IT literacy with commercial intuition
• Technical Excellence: An Excel expert (VLOOKUPs, Pivot Tables) with hands-on experience in CRM or ERP systems.
• Commercial Awareness: An understanding of the sales lifecycle and how precise data—such as credit limits, trading history, and payment terms—directly informs strategic decisions.
• Analytical Problem Solving: A sharp eye for detail to filter through new prospects (customer and project) and manage follow-up processes that convert raw leads into measurable opportunities.
• Data Translation: The ability to communicate complex data simply, providing clear and actionable reports and insights for our Sales teams.

From boilers to bathroom suites, tubing to towel rails and everything in between, City Plumbing has all the products our customers need to complete the job. And we have all you need to build a successful career! We’re proud of our reputation for selling quality plumbing and heating products to both trade and retail customers and we’re excited about our future. We put our colleagues at the heart of all we do, giving them tools to be successful, happy and rewarded in their career with us.

• Bonus
• Discounts, savings and cash back at numerous retailers
• Life assurance
• Extended family policy including maternity, paternity, additional annual leave and more
• Mental Health First Aiders and Employee Assistance Programme, we look out for each other
• Complete induction and a company that lets you grow and encourages development
• Financial education and loans
• Flexible working options
• A business striving to create an environment of inclusion so everyone can be their true self
• And more!

We’re passionate about creating an inclusive workplace that celebrates and values diversity. Bring your whole self to work regardless of age, disability, gender identity or reassignment, marital or civil partner status, pregnancy or maternity, race, colour, nationality, ethnic or national origin, religion or belief, sex or sexual orientation. We don’t want you to ‘fit’ our culture, we want you to enrich it.

We are committed to best practices in recruitment and undertake Basic Criminal Record Disclosures for candidates that are offered employment within our branches that undertake deliveries for British Gas. This check will only be undertaken after the acceptance of an offer of employment.