Business Intelligence Developer
Top Benefits
About the role
Are you a seasoned Business Intelligence (BI) Developer looking to make an impact in a dynamic organization? Factors Group is a large manufacturing company and certified B Corp, searching for a confident BI Developer to join our team and lead the design, development, maintenance, and enhancement of our enterprise BI products, with a strong focus on migrating from on-premise solutions to Azure cloud-based services.
Schedule: Permanent, Full-time
Monday – Friday, 8:00am – 4:30pm (flexible hours)
Hybrid in the office in Coquitlam
In your role, you will be responsible for: BI Solution Design and Development:
- Our current systems are SSIS, SSRS, SSAS ect. You will manage these, and design and implement BI systems to support current and future business requirements.
- Collaborate with data analysts and end users to create and manage data models.
- Work alongside the Data Engineer creating ETL processes and ensure efficient data transformation and loading.
Cloud Migration:
- Lead the migration of on-premise BI solutions (SSIS, SSRS) to Azure cloud-based platforms such as Azure Synapse Analytics and Azure Data Factory.
- Ensure seamless data flow and integration with existing databases and data warehouses.
AI and Data Analysis:
- Manage infrastructure for effective AI deployment and develop AI algorithms to enhance data analysis capabilities.
- Perform data analysis, profiling, and cleansing.
Team and future state:
- Provide coaching and leadership to junior staff.
- Stay updated on trends in new technologies, particularly cloud-based AI technologies.
You have:
- 7+ years of experience with on-prem BI tools like SSIS, SSRS, and strong SQL Server skills
- Experience with Azure Synapse or Data Factory is a plus, but we’re happy to support learning on the job
- Skilled in Power BI, with strong M, DAX, and MDX knowledge
- Comfortable using Python or R for data analysis or machine learning
- Clear and confident communicator in English, both written and spoken
- Works well with different teams and departments
- Strong at solving problems and analyzing technical issues
- Focused on delivering great service to users and stakeholders
- Can handle multiple projects and prioritize effectively
- Always looking for ways to improve how things are done
- Motivated to learn and grow with new tools and methods
What’s in it for you:
- Contribute to a company committed to sustainability and continuous improvement.
- Seeing as this is a small team, you will be instrumental in the migration from on-prem to the cloud. Your ideas will be actioned and decisions followed through
- Freedom to research and choose the tools that suit the business best and implement them
- We are a large company with many business units including corporate, logistics, manufacturing, ect. The solutions you can implement are endless!
You get:
- Health & Wellness Support: Enjoy comprehensive healthcare, personal and health spending accounts, wellness days, employee wellness sessions, and access to the Employee & Family Assistance Program.
- Financial Perks That Grow With You: Company RRSP contributions, loyalty share program or bonuses (for supervisors and above), tuition reimbursement, and referral bonuses.
- Everyday Savings & Rewards: Get a $300 annual credit for company products, employee discounts, exclusive vendor deals, and a free Costco membership.
- Comfort & Convenience: Free onsite parking, bus pass reimbursement, $200 safety boot voucher, and company-provided PPE to keep you safe and comfortable.
- Culture That Celebrates You: From appreciation events and community involvement to core value recognition and fun employee rewards—we make sure your efforts are seen and celebrated.
*This position is open to all qualified applicants who are legally entitled to work in the country in which this job is located. Only electronic applications can be accepted. This position will close when a competitive candidate pool has been identified. We thank you all for your applications and a member of our team will contact you soon. All the best!
All Internal applicants will be given priority for consideration for the first five business days that this position is posted. After that five days, Internal applicants will be considered along with all other applicants; however, are guaranteed at minimum a call from the Talent Acquisition team.* FGOffice
About Natural Factors
As a leading manufacturer of natural health formulas, Factors invests in people, science, and technology to facilitate the delivery of supplements which marry the wisdom of ancient herbal physicians and the science of modern clinical research to enhance the health of consumers worldwide.
Factors is a Canadian family-owned business with head office in British Columbia, operating for more than 50 years. From organic herbal farming in the Okanagan to state-of-the-art manufacturing operations in both British Columbia and Washington State (USA), we ensure reliable standards with extensive quality control testing in our laboratories that are among the finest in North America.
Our Mission statement: To enhance the wellbeing of our customers – through research, development, and delivery of effective nutritional supplements and other health-building products, and to contribute to the lives of our business partners including customers, employees, suppliers and the communities we serve in a cooperative a sustainable manner.
Many thrilling and innovative things are taking place at Factors such as new facilities, new equipment, new processes, and new members joining our team. Last year, we launched a new Core Values Rewards program for staff demonstrating our seven key Core Values: Hard Work/Balanced Life, Innovation & Imagination, Sustainability, Industry leading Quality & Service, Continuous Improvement, Integrity in Leadership, and Passion.
We are proud to have a core group of loyal long term staff as well as dynamic new hires joining our team. We are continuously working with employees to jointly create the type of environment that contributes to the employee experience being both positive and fulfilling.
Factors employees feel responsible for the products we produce and sell. We know we are helping people create better health and we take pride in our socially responsible and environmentally sustainable production practices.
Business Intelligence Developer
Top Benefits
About the role
Are you a seasoned Business Intelligence (BI) Developer looking to make an impact in a dynamic organization? Factors Group is a large manufacturing company and certified B Corp, searching for a confident BI Developer to join our team and lead the design, development, maintenance, and enhancement of our enterprise BI products, with a strong focus on migrating from on-premise solutions to Azure cloud-based services.
Schedule: Permanent, Full-time
Monday – Friday, 8:00am – 4:30pm (flexible hours)
Hybrid in the office in Coquitlam
In your role, you will be responsible for: BI Solution Design and Development:
- Our current systems are SSIS, SSRS, SSAS ect. You will manage these, and design and implement BI systems to support current and future business requirements.
- Collaborate with data analysts and end users to create and manage data models.
- Work alongside the Data Engineer creating ETL processes and ensure efficient data transformation and loading.
Cloud Migration:
- Lead the migration of on-premise BI solutions (SSIS, SSRS) to Azure cloud-based platforms such as Azure Synapse Analytics and Azure Data Factory.
- Ensure seamless data flow and integration with existing databases and data warehouses.
AI and Data Analysis:
- Manage infrastructure for effective AI deployment and develop AI algorithms to enhance data analysis capabilities.
- Perform data analysis, profiling, and cleansing.
Team and future state:
- Provide coaching and leadership to junior staff.
- Stay updated on trends in new technologies, particularly cloud-based AI technologies.
You have:
- 7+ years of experience with on-prem BI tools like SSIS, SSRS, and strong SQL Server skills
- Experience with Azure Synapse or Data Factory is a plus, but we’re happy to support learning on the job
- Skilled in Power BI, with strong M, DAX, and MDX knowledge
- Comfortable using Python or R for data analysis or machine learning
- Clear and confident communicator in English, both written and spoken
- Works well with different teams and departments
- Strong at solving problems and analyzing technical issues
- Focused on delivering great service to users and stakeholders
- Can handle multiple projects and prioritize effectively
- Always looking for ways to improve how things are done
- Motivated to learn and grow with new tools and methods
What’s in it for you:
- Contribute to a company committed to sustainability and continuous improvement.
- Seeing as this is a small team, you will be instrumental in the migration from on-prem to the cloud. Your ideas will be actioned and decisions followed through
- Freedom to research and choose the tools that suit the business best and implement them
- We are a large company with many business units including corporate, logistics, manufacturing, ect. The solutions you can implement are endless!
You get:
- Health & Wellness Support: Enjoy comprehensive healthcare, personal and health spending accounts, wellness days, employee wellness sessions, and access to the Employee & Family Assistance Program.
- Financial Perks That Grow With You: Company RRSP contributions, loyalty share program or bonuses (for supervisors and above), tuition reimbursement, and referral bonuses.
- Everyday Savings & Rewards: Get a $300 annual credit for company products, employee discounts, exclusive vendor deals, and a free Costco membership.
- Comfort & Convenience: Free onsite parking, bus pass reimbursement, $200 safety boot voucher, and company-provided PPE to keep you safe and comfortable.
- Culture That Celebrates You: From appreciation events and community involvement to core value recognition and fun employee rewards—we make sure your efforts are seen and celebrated.
*This position is open to all qualified applicants who are legally entitled to work in the country in which this job is located. Only electronic applications can be accepted. This position will close when a competitive candidate pool has been identified. We thank you all for your applications and a member of our team will contact you soon. All the best!
All Internal applicants will be given priority for consideration for the first five business days that this position is posted. After that five days, Internal applicants will be considered along with all other applicants; however, are guaranteed at minimum a call from the Talent Acquisition team.* FGOffice
About Natural Factors
As a leading manufacturer of natural health formulas, Factors invests in people, science, and technology to facilitate the delivery of supplements which marry the wisdom of ancient herbal physicians and the science of modern clinical research to enhance the health of consumers worldwide.
Factors is a Canadian family-owned business with head office in British Columbia, operating for more than 50 years. From organic herbal farming in the Okanagan to state-of-the-art manufacturing operations in both British Columbia and Washington State (USA), we ensure reliable standards with extensive quality control testing in our laboratories that are among the finest in North America.
Our Mission statement: To enhance the wellbeing of our customers – through research, development, and delivery of effective nutritional supplements and other health-building products, and to contribute to the lives of our business partners including customers, employees, suppliers and the communities we serve in a cooperative a sustainable manner.
Many thrilling and innovative things are taking place at Factors such as new facilities, new equipment, new processes, and new members joining our team. Last year, we launched a new Core Values Rewards program for staff demonstrating our seven key Core Values: Hard Work/Balanced Life, Innovation & Imagination, Sustainability, Industry leading Quality & Service, Continuous Improvement, Integrity in Leadership, and Passion.
We are proud to have a core group of loyal long term staff as well as dynamic new hires joining our team. We are continuously working with employees to jointly create the type of environment that contributes to the employee experience being both positive and fulfilling.
Factors employees feel responsible for the products we produce and sell. We know we are helping people create better health and we take pride in our socially responsible and environmentally sustainable production practices.