Intermediate BI Developer

Summary

Join Lush Fresh Handmade Cosmetics as an Intermediate BI Developer! This role requires a fast learner who can multitask effectively in a fast-paced environment. You will provide professional support to the business, ensuring access to accurate information. As an important member of the Business Intelligence team, you will work with various technologies, contributing to the planning, design, development, deployment, and management of data and BI solutions. You will also help foster a data-driven culture and work on various business projects. This is a full-time, remote position within Canada, with preferred locations in Vancouver or Toronto.

Requirements

• 4+ years BI and SQL development experience
• Experience with the Microsoft BI stack: SQL Server, SSRS, SSAS, SSIS, Visual Studio
• Strong experience coding SQL stored procedures and queries
• Strong experience importing and exporting data from various sources using SQL/SSIS
• Strong experience creating and maintaining reports
• Strong investigative and problem-solving skills
• Ability to develop, test, and implement solutions from requirements
• 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

Responsibilities

• Be an 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
• Work on business projects as needed, including new systems and their required data and processes, changes to existing systems, reporting, etc
• 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, and resolutions
• 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
• 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

Preferred Qualifications

• Experience with data cubes preferred, including adding new tables/columns, partitioning, processing of cubes
• Experience with Power BI (or similar) is an asset
• Basic knowledge/experience working with API’s for retrieving data
• DBA experience such as managing databases, tables, indexes, data replication

Benefits

• Remote within Canada
• Base Salary Range $82,900 — $91,500 CAD