BI Developer (Pentaho)

London, England, United Kingdom · Technology


Winnow Solutions is a sustainable tech company on a mission to drastically reduce food waste and cut food costs for kitchen operators in the process. We are an equal opportunity employer and currently employ a diverse team of 35 employees representing 21 nationalities. We’re ranked by Wired as one of London’s top 10 start-ups. When you join, you’ll be mentored by some of the best in the industry and will have a chance to learn exciting new technologies and put those skills to work on live, production systems everyday.

This is an extraordinary opportunity best suited to talented, high calibre candidates. You will work closely with an exceptional team in an Agile/Scrum environment where collaborative development and coding practices are emphasised. You will have the chance to develop in a fast paced environment and have the satisfaction of seeing your work being rapidly used by customers.

As a BI Developer you will be responsible for development of new Pentaho reports, data cubes and dashboards to support our increasingly sophisticated internal and external users. You will collaborate with our Product Owner and fellow BI developers to achieve this.

You will also have the opportunity to grow with the company. If you excel in the role, you can progress to team lead, scrum master or architect roles.

Absolutely no recruiters please.


About You:

You are a specialist BI developer with 5+ years’ experience and deep knowledge of Pentaho. You will use this knowledge to 1) develop ETL processes to load our data warehouse, 2) extend and enhance our OLAP schema 3) write fast SQL and MDX queries to collect/cache data from the warehouse 4) develop reports and dashboards to present this data to users. You probably have a Computer Science degree and are really passionate, not only about generating valuable insights from data and presenting them beautifully, but also about getting the full SDLC right. You will definitely have experience delivering BI solutions into a release managed production environment.

You will have an eye for good visual design and simple, intuitive presentation of complex data.


Significant experience in creation of Kettle ETL processes to load data from source data stores into a dedicated Pentaho OLAP schema.

Use of Mondrian MDX and data cubes for performant querying of large data sets.

Development of Pentaho pixel perfect reports and drill down dashboards.

Advanced knowledge of database principles, OLAP schema design and performance tuning.

Skills (Mandatory):

Pentaho BA Server (Enterprise Edition)

Pentaho Reporting :- creation of pixel perfect reports.

Pentaho Dashboard Designer

Pentaho Analyzer :- customisation of data cubes and appearance.

Pentaho ETL data integration using Kettle.

Pentaho Mondrian MDX

OLAP Database Architecture and performance tuning of queries.

Advanced SQL (PostgreSQL, MySQL).

Experience with a source control system (Preferably Git/Bitbucket).


Skills (Optional):

Cloud Computing (preferably on Amazon Web Services).


D3 Graphing library

Java Development

Microsoft SSRS / SSIS

Personal Attributes:

Team player: You are a people-person. You love interacting with your peers. You understand that the team is relying on you to get things done and you will do whatever it takes to meet and preferably exceed their expectations. You also know that your team mates have got your back and that you can count on them no matter how tough things get.

Collaborative: You are comfortable cooperating and collaborating with fellow developers.

Excellent Communicator: You are articulate. You communicate clearly in both written and spoken language. You listen attentively; you process and comprehend what you hear. You are also confident enough to ask questions and to clarify ambiguous points.

Fast Learner: You absorb new information quickly, reliably recall and figure out how to rapidly apply it. You have the courage, when appropriate to learn new technology rather than sticking to what you know already.

Good Problem Solving: You are good at finding creative solutions to complex problems.

Enthusiastic and Energetic: You get excited about what you do. You put all of your energy and enthusiasm into your work.

Good Attention to Detail: You take pride in your work. You devote full attention to what you do and you take the time to get things right the first time.


Apply for this job