The Role
Trading Analysis are striving to become an industry leading analytics team, delivering an exceptional standard of insight to drive strategy for Trading Senior leaders and stakeholders, across all our Digital and Retail Groups.
As a Trading BI Analyst, you will present information for stakeholders through engaging and interactive dashboards, reports and visualisations, geared towards a non-technical audience.
You will interpret project requirements to provide the raw data which powers the insight of the trading analysis function, providing analytical support for high profile business decisions.
Key Responsibilities
Develop and maintain Power BI reports, dashboards and visualisations to meet business requirements
Preparing data sets for analysis by querying the data warehouse or using reporting resources available
Identify, recommend, and implement improvements to existing analytics processes, tools and techniques to assist reshaping the Trading Analysis function from reactive and task-based to proactive and forward-looking
Be directly responsible for the data delivery behind insightful analytical projects that optimally translate into actionable insights
Monitor and troubleshoot report performance and data accuracy and implement solutions to resolve any issues
Manage expectations around data availability and delivery
Collaborate with stakeholders to understand their reporting requirements, providing ad-hoc data-driven solutions to support business decisions
Conduct methodical deep dive investigations into underperforming areas of the business
Develop and maintain documentation for all reporting and data processing activities
Willingness to upskill on the job with exposure to advanced analytics tools
Specialist Skills & Experience
Essential
Strong working knowledge of SQL for querying databases
Exceptional data wrangling skills, comfortable cleaning and preparing large and complex datasets to combine and automate the analytics workflow to produce impactful insights
Experience utilising data visualisation and dashboarding tools such as PowerBI
Methodical and analytical approach to problem solving
Excellent data management skills and experience using Excel at an advanced level
Ability to story tell and clearly articulate trends using data visualisation techniques to efficiently communicate key insights
Added ability to communicate data insights to non-technical audiences
Capacity to learn programming languages
Ideal
Experience using Python or R