Business and Market Intelligence Administrator

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.The Role: 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.Key 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. Whilst the majority of our roles will be hybrid, there will always be a need for in person interaction. So whilst we encourage all applications you must be UK Based and prepared to travel to our head office in Crick (Northamptonshire) at least three times a week after training.You: You are a detail-oriented professional who takes pride in transforming raw information into a "single source of truth". Combining technical mastery with a keen eye for data cleansing, you enjoy the challenge of finding the story behind the numbers to inform business decisions. You are a natural bridge-builder, capable of translating data into clear, insightful, and actionable updates that help our Sales teams to drive growth. Ultimately, you are motivated by accuracy and the knowledge that your work ensures our teams remain the most knowledgeable and proactive in the industry.Skills and competencies We are looking for a candidate who combines strong I.T 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.Us: 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 super excited about our future. We put our colleagues at the heart of all we do, giving them all the tools they need to be successful, happy and feel rewarded in their career with us.Benefits Package and Cultural Environment: BonusDiscounts, savings and cash back at numerous retailersLife assuranceExtended family policy including maternity, paternity, additional annual leave and moreMental Health First Aiders and Employee Assistance Programme, we look out for each otherComplete induction and a company that lets you grow and encourages developmentFinancial education and loansFlexible working optionsA business striving to create an environment of inclusion so everyone can be their true selfAnd 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.