Harnham
SEARCH
Shortlist

BI Analyst

Preston, Lancashire
£35000 - £40000 per annum + benefits
Apply Save job

BI ANALYST
FMCG COMPANY
PRESTON
£40,000 FTC (POTENTIAL TO GO PERM)

An award winning nationally recognised FMCG brand who are family owned are looking to take a more data focused approach to various areas of the business from reporting and financial analysis to sales and customer preferences. They are looking for a BI Analyst to help them structure their data, automate lengthy processes and perform analysis across business areas to drive useful insights.

THE COMPANY

The company is an award winning nationally renowned FMCG company with around 100 or so employees. They are always looking to innovate both with their products and the way they do business which is why their looking to invest in data and analytics.

THE ROLE

If you were to be successful in your application for this BI Analyst your responsibilities would include:

  • Automate data processing tasks in order to save time and add value
  • Using SQL to structure and analyse data in order to provide insights which inform key decision making
  • Combine new and existing data sources in order to feed these insights and also the reports and dashboards being relayed to different business areas
  • Perform a mix of analyses on day to day activities and operational metrics as well as more focused projects such as customer and supply chain to share data which drives efficiency and growth
  • Save time for key stakeholders around the business by providing useful, timely and insightful regular reporting to avoid having to search for these metrics themselves

SKILLS AND EXPERIENCE

In order for your application for the BI Analyst to be successful you will need;

  • Strong experience using T-SQL for the analysis and structuring of data as well as pulling data from a SQL Server DWH
  • Experience using a reporting tool such as SSRS, Phocas etc to design and develop reports and dashboards for various business areas
  • Excellent skills analysing data and providing useful insights to different business areas based on requirements gathered through meeting with the relevant parties.
  • Experience with Excel and analysing financial data

HOW TO APPLY

If you are interested in this BI Analyst role please apply via this site.

KEYWORDS

SQL, Python, Data Visualisation, Domo, Looker, Tableau,

Apply Save job
Send similar jobs by email
106087/EP
Preston, Lancashire
£35000 - £40000 per annum + benefits
  1. Permanent
  2. Business Intelligence

Similar Jobs

Tableau Data Analyst - Fully Remote (UK Based)
Salary

£30000 - £55000 per annum

Location

London

Description

This high growth, fast paced tech start up work with SME's to deliver messaging solutions across the business and to clients

ADD TO SHORTLIST
Business Analyst
Salary

£35000 - £40000 per annum + benefits

Location

Liverpool, Merseyside

Description

An exciting opportunity to join a global gaming business based in Liverpool as a Business Analyst, paying up to £40,000

ADD TO SHORTLIST
MI Strategy Analyst
Salary

£30000 - £38000 per annum + Additional Benefits

Location

Leeds, West Yorkshire

Description

This is your opportunity to join a leading challenger bank within the UK, that is disrupting the way that this space works, truly putting the customer first.

ADD TO SHORTLIST
DATA INSIGHT ANALYST
Salary

£400 - £500 per day

Location

London

Description

This Data Insight Analyst role is a combination of statistical analytics with machine learning techniques.

ADD TO SHORTLIST

Harnham blog & news

With over 10 years experience working solely in the Data & Analytics sector our consultants are able to offer detailed insights into the industry.

Visit our Blogs & News portal or check out our recent posts below.

How Are Data & Analytics Professionals Mapping COVID Trends With Data?

The coronavirus pandemic has impacted industries across the globe. There’s no ignoring that simple fact. This disruption (most notably) caused devastating effects in two strands: to our health and to business operations. As the virus spread, the health and wellbeing of people in society worsened, and businesses felt the strain of projects being placed on hold, and work slowing or completely grinding to a halt. As of the 24th February 2021, the disease has infected more than 112,237,188 people, with 2,487,349 reported deaths. For Data & Analytics professionals, it soon became evident that they could use their skills to help. Using the mass of data available, professionals and researchers turned to big data analytics tools to track and monitor the virus’s spread, along with a variety of trends. Here’s how: Genomics and sequencing Life science is a significant application within Data & Analytics and explores the study of all living things on earth. One particular section of this study looks at the concept of genomic sequencing.  Genomic sequencing is significant as it allows us looks at the entire genetic code of a virus – in this case, COVID-19. Most importantly, the technique means that researchers and analysts can identify dangerous mutations and track movements of specific variants. We know that the UK has the most advanced system for tracing covid variants too. Last year, Britain launched one of the world’s largest coronavirus sequencing projects, by investing £20 million in the Covid-19 Genomics UK consortium. In a group that included NHS researchers, public health agencies, academic partners and the Wellcome Sanger Institute, they set out to map the genetic code of as many strains of the coronavirus as possible. And the buy-in paid off. It took the US approximately 72 days to process and share each genetic sequence, compared with 23 days for UK researchers, according to figures compiled by the Broad Institute with data from Gisaid. Tech giants stepping in Ultimately, your organisation is more agile than you think it is. Regardless of the size of the business, or the industry in which it operates, the sector’s response in applying analysis and data to track the coronavirus was nothing short of miraculous. Google introduced a series of features such as popular times and live busyness, COVID-19 alerts in transit, and COVID checkpoints in driving navigation in order to keep their one billion (and growing) app users safe. They also introduced the COVID layer in Maps, a tool that shows critical information about COVID-19 cases in a given area, allowing their customers  to make informed decisions about where to go and what to do. Apple also released a mobility data trends tool from Apple Maps. This data was shared in order to provide insights to local governments and health authorities so that they could support mapping specific covid trends. These first-hand examples indicate the influence and power of using data to better our understanding of the virus. Before the coronavirus pandemic, professionals, businesses and industries alike worked in siloes. What we have witnessed since has been very much the opposite, as experts quickly came together to begin mapping out data requirements and supporting the world’s focus to improve the public’s health and get businesses back on their feet. Without Data & Analytics, none of this would be possible. If you're looking to take the next step in your career or build out a diverse Data & Analytics team, we may be able to help. Take a look at our latest opportunities or get in touch with one of our expert consultants to find out more. 

