Business Intelligence Data Analyst London/Hybrid
The Juice Plus+ Company is a multi-million-dollar competitor in the health and wellness industry, using a unique combination of direct sales and e-commerce to market our plant-based nutritional products in pursuit of our mission to "Inspire Healthy Living Around the World." We operate in more than 25 countries
Owing to change, we have an exciting, involved role for an experienced tech-savvy Business Intelligence Data Analyst, to join our company during a period of huge change. The role requires someone with expert-level proficiency in SQL, Power BI, data modelling, and analytics, combined with strong technical problem-solving capabilities and the ability to translate complex technical concepts for business audiences. Working within a strong global team, this role will particularly drive strong quantitative analysis, and needs someone who is flexible across technologies, drives innovation and can effectively communicate valuable insights to our leaders.
Your day to day
- Master complex data structures across multiple database environments (SSMS, Snowflake) with demonstrated expertise in advanced SQL query optimisation and automation
- Architect and develop sophisticated business intelligence solutions using Power BI ecosystem (Dashboards, Paginated Reports) and advanced Excel modelling
- Drive deep analytical insights through statistical analysis, predictive modelling, and advanced data visualisation
- Develop complex analytical frameworks to solve mission-critical business problems, particularly around sales force compensation and performance metrics
- Create and maintain advanced reporting systems that transform raw data into actionable business intelligence
- Lead technical discovery sessions with stakeholders to translate business requirements into detailed technical specifications
- Present complex technical findings and recommendations to senior management through sophisticated data visualisation and storytelling
- Optimize existing reports and dashboards for enhanced performance and user experience
You will bring
- Educated to Bachelor Degree or equivalent work experience in a numerate field (Data Science / Business / Economics / Math's / Statistics etc.)
- Min. 5 years BI data analysis experience
- Extensive proficiency in advanced SQL, with particular experience optimising complex queries across SSMS and Snowflake environments
- Expert-level knowledge in data modelling, dimensional design, and database architecture
- Advanced expertise in Power BI ecosystem, including DAX, complex visualisations, and enterprise-level report development
- Proven track record of building sophisticated analytical models and automated reporting solutions in Excel
- Extensive experience architecting and implementing data pipelines for large-scale datasets
- Expertise in designing scalable BI solutions and maintaining technical documentation
- Strong understanding of data warehouse architecture and best practices
- Experience with Visual Studio development environment and source control management
- Strong technical problem-solving capabilities and analytical troubleshooting skills
- Working knowledge of Python/R for advanced analytics and machine learning applications (desirable)
This is a hybrid role, and a great opportunity to join a highly regarded BI function within our ever-evolving business. We look forward to hearing from you!