Octopus Investments Business Intelligence Report Analyst in London, United Kingdom
You have a passion for business intelligence and love finding interesting ways to get the business excited about data.
This role is within the Product team and is reporting into the Head of business intelligence.
Responsible for the coordination and management of data quality and compiling detailed statistical BI reports on data for use across the business. This includes maintaining and growing a suite of Qlikview reports and working with the data warehouse team to on-board new data sources from across the business.
The candidate will help move Octopus to the next level in terms of its internal reporting and analysis. This will include provision of BI via mobile technology, cloud based reporting and self-service dashboards. The candidate will interact with every department, and will need to be comfortable working with senior management and functional heads.
Octopus is a fast-growing company with more than 500 employees. Since we launched in 2000, we’ve established market leading positions across financial services, healthcare and energy. Right now we’re in the process of moving from a singular business (Octopus) to a broader group structure incorporating Octopus Energy, Octopus Ventures, Octopus Investments, Octopus Property and Octopus Healthcare.
About the role
This role sits within the Product Team a newly founded division that sits as a conduit between the business and technology. Acting as a single point of contact for the business we channel all requests and provide innovative and reliable solutions to help the business and their clients work smarter and more efficiently. The product team is responsible for agile planning, requirements gathering, managing development resources, testing and sign off of all new releases. This end to end approach gives a much faster time to market for our users.
Job Specific Experience/Technical Skills/Abilities
Outline of skills/experience required
Degree educated preferably in a Technology discipline.
Financial Services Investment Management industry experience highly preferred.
Excellent verbal and written communications skills.
Excellent inter-personal skills, with experience in working with people from all levels of the business.
Proven self-working and motivational skills.
Advanced knowledge of Qlikview development; script writing and front end production.
Technically strong, especially SQL Server 2008 onwards.
Advanced knowledge of T-SQL SQL scripting & debugging (stored procedures, user functions etc.).
Database design (normalisation, performance tuning etc.).
Highly proficient in MS Office suite, especially MS Excel.
Some data warehouse experience.
Must have aptitude and willingness to learn new software and technologies.
Some level of knowledge in VBScript desirable.
Some level of knowledge in Nprint Report Scheduler desirable.
Some level of knowledge in QlikSense desirable.
Customer Obsession - is about putting the customers’ needs at the heart of everything we do. We achieve this by listening, by making the complex simple and by delivering on our promises.
Focus on Impact - is about making things happen. It’s about recognising and avoiding the distractions. And it’s about executing really, really well.
Better & Better - is about having the humility to recognise that everything can be improved. We want a culture where everyone can put forward ideas and where people at all levels seek out, learn from and react positively to feedback.
Personality matters - at Octopus. We want people who are willing to roll up their sleeves, are passionate about what they do, and who retain their humility despite all they achieve. We are honest, open and decent, always.