Amy Topcakan

Amy Topcakan

25. February 2021

News

Using Data Ethically To Guide Digital Transformation

Over the past few years, the uptick in the number of companies putting more budget behind digital transformation has been significant. However, since the start of 2020 and the outbreak of the coronavirus pandemic, this number has accelerated on an unprecedented scale. Companies have been forced to re-evaluate  their systems and services to make them more efficient, effective and financially viable in order to stay competitive in this time of crisis. These changes help to support internal operational agility and learn about customers' needs and wants to create a much more personalised customer experience.  However, despite the vast amount of good these systems can do for companies' offerings, a lot of them, such as AI and machine learning, are inherently data driven. Therefore, these systems run a high risk of breaching ethical conducts, such as privacy and security leaks or serious issues with bias, if not created, developed and managed properly.  So, what can businesses do to ensure their digital transformation efforts are implemented in the most ethical way possible? Implement ways to reduce bias From Twitter opting to show a white person in a photo instead of a black person, soap dispensers not recognising black hands and women being perpetually rejected for financial loans; digital transformation tools, such as AI, have proven over the years to be inherently biased.  Of course, a computer cannot be decisive about gender or race, this problem of inequality from computer algorithms stems from the humans behind the screen. Despite the advancements made with Diversity and Inclusion efforts across all industries, Data & Analytics is still a predominantly white and male industry. Only 22 per cent of AI specialists are women, and an even lower number represent the BAME communities. Within Google, the world’s largest technology organisation, only 2.5 per cent of its employees are black, and a similar story can be seen at Facebook and Microsoft, where only 4 per cent of employees are black.  So, where our systems are being run by a group of people who are not representative of our diverse society, it should come as no surprise that our machines and algorithms are not representative either.  For businesses looking to implement AI and machine learning into their digital transformation moving forward, it is important you do so in a way that is truly reflective of a fair society. This can be achieved by encouraging a more diverse hiring process when looking for developers of AI systems, implementing fairness tests and always keeping your end user in mind, considering how the workings of your system may affect them.  Transparency Capturing Data is crucial for businesses when they are looking to implement or update digital transformation tools. Not only can this data show them the best ways to service customers’ needs and wants, but it can also show them where there are potential holes and issues in their current business models.  However, due to many mismanagements in past cases, such as Cambridge Analytica, customers have become increasingly worried about sharing their data with businesses in fear of personal data, such as credit card details or home addresses, being leaked. In 2018, Europe devised a new law known as the General Data Protection Regulation, or GDPR, to help minimise the risk of data breaches. Nevertheless, this still hasn’t stopped all businesses from collecting or sharing data illegally, which in turn, has damaged the trustworthiness of even the most law-abiding businesses who need to collect relevant consumer data.  Transparency is key to successful data collection for digital transformation. Your priority should be to always think about the end user and the impact poorly managed data may have on them. Explain methods for data collection clearly, ensure you can provide a clear end-to-end map of how their data is being used and always follow the law in order to keep your consumers, current and potential, safe from harm.  Make sure there is a process for accountability  Digital tools are usually brought in to replace a human being with qualifications and a wealth of experience. If this human being were to make a mistake in their line of work, then they would be held accountable and appropriate action would be taken. This process would then restore trust between business and consumer and things would carry on as usual.  But what happens if a machine makes an error, who is accountable?  Unfortunately, it has been the case that businesses choose to implement digital transformation tools in order to avoid corporate responsibility. This attitude will only cause, potentially lethal, harm to a business's reputation.  If you choose to implement digital tools, ensure you have a valid process for accountability which creates trust between yourself and your consumers and is representative of and fair to every group in society you’re potentially addressing.  Businesses must be aware of the potential ethical risks that come with badly managed digital transformation and the effects this may have on their brands reputation. Before implementing any technology, ensure you can, and will, do so in a transparent, trustworthy, fair, representative and law-abiding way.  If you’re in the world of Data & Analytics and looking to take a step up or find the next member of your team, we can help. Take a look at our latest opportunities or get in touch with one of our expert consultants to find out more.

Henry Rodrigues

Henry Rodrigues

21. January 2021

News

Recently Viewed jobs