Junior BI Analyst - London/Manchester

Junior BI Analyst required for a leading client based in Oxford. My client is currently seeking a Junior BI Analyst to come on board and support the development of the data warehouse to expand the reporting capabilities and integrate new data sources. You will be responsible for delivering end-to-end reporting solutions to stakeholders and will receive guidance and support from the team.

Hybrid working available at either London, Leeds, Oxford or Manchester Office

The salary for this role is £30,000 - £35,000 per annum

Key Responsibilities:

• Staging & shaping data from multiple data sources into reporting and analytical solutions and integrations
• Developing and maintaining analytics solutions and perform data analysis
• Understand data warehouse modelling and different approaches to take
• Expanding our data warehouse, incorporating new data sources, and building in best-practice warehouse design
• Creation of technical documentation, capturing development, processes & DW changes
• Working closely with the IT department to ensure that the data collection and storage are appropriate and suitable for BI purposes
• Troubleshooting and resolving data-related problems
• Collaborating with colleagues in the Data and Analytics team to deliver dashboard reports
• Engaging with clients (usually but not limited to internal colleagues) to understand their needs, and designing and creating a suitable dashboard report
• Identifying and suggesting improvements in delivery of BI to the company
• Working with all internal departments to identify suitable metrics specific to their departmental operations and wider BI requests
• Identifying new sources of data to be used to grow BI capability
• Identifying new uses of existing data to provide insight to the company

Key Skills:

• Proficiency in SQL
• Knowledge and experience in Data Warehouse Schema design, data modelling and data warehouse systems (preferably Snowflake, but not essential)
• Practical experience with ETL processes and tools

Interested? Please submit your updated CV to Emma Siwicki at Crimson for immediate consideration.

Not interested? Do you know someone who might be a perfect fit for this role? Refer a friend and earn £250 worth of vouchers! Crimson is acting as an employment agency regarding this vacancy