Lush North America supports more than 270 retail stores in Canada and the USA, and has manufacturing, distribution and online sales facilities located in both Vancouver and Toronto. We're known worldwide for our unique bath and beauty products, amazing skin and hair care, personalized customer service, environmental activism and a fun & funky store atmosphere. We are dedicated to the practices of fair trade sourcing and supporting sustainable communities as well as giving back to organizations that can make a difference through our Charity Pot Program.

The role of BI Developer requires an enthusiastic and industrious individual with the strong ability to learn quickly and multitask effectively in our fast-paced environment. You are a fast learner, acquiring knowledge quickly, and can take ownership of problems and thrive at solving them. 

The successful applicant will provide professional support for the business to ensure they have access to accurate information that they need. The Intermediate BI Developer will be an important part of our Business Intelligence team, working with the various technologies we use at Lush.

Lush thrives with people that can adapt and evolve to the needs of our business. You have a passion for bringing value, leading change, and having an impact on the teams you work with. You are ready to join a business dedicated not only to getting the job done, but also to the practices of fair-trade sourcing, supporting sustainable communities, and giving back to grassroots organizations making a difference. 

Reporting to the Business Intelligence Manager, you will undertake the following RESPONSIBILITIES:

  • Important member of the team responsible for the planning, design, development, deployment and management of data, the data warehouse, BI & analytics solutions
  • Help instill a data-driven culture within the business to leverage data and turn it into information and actionable insights
  • Ensure day-to-day operations run smoothly for the data warehouse, imports, jobs, processes, cubes, reports, data extracts, and security
  • Able to handle several tasks at a time, and able to prioritize tasks and time 
  • Work with the business providing support for questions, investigations, adding/maintaining data
  • Create/modify SQL stored procedures/queries to extract or analyze data 
  • Create and maintain data integrations between various systems 
  • Perform data validation to ensure data accuracy and cleanliness
  • Develop, modify, and maintain reports
  • Use best practices for coding, data management, reporting, and visualization
  • Implement database architecture and physical design based on requirements
  • Perform database server administration including: security, configuration, backup/restore, process monitoring, and accounts management
  • Analyze business and technical requirements and estimate project and task timelines
  • Create documentation as required
  • Work closely with the Technology team, as well as with others in the business such as PM’s/Analysts, across multiple projects and tasks
  • Strong willingness to learn, and apply those new learnings quickly


You bring the following QUALIFICATIONS:


  • 4-5 years’ BI and SQL development experience 
  • Outstanding experience with the Microsoft BI stack: SQL Server, SSRS, SSAS, SSIS, Visual Studio
  • Proven experience coding SQL stored procedures and queries
  • Strong experience importing and exporting data from various sources using SQL/SSIS
  • Experience creating and maintaining reports
  • Experience with data cubes preferred, including adding new tables/columns, partitioning, processing of cubes
  • Basic knowledge/experience working with API’s for retrieving data
  • Strong investigative skills for looking into data problems/issues and resolving them
  • Ability to develop, test, and implement solutions from requirements
  • DBA experience such as managing databases, tables, indexes, data replication 
  • Excellent communication skills and ability to work in a cross-functional environment 
  • Must be a quick learner in a fast-paced environment, acquiring knowledge quickly about the data warehouse, various systems, the data model, and processes
  • Strong team player supporting the BI and Technology team
  • Can work independently with minimal supervision, with good listening skills
  • Some availability outside normal business hours for support as needed 


  • Experience with Power BI (or similar) is an asset
  • Experience working in a Retail or similar environment 


Location: Role will ideally be located in Vancouver or Toronto area but open to successful candidate being remote within Canada. 


Thriving with a diverse company culture, celebrating the uniqueness of our staff and committed to inclusion. We are proud to be an equal opportunity employer.

We thank all interested applicants; however, only qualified candidates will be contacted.

Apply for this Job

* Required

resume chosen  
(File types: pdf, doc, docx, txt, rtf)
cover_letter chosen  
(File types: pdf, doc, docx, txt, rtf)