BI Analyst

Are you a BI Analyst with excellent Development skills? Do you enjoy analysing huge data sets and then improving workstream processes?

If so, then why not join us at City Plumbing in our brand new BI Analyst position.

It is an exciting time to join as our BI Analyst We have recently become a stand alone business and your work as a BI Analyst could play a key role in simplifying and automating processes for our Commercial and Finance teams

Interested? Read on to find out more

The Role:
It is an exciting time here at City Plumbing. We have recently become a stand-alone business and are making real strides in creating an inclusive workplace that celebrates and values diversity.

Due to our new ownership, we have committed to undergoing an acceleration project across our Finance teams and now have a need for a BI Analyst to come and join the business.

This is where you come in

You’ll need to be an effective communicator, someone who loves to get to the route of the problem. You’ll enjoy investigating using your analytical skills, then solving the problem by creating new automated processes and code. Essentially, you’ll make ourFinance Teams’ job, both easier and smoother.

This means you’ll focus on:

- Load, transform, and extract datasets from Google Cloud using Google BigQuery and other Big Data tools.
- Business Partnering
- Perform complex data interrogation, investigation, and reconciliation on data from across different programs.
- Automate reports or processes through the use of Google Cloud or other systems.
- Provide training and assistance to stakeholders to give them the knowledge to generate interactive dashboards or extract ad-hoc datasets.
- Work with a wide range of datasets including Sales, Contract, Customer, Supply Chain and Stock with Finance teams dedicated to each aspect.

This is a hybrid-based opportunity with true flexibility to work from home, but you should be within commutable distance of our newly refurbished offices in Crick, Northamptonshire.

This means you could be based in Corby, Coventry, Hinckley, Kettering, Leamington Spa, Leicester, Loughborough, Lutterworth, Market Harborough, Milton Keynes, Nottingham, Northampton, Nuneaton, Oundle, Peterborough, Rugby, Rushden, Tamworth, Wellingborough,as well as Crick itself.

You:
You’ll live and breathe our passion and hunger to drive forward real change and help make our Finance team a more streamlined place. You’ll be excited to work within a new business that has six market-leading brands and employs over 4,000 employees.

Ultimately, you’ll be someone who wants to make a difference. In return, we will invest in you and help develop your career

Required skills and competencies:

- Solid knowledge of MYSQL/Bigquery or other versions of SQL
- Experience in using Javascript environments.
- Expert knowledge of using Google Sheets or Excel.
- The ability to translate complex technical issues so they are easy to digest by Stakeholders.
- Previous experience working with a data analytics/business intelligence/Management Information team.

You’ll have an analytical mind and be someone who enjoys working alongside senior stakeholders, by showing your initiative and desire to find solutions to problems.

It is highly likely you will have worked in any of the following roles and/or markets, and worked with the following products and/or services: MI Analyst, MI Developers, Reporting Analysts, SQL Analysts, System Finance Analyst, Finance Analyst, Developers,BI Analyst, IT, AppScript, JavaScript, SQL, Construction, Building Products, Retail, Manufacturing, FMCG.

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 careerOur ambitious future plans mean that youare joining the business at a really exciting time - having recently been part of a sale process you would be joining City Plumbing Supplies (CPS) at a really exciting point in our journey to becoming a standalone business, independent of Travis Perkins.

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 futureWe 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 & cultural environment include;
- Discount platform including savings and cashback at numerous retailers.
- Savings on driving lessons, phone bills, gym memberships as well as further benefits.
- Life assurance.
- Family feel, extended family policy including maternity, paternity, additional annual leave and more.
- Mental Health First Aiders and Employee Assistance Programme, let's be there for each other.
- Complete induction and a company that lets you grow and encourages development.
- Financial Education & Loans.
- Flexible working options.
- Striving to create an environment of inclusion so everyone can be their true self